Results 1 to 2 of 2
Thread: Need help moving MSSQL database
Dec 28, 2004, 10:11 #1
Need help moving MSSQL database
I made the mistake of getting involved with a friend who started a hosting business but now I want out. My question is how on earth do I get my MSSQL database off of his server and onto my local drive. I tried doing the backup but that errors out with permission errors. I've tried export data by setting the destination to my local SqlServer and that errors out also with permission errors I assume. when I just generate a sql script it keeps adding my username for the server as the owner of the tables rather than dbo so I haveCode:
setuser N 'myusername'
Im relatively new to SQLServer and know just about enough to be dangerous and thats it.
Any help would be greatly appreciated.
Dec 28, 2004, 12:59 #2
when I just generate a sql script it keeps adding my username for the server as the owner of the tables rather than dbo so I have
- Join Date
- Jul 2004
- 0 Post(s)
- 0 Thread(s)
Open EM, and right click your db, and choose>> all tasks >> generate sql scripts.
On the dialog box, set the options you want e.g. dont not choose script db users and roles.(Under the options tab) I normally just choose table scripting options, depending on what you have.
And under the formatting options, choose generate scripts for dependent objects.
Create a new db, and run your new script in query analyzer.
Once you create your db, locally you can use DTS to copy your db.