transfering between servers SQL 2005 -
05-01-2006
, 09:14 AM
I have been using the 2005 management studio and when I transfer data between
two servers there is no way to make sure I am transfering the correct way.
Using SQL2000 EM, there is a summary that shows Source and destination
before you hit the final button. in 2005 the summary only shows the tables
being moved.
This is the summary screen from 2005:
Click Finish to perform the following actions:
Copy rows from [PAStates].[dbo].[CSOAWORK] to [PAStates].[dbo].[CSOAWORK]
The new rows will be appended to the existing table.
The package will not be saved.
The package will be run immediately
Is there a way to make sure I am moving the data correctly without having to
hit the back button to make sure the source and destinations are correct? |