How migrate from SQL Express to SQL Server

  • Thread starter Thread starter VB Programmer
  • Start date Start date
V

VB Programmer

Using ASP.NET 2.0

I have a website which uses SQL Express.

My hosting company supports only SQL Server.

Any suggestions? What's the easiest way to migrate when I deploy? Will I
have to change any code, or just the connection string?

Thanks!
 
It depends on whether or not you used the one and only feature in SQL
Express that's not supported on other editions--User Instance.
Otherwise, I expect that all you'll need to do is detach/reattach the
database and change the connection string.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
 
Check your ConnectionString.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------
 
Back
Top