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 |
|
nhaas
Yak Posting Veteran
90 Posts |
 Posted - 2007-08-22 : 12:18:07
|
| I have a read only Database that I want to copy a couple of Tables out of and into a Test Database that I have full control over.The kicker is that the table structure "may" change, so I will not really know if it changes because that is done by someone else. So is there a way to copy a table from a Different database into my own Database as the same structure and data?Databases are on the same Server.Thank You. |
|
|
nhaas
Yak Posting Veteran
90 Posts |
Posted - 2007-08-22 : 17:01:11
|
| I have not tried this, but should I use:SELECT LastName,FirstName INTO Persons_backupFROM Persons . . .? |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-22 : 22:10:40
|
| What works, but you have to create keys and indexes manually. |
|
|
|
|
|
|
Backup question