dts fail

Hi y'all,

I'm facing a database data transmission problem during synchronysing. When dts fails i need a better solution instead inconsistent data.

I'm looking for data comparer for sql server where i have total control of my actions.

Any suggestions.

THanks in advance!

DTS should not be synchronizing your database because that is job of replication but the rest of your post says what you need is SQL Compare, there are third party tools and Microsoft have one so test drive it. If you think you need replication all I have to tell you is get a very good book or you can run into serious problems. Hope this helps.

http://msdn2.microsoft.com/en-us/teamsystem/aa718667.aspx

|||

so i need a database compare tool that generates a script...Thanks!

sql