Recommend Book on SQL Server/DTS

[mamartin]

Shortly, I will begin a project to merge 2 SQL databases together. The databases are for the same application, just for 2 different customers. Can anyone recommend a good book on DTS or overall SQL Server that covers data migration/consolidation?

Thanks in advance,

Michael A. Martin

 

[johnherman]

Microsoft SQL Server 2000 DBA Survival Guide, by Spenik et al, currently available used at Amazon for about 10 bucks

Microsoft SQL Server 2000 Data Transformation Services by Peterson

SQL Server DTS, by Samuelson, currently available used at Amazon for about 10 bucks

Sometimes the grass is greener on the other side because there is more manure there - original.

 

[JayKusch]

My favorite would be ...

Microsoft SQL Server 2000 Data Transformation Services DTS
by Timothy Peterson

Other that I refere to quite often are ...


DTS Developer's Guide by Brian Lawton

AND ...

Microsoft SQL Server 2000 DTS Step by Step
by Carl Rabeler




Thanks

J. Kusch

 

[mamartin]

Thanks for the feedback. One critical thing I forgot to mention was that I am still using SQL Server 7.0. Is there much difference between 7.0 and 2000? Will I still gain benfit from the 2000 DTS books, or will it be a waste of time/money?

Thanks,

Michael A. Martin

 

[JayKusch]

You should gain from these books. I would say 98% of the core features you have use of in SS7 version of DTS are still the same in SS2K.

Thanks

J. Kusch

 

[johnherman]

With Yukon, however, it will be much more feature intensive. I think Microsoft is going after Informatica with the enhancements to DTS for Yukon.

Sometimes the grass is greener on the other side because there is more manure there - original.