Uploading MS SQL server database
I'm having a problem when I transfer my locally developed MS SQL server db to my hosts server.
I am logging into the host server and then importing the tables and data from my local machine. All the tables and data then get transferred alright but the ID colums lose the primary key and identity setting and any default values in the table structure also get lost.
This means I then have to go through each table on the host server an put things straight. A pain in the bum... I've tried creating the table structure using a SQL script which keeps the ID colum but not the default values.
Why is this happening and how can I resolve it?
Thanks in advance
eBlush_Hector posted this at 01:04 — 27th April 2004.
He has: 51 posts
Joined: Jan 2004
The only way I've transfered a DB from a local box to a different box was to FTP it. This way, it's not an import. It's the actual DB files.
Is this an option for you? Otherwise, I'm out of ideas!
http://www.eblush.com/
Where you can get personal, online!
NEW: Honor your heroes at ThisIsMyHero.com!
openmind posted this at 08:24 — 27th April 2004.
He has: 945 posts
Joined: Aug 2001
Yes but you can do it via enterprise manager and thats how I need to simply because I don't have direct FTP access to that server...
openmind posted this at 20:06 — 27th April 2004.
He has: 945 posts
Joined: Aug 2001
anyone?
druagord posted this at 14:08 — 4th May 2004.
He has: 335 posts
Joined: May 2003
it's been at least 3 years since i last done that but i know what your probleme is. if i remember right instead of a export i did a backup and restored it in the live server
IF , ELSE , WHILE isn't that what life is all about
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.