Home > IT Answers > Development > Moving a SQL database from one host to anothe...
Help

Question

  Asked: Apr 28 2008   2:54 AM GMT
  Asked by: Kwoodall

Moving a SQL database from one host to another


SQL, ASP, SQL database, VBScript, Database migration, Web development

I need to help out in a move of a site coded in ASP/VBScript from one host we're having major problems with to another host that has been highly reliable for us. They both offer all the same features needed for this site, but we don't know how to move the SQL database along with the site.

Can anyone offer advice or point me to some utlities that can do this?

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window
Help

Answer Wiki (Improve, edit or add to this answer)

IMPROVE THIS ANSWER
View History
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
Last Answered: Apr 29 2008  5:18 PM GMT  by Mrdenny




Does the current hosting provider offer you a way to backup the database, and get access to that backup? What sort of access to the SQL Server do you have? Do you have to use thier web based tool, or can you connect directly to the SQL Server using the native SQL Server tools?

The answers to these questions will greatly impact your ability to move the database.
  • AddThis Social Bookmark Button

Browse more Questions and Answers on Development, SQL Server and Database.

Looking for relevant Development Whitepapers? Visit the SearchSQLServer.com Research Library.


RSS - Discussions Help

Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register

Mrdenny  |   Apr 29 2008  5:19PM GMT

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.