PLans for DTS-compare?
Brian Donahue
Posts: 6,590 Bronze 1
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" <No@Thanks.com> wrote in message news:cTatL3uAEHA.1220@server53...
> 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
>
>
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" <No@Thanks.com> wrote in message news:cTatL3uAEHA.1220@server53...
> 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
>
>
This discussion has been closed.
Comments
Good point.
Brian Donahue
Red Gate Technical Suport
"Fred" <No@Thanks.com> wrote in message news:e4j$iI6BEHA.3000@server53...
> 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)" <brian.donahue@red-gate.com> wrote in message
> news:NFpN0$sBEHA.1468@server53...
>
> > 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)...
>
>
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
======================
Principal Consultant
bartread.com Ltd
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
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.