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 |
|
blocker
Yak Posting Veteran
89 Posts |
 Posted - 2011-06-26 : 22:37:15
|
| Hi to all!I just want to ask help/example on how to transfer the contents / data of all tables from old database to another that has the same table format...thank you! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
blocker
Yak Posting Veteran
89 Posts |
Posted - 2011-06-26 : 23:12:57
|
| Yes. the new database has been modified and there's a bunch of changes in the stored procedures.....But the table structure is the same as the old database, only some tables are added and there is a bunch of data stored in old database because it is being currently used. I need to copy/transfer the contents of old database tables data to new one..Never mind about the stored procedures...The most important is, the data in the tables of old database should be transfer to new one so that the old databse will be replaced with the new one.. |
 |
|
|
|
|
|
transfer all table data to another database...