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 |
|
ennio
Starting Member
2 Posts |
 Posted - 2008-06-23 : 18:39:29
|
| I would like to know what is the best way to move all the data from a DB to a new database. Some of the tables has different names, and attributes, so is there a way to create a script or something that will do that.Both databases are in the same server. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-23 : 19:12:33
|
| Backup/Restore with Different name . |
 |
|
|
ennio
Starting Member
2 Posts |
Posted - 2008-06-23 : 19:38:39
|
| sorry but this is not what I'm trying to do. The new database is different from the old one, I'm trying to copy data from one database to the new one. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-23 : 22:20:06
|
| Or build ssis package to move data. |
|
|
|
|
|
|
Need help to move DB.