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 |
|
Jster
Starting Member
21 Posts |
 Posted - 2006-11-09 : 08:27:16
|
| I have about 100 seperate databases that have a certain tables in them that I want to move from one SQL Server to another. I'm kind of new to this and thought that I could write a script that could do this. The server I am transferring it from is a SQL 2000 server and the new one is a SQL 2005. Any information is appreciated.Thanks,Josh |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-11-09 : 08:50:54
|
| Do you want to transfer table structure or data also?You can generate script for the tables and run that on another server.Also, you can use DTS or BCP or BULK INSERT to transfer the data.Harsh AthalyeIndia."Nothing is Impossible" |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-11-09 : 08:52:07
|
if you are transferring the structure, you can use ENTERPRISE MANAGER to script out the tables into script file. And run the script file in SQL 2005
KH |
|
|
|
Jster
Starting Member
21 Posts |
Posted - 2006-11-09 : 11:10:21
|
| I am also wanting to copy over data that already exist, and in new databases i'll just create the table.Thanks,Josh |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-11-09 : 12:12:25
|
you can use DTS or BCP out and BCP in
KH |
|
|
|
Jster
Starting Member
21 Posts |
Posted - 2006-11-09 : 13:55:05
|
| Thank you, that works! |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-11-10 : 04:22:30
|
| Backup & Restore - and then perhaps drop anything no longer required?Kristen |
|
|
|
|
|
|
Transfer Database and some Tables