Hi

i am thinking of developing Database Synchronization tool using DTS
(Data Transformation Services's API's), VC++ 6, and SQL Server.

i want to achieve functionality like "Reporting differences between
tables, indexes, columns of two data bases and generating scripts to
bring them in sync."


Could anybody please guide me in the following directions...

1- How to start with data transformation services in vc++, is there
any sample or code snippet.

2- Is it necessary to install SQL Server at my PC where i m using DTS
API's or not.

Thanks in advance...

Mujtaba

To be honest I can't see why you would bother. There are plenty of tools
that already do this, some free, and many very good ones for a small cost.
I also do not think DTS is the best tool, DMO would be better. The inline
answers below will apply to DMO as well as DTS.

"Mujtaba" <tomujtaba (AT) hotmail (DOT) com> wrote

product. DTS is just a COM object model, add a reference to the DTS Package
Object library for the core stuff.

Yes. DTS is COM therefore you need at least the DTS DLLs on your local dev
box. I suggest installing the full tools. You don't need a server locally
though.


--
Darren Green
http://www.sqldts.com