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 |
|
JohnJohn73
Yak Posting Veteran
57 Posts |
 Posted - 2008-03-25 : 12:15:37
|
| Hello All.I just made some huge changes to a database on the development computer. However, I want to transfer all of the information from the Employees table in the old DB to the new DB (no changes made on that table).Can anyone point me in the right direction? |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-03-25 : 12:18:35
|
| Are both databases on same server?Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
JohnJohn73
Yak Posting Veteran
57 Posts |
Posted - 2008-03-25 : 12:19:43
|
| Not yet. Is that Step 1? |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-03-25 : 12:22:07
|
| 1. Either you can add 2nd server as linked server and use normal INSERT statement to copy the data2. Make use of SSIS package to transfer table data from one server to another3. Use BCP to export data from one server and import into another if the data volume is hugeHarsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
JohnJohn73
Yak Posting Veteran
57 Posts |
Posted - 2008-03-25 : 12:24:03
|
| Thanks for the input, I'll look into these options. |
|
|
|
|
|
|
Move info from a table in one db to another