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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-09-13 : 08:35:56
|
| Majorossy writes "Hello, first off thank you for your time, i am having a horrible time trying to get a copy of a database from one machine to another. I just set up a new computer for development, i have an active server running server 7.0, theres a database i have on there that i'd like to pull into my new machine also running server 7.0, i generated the sql scripts on the old server, brought them to the new, executed it, and recieved my tabels, excellent, but now i want to bring the data in the tabels over as well, i tryied backing up the old and restoring on the new, but it wont work, do i have to do export each tabel individually???? that wold suck, thank you and any help would be great." |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2004-09-13 : 10:40:14
|
| Why not just force a restore over the new DB? |
 |
|
|
|
|
|
|
|
copying a database in 7.0