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 |
|
Lumbago
Norsk Yak Master
3271 Posts |
 Posted - 2004-02-24 : 08:20:31
|
| Is there a quick and dirty way to copy a few tables with some data from test to production? Just need to do it once and the servers are not linked or anything...--Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand" |
|
|
mohdowais
Sheikh of Yak Knowledge
1456 Posts |
Posted - 2004-02-24 : 08:32:41
|
| I don't think there's a really easy way. Creating tables should be no big deal, you can script them out. For the data, you could backup and restore the test database with another name on the production server and then use DTS or write a script to transfer the data. If you need to move very few tables you could use bcp and Bulk Insert to transfer the data using text files.OS |
 |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2004-02-24 : 08:36:59
|
| bummer :( |
|
|
|
rihardh
Constraint Violating Yak Guru
307 Posts |
Posted - 2004-02-24 : 08:58:36
|
| Use the import wizard in EM (quick and dirty)... |
|
|
|
|
|
|
Copy a few tables/data to prod