Theseekers
Technical User
Hello Tekers,
I am new to DTS and working on a simple task that involves using it. I do have a few questions on DTS and hope that some 1 can help me out (TIA)
I am trying to move (or copy) a database from 1 server to another. I used the DTS wizard to do this and what I seen so far is that it is copying all the tables but after that it failed (citing that it could not find a table in one of the store procedure). I then try to backup up the database using the backup mechanism within SQL, and I am ok with this methods.
My questions are:
1. When using DTS to move database, does it actually parsing or checking the syntax of store procedures and view????. Based on what I've seen; that what it is doing
2. Is there a way that I can see what DTS is doing while copying or moving object from 1 database to another. The only indication that I've seen so far is when it moves tables but nothing else...
TIA..
I am new to DTS and working on a simple task that involves using it. I do have a few questions on DTS and hope that some 1 can help me out (TIA)
I am trying to move (or copy) a database from 1 server to another. I used the DTS wizard to do this and what I seen so far is that it is copying all the tables but after that it failed (citing that it could not find a table in one of the store procedure). I then try to backup up the database using the backup mechanism within SQL, and I am ok with this methods.
My questions are:
1. When using DTS to move database, does it actually parsing or checking the syntax of store procedures and view????. Based on what I've seen; that what it is doing
2. Is there a way that I can see what DTS is doing while copying or moving object from 1 database to another. The only indication that I've seen so far is when it moves tables but nothing else...
TIA..