September 1, 2010 at 3:23 am
Hi all,
this is my first post on the forum. I have some ASP.NET applications that work with SQL Server 2005 Express edition; in the DB i've used a lot of stored proc, triggers, custom functions and registered some assemblies (dll) developed with MS Visual Studio 2005 (in c#).
Some month ago we decided to buy and install SQL Server 2005 Professional Edition and now i need to move all the databases from the machine with the Express Ed to the server with the Pro Ed.
I need to know: in order to make all things work fine (primarly the registered assemblies), what's the best strategy:
1) backup from Exp and restore the bak file to Pro
2) detach from Exp and attach the mdf/ldf to Pro
in both cases I think i should re-create db users.
Many thanks for your answers.
Bye
Don
September 1, 2010 at 3:57 am
They are both good methods for moving databases. The main difference is that the dettach/attach method will require you to take the database down for the move.
Also don't forget to script out any jobs that you may have.
September 1, 2010 at 4:20 am
Thank you for your answer, i'm just a bit worried about assemblies.
Do you have any experience about this issue ?
Best regards,
Don
September 1, 2010 at 6:17 am
Professional edition? There's no such edition of SQL.
If you're talking about CLR assemblies, they're stored in the database and will come across with either method.
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
September 1, 2010 at 8:29 am
Sorry! It's the Standard Edition...
...and thanks for the answer
Best regards,
Don
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply