dbTalk Databases Forums  

transfering between servers SQL 2005

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss transfering between servers SQL 2005 in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
jaylou
 
Posts: n/a

Default 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?


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.