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 |
|
pgmr1998
Yak Posting Veteran
66 Posts |
 Posted - 2009-06-05 : 14:18:18
|
| I have mistakingly changed a table in a database, but I have located another database that has the same data table with correct data prior to the update.I need to copy the entire content of the good table from one database into the content of the same table in the second database. How should I proceed? |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2009-06-05 : 14:37:38
|
| how big is the table? you can run SSIS import export wizard and get the data into a different named table..Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
pgmr1998
Yak Posting Veteran
66 Posts |
Posted - 2009-06-05 : 14:44:56
|
| The table is huge. Both tables have the same name, because these two databases are almost identical, except for the incorrect changes that was put in today. What is SSIS? |
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2009-06-05 : 14:58:55
|
| yes.. import the table into a different name and then fix it locally...Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
|
|
|
Copy Table into another DB