Competition: What’s your favorite Redgate tool? Enter now.

PLans for DTS-compare?

Brian DonahueBrian Donahue Posts: 6,590 New member
edited November 28, 2005 5:18AM in DTS Compare 1.x
Hi Fred,

The future of DTS Compare depends on how many people continue to use it
after SQL Server 'Yukon' comes out, to be perfectly honest. From what
Microsoft has said publicly, DTS doesn't have much of a future, as they're
going to .Net assemblies rather than DTS scripts and ActiveX Objects.

Regards,

Brian Donahue
Red Gate Software Support

"Fred" <[email protected]> wrote in message news:[email protected]
> LS,
> Are there any plans to improve DTS-compare? I would like to be able to
> synchronise DTS-packages, jobs an logins. Only point here is that the
> compare/sync should understand that a connection to the server itself (in
> jobs and packages) should be synchronised as a connection to the other
> server itself...
>
> Suppose I have a DTS which exports a table from server
> DB1
> to a file
> \DB1FileshareTable.csv
>
> When I sync this to DB2, I would like to export a table from server
> DB2
> to a file
> \DB2FileshareTable.csv
>
> This shouln't be that hard. And even if it can only produce the scripts, I
> could work those out myself (search&replace)...
>
> Regards,
>
> Fred Schenk
>
>

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    Hi Fred,

    Good point.

    Brian Donahue
    Red Gate Technical Suport

    "Fred" <[email protected]> wrote in message news:[email protected]
    > Hello Brian,
    > Yukon has been delayed (once again) so I don't expect it for another year.
    > And then everybody has to upgrade...At my current job I'm in the middle of
    > an upgrade from SQL 7 to SQL 2000, so I don't think SQL 2005 will be used
    > there in another 3 year...More than enough time for us to use some
    > DTS/Job-synchronisation tool.
    >
    > Regards,
    >
    > Fred
    >
    > "Brian Donahue (Red Gate)" <[email protected]> wrote in message
    > news:[email protected]
    >
    > > The future of DTS Compare depends on how many people continue to use
    > it
    > > after SQL Server 'Yukon' comes out, to be perfectly honest. From what
    > > Microsoft has said publicly, DTS doesn't have much of a future, as
    they're
    > > going to .Net assemblies rather than DTS scripts and ActiveX Objects.
    >
    > > "Fred" wrote
    >
    > > > Are there any plans to improve DTS-compare? I would like to be able to
    > > > synchronise DTS-packages, jobs an logins. Only point here is that the
    > > > compare/sync should understand that a connection to the server itself
    > (in
    > > > jobs and packages) should be synchronised as a connection to the other
    > > > server itself...
    > > >
    > > > Suppose I have a DTS which exports a table from server
    > > > DB1
    > > > to a file
    > > > \DB1FileshareTable.csv
    > > >
    > > > When I sync this to DB2, I would like to export a table from server
    > > > DB2
    > > > to a file
    > > > \DB2FileshareTable.csv
    > > >
    > > > This shouln't be that hard. And even if it can only produce the
    scripts,
    > I
    > > > could work those out myself (search&replace)...
    >
    >
  • Bart ReadBart Read Posts: 997 Silver 1
    Hi Fred,


    Thanks for your comments. DTS Compare is now back in active development and whilst I can't go into specifics about exactly what it will do I can say that it will work much better than it currently does in terms of performance, memory utilisation, and usability.

    It looks like SQL Server 2005 will incorporate DTS, although under a different name (Integration Services?) which I believe we might be supporting at some point, although this is obviously some way off.

    At the moment we're just in the early stages of deciding what to do and putting together a development team for the product so I really can't be very specific about anything as I said above. However, if you have any additional feedback, questions, feature requests or other comments please feel free to contact me at bartdotreadatredhyphengatedotcom.


    Many thanks,

    ======================
    Bart Read
    Software Engineer
    Red Gate Software Ltd
    ======================
    Bart Read
    Principal Consultant
    bartread.com Ltd
  • Im currently struggling with Sync and deployment of dts packages. across distributed servers

    What would be great is if a sync fails and a new version is required we can deploy the new version demoting the old version into the existing package version/history.

    Im getting version numbering using a static global variable in the dts package itself.

    Colin Robinson
  • Brian DonahueBrian Donahue Posts: 6,590 New member
    Hello Colin,

    The next version of DTS Compare should allow for comparing multiple versions of packages rather than only the current version available on the server. If I understand you correctly, this should help you out a bit.
This discussion has been closed.