Solved

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

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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Server 208R2 not recognizing DBF file in linked Server 11 60
How to import SQL 2000 database to SQL 2014 5 138
Query 14 57
Help with simplifying SQL 6 54
by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

837 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