Transfer Data from one SQL Server Database to Another

[mepancha]

Hi,
We would like to transfer data from one SQL Server database to another, both the database are sitting in different servers and are of the same version SQL Server 2000. Please let me know the method to transfer data, should I be using DTS or is there any other simple method that can be used.In Oracle this could be achived using Database link, wanting to know if there was something equivalent to that in SQL Server. We are looking of transferring only 10,000 records one time and on a daily basis we would like to transfer about 100 records.

Thanks in advance.

 

[Catadmin]

Use the DTS Import / Export Wizard. As long as the servers can see each other on the network, you should be fine.

You can look this up in Books Online, but it's pretty self explanitory. Right click the DB in question, go to All Tasks -> Export Data and follow the popup window prompts. Source connection is first, Destination connection is second, then it asks you what kind of transfer to do (I usually leave it on the default for a SQL to SQL transfer), then you choose your tables. You can schedule it to run regularly, run it immediately and / or save the package for future use.



Catadmin - MCDBA, MCSA
Beware the error of pre-emptive poultry inventory!