Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
blackX
Posting Yak Master
102 Posts |
 Posted - 2008-04-14 : 12:15:47
|
| I need to transfer sample data from one server (running MSSQL 2000) to another using running MSSQL 2005 express. How can I do this? |
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2008-04-14 : 12:23:15
|
| Linked servers and DTS should work. Or linked servers and "insert into server1.dbname1.dbo.table1 select from server2.dbname2.dbo.table2. You'll need the four part naming convention for that. Or, if it's all the data, how about a backup and restore of the entire database?Terry |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-14 : 12:25:21
|
| or even adhoc queries using OPENROWSET() or using export/import wizard will help you transfer data to new server. |
|
|
|
|
|
|
Transfer data from one database to another