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 |
|
cnbhold
Starting Member
43 Posts |
 Posted - 2010-07-29 : 16:07:42
|
| I have a SQL table on a Production server. Not sure how to move this table with data to another server for testing. I'm currently using SQL Server 2005. Angel |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2010-07-29 : 17:04:26
|
| There is the import/export wizard in management studio (which builds an SSIS package) or you can also roll your own SSIS package. Using the import/export wizard is a pretty easy way to go depending on your requirements. |
 |
|
|
|
|
|
Moving a SQL Table to Another Server