Do you Trust in DTS?

[meny21]

Hi guys!

I'm new in DTS trying to pass one Database to another Database (both in SQL Server 7.0)

Do you think we can trust in DTS in "Copy objects and data between SQL Server Databases" ?

I have to copy some New Stored Procedures, tables and Views to other Database, but I have to take care in not to pass others because I can replace originals in the destination Table.....

Some guys tell me that is better to use scripts to transfer this things, what do you think which is the most trustable function to transfer?

Thank you guys!

 

[EdwinGene]

Try it and check the results. Scripts are the established, tried-and-true way of doing it because that's was the only way to do it before DTS. DTS is the new way.

Try DTS. See for yourself if it works. Positive experience is the best trust builder.

 

[dbomrrsm]

Ive never had problems with DTS in doing what you say. In essence all DTS is doing is creating the scripts that used to be the tried and trusted way !

[blue]DBomrrsm[/blue]