February 26, 2009 at 11:44 pm
hi,
I am trying to move a database into another database in sql server express edition 2005, but how, i dont know.
In sql server 2005 there is a option to export and import database but not in express edition.
February 27, 2009 at 12:23 am
Take the backup of database and restore that database in another server.
February 27, 2009 at 1:58 am
Or detach, copy files, attach. Either will work
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 27, 2009 at 1:06 am
What about the users / logins / roles and stuff if you use the detach / attach method ?
I read somewhere that you may have to use sp_change_users_login. Why would that be ?
May 27, 2009 at 1:42 am
DBAs_worst_nightmare (5/27/2009)
What about the users / logins / roles and stuff if you use the detach / attach method ?
Exactly the same as if you use backup/restore.
Users and roles are in the database, logins are in master. You'll have to script them out and apply on the new server. Script with the SID or you'll have to use that change user login to fix orphaned users.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 27, 2009 at 3:45 am
Hi Gail
I've opened another topic in the forum to get some more information.
http://www.sqlservercentral.com/Forums/Topic723829-324-1.aspx?Update=1
Could you give me some more details on the method /syntax I should use ?
Thanks for the help
Jurriaan
June 3, 2009 at 3:17 pm
Have you tried the Database Copy Wizard?
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply