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 |
|
Daniel Israel
Starting Member
15 Posts |
 Posted - 2006-11-11 : 12:50:49
|
| Hello guys,I'm changing ISPs. I have a MS SQL 2000 database on one server and a new (blank) database on another. I do not have access to the machines, so I cannot run the manager.What I'd like to do is copy the schema (and data if possible) from one database to the other. Both machines have access to both database by SQL queries.* I tried backup/restore, but I can't stop the database server (my ISP won't let me) to do the restore. * I tried the MS scripting utility, but the database is too large (~800MB)* I tried restoring to a personal machine, then scripting the schema via Enterpise Manager, but the SQL it generates won't work.Are there any other ideas out there? I'm hoping not to have to script the entire database by hand. Any help is appreciated. Thanks!-D. Israel |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
Daniel Israel
Starting Member
15 Posts |
Posted - 2006-11-11 : 13:40:49
|
| Peter,Thanks for the response. You already mentioned this tool to me here: [url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=74603[/url]Unfortunately, my database is too large and the tool just stops working. (I use it for other stuff though!)-D. Israel |
 |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-11-11 : 14:37:20
|
| Find an ISP that will let you do a database restore.CODO ERGO SUM |
|
|
|
|
|
|
How to move from one database to another?