Hi,
I am trying to use SQL Server 2005 Enterprise Edition to copy tables from my local server to my hosts server at brinkster.com. In the old version you could use DTS, but everything seems to have got far more complicated now!
Please can anybody guide me in the right direction?
Thanks a lot.
Now you can use SSIS package instead of DTS package, which can also be generated by using Import/Export Wizard as DTS
Yes it is more complex than DTS, but much more powerful, you can start from here:
http://msdn2.microsoft.com/en-us/library/ms141134(d=ide).aspx
When you talking about copying table between servers, do you mean to copy data as well or just copy table schema? If you only want to copy table schema, you can easily do this by generating scripts for the tables on the source server: simply right click a database->choose Tasks->Generate Scripts.
If you want to copy data as well, Import/Export Wizard is your good friend; or you can backup the databases on the source server then restore from the backups on the destination; or you can even use Copy Database Wizard.
|||Thanks a lot lori_Jay, it's much easier when you know what you're looking for! It turned out I hadn't installed all the necessary components. Best to always do a full install if you have the space I guess.
Thanks again.
No comments:
Post a Comment