?
Solved

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

Posted on 2008-10-16
3
Medium Priority
?
269 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 13

Accepted Solution

by:
sm394 earned 2000 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

Does Your Cloud Backup Use Blockchain Technology?

Blockchain technology has already revolutionized finance thanks to Bitcoin. Now it's disrupting other areas, including the realm of data protection. Learn how blockchain is now being used to authenticate backup files and keep them safe from hackers.

Question has a verified solution.

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

This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

764 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