Solved

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

Posted on 2008-10-16
3
258 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How to update "part of a text field" without changing the entire contents? 2 49
SQL Server 2012 express 24 36
How to query LOCK_ESCALATION 4 40
Sql query 107 29
Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

867 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now