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 |
|
ljp099
Yak Posting Veteran
79 Posts |
 Posted - 2004-07-20 : 00:00:57
|
| ive got a sql 2000 db running on a remotely hosted server. im trying to take this db and export it and import it to my new web host. my problem is that I go to the db, select export, then select, copy objects to export. i keep getting an error that the export failed due to the fact that the user doesnt exist (the existing db has a username the webhost assigned me, the new db has a different username which the new webhost assigned me). I simply want to export all the data, the tables, primary and foreign keys. help!thanks, lance |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2004-07-20 : 00:25:01
|
| You'll need to speak to your existing db host provider. They most likely are limiting the import/export functions available to their clients for security reasons. And also to stop you from going elsewhere... The easiest option from your perspective is to get a complete database backup from them, then you can restore it to create the new database. Alternatively they can 'detach' the db for re-attachment on the new server. |
 |
|
|
|
|
|
cant export sql 2000 db