Solved

How do I move my SQL database from my old web host to my new web host

Posted on 2008-10-16
3
259 Views
Last Modified: 2012-05-05
I have a database installed from a program in a book. Initially installling it and getting it working fine.  Now 9 months later a new host has bought out my original host and now nothing is working on my web site as a whole and the company who bought out the first host has given me so many problems that I have decided to move to another host.  The new host that bought the old host has given such bad support it is unreal.  So, here is my problem I am ditching my current (very bad) host to a new host and I need to move my SQL data and database.  It seems that I can generate scripts that would get all of the database components into a scripts, but the data is not scripted to carry over.  I read other posts like this one where the person who provided the solution state create the database and restore a .bak file.  I tried to do this but it seems it did not work for some reason, maybe because the main database names are not the same or something.  So I am here to get answers from experts like you.  I am a very knowledgeable programmer but some what a novice to Microsoft SQL server.  I need an answer quickly.

Tony...
0
Comment
Question by:CGIAMETTA
  • 2
3 Comments
 
LVL 13

Accepted Solution

by:
sm394 earned 500 total points
ID: 22736986
Download this freel tool by Microsoft for publishing Data
http://www.codeplex.com/sqlhost/Wiki/View.aspx?title=Database%20Publishing%20Wizard

Then
in Wizard if you just want to generate data insert statements
set the following options

uncheck Script all object
Next
Schema qualify= False
Types of data to publish =Data only

end result is data script which you can execute on new Database

The tool can also generate scripts for other objects in the database ie. Tables

0
 
LVL 1

Author Closing Comment

by:CGIAMETTA
ID: 31506974
That worked for me Thank you very much.  Sorry it took so long had trouble with time to just get in there and do what you described.
0
 
LVL 13

Expert Comment

by:sm394
ID: 22806999
Glad your problem resolved
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL HELP 2 89
SQL Agent Timeout 5 59
SQL Server 2012 express 24 38
SQL Restore Script - Syntax Error 8 98
When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question