|
|
Rank: Member
Groups: Member
Joined: 4/11/2008
Posts: 8
Points: 0
|
I have been forced to move my website to a new host, I now have to transfer the MSSQL database over to their servers, I presume I can no longer then use mylittle admin. Can anyone give me guidance as to how I get a copy of teh MSSQL file to send to new hosting company, I tried a full back up file, but they say a .bat is no good, they need a .sql file.
many thanks
Jerry
|
|
Rank: Administration
Groups: Administration
Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France
|
The easiest way would be that your new hoster provides myLittleBackup. You will then be able to "install" the database by yourself, with no need of any support guy. (complete explanation and a short list of hosters that provide myLittleBackup can be found here: http://www.mylittlebackup.com/mlb/en/spotlight.aspx) If they do not, then you have 2 solutions: #1: you send your new hoster a backup (.bak) of your database and you ask them to restore it. They may send you an invoice for that. #2: You generate a whole T-SQL script that will create and populate your database from scratch. (it looks like this is what your new hoster recommends) I hope your database is not too big or it could be several hundreds MB sql file that you'll have to run. In order to generate this huge T-SQL script, you can have a look at the Database Publishing Wizard at http://www.codeplex.com/sqlhostHope this helps!
|
|
Rank: Member
Groups: Member
Joined: 4/11/2008
Posts: 8
Points: 0
|
elian, I really appreciate your help. I was hoping for Solution 1, as my new host is prepared to Restore, however here was his response after I sent him my .bak file.
The backup file savingsmart_20080410_633434611388098750.bak
can't be imported to our SQL server.
You will need to ensure that your backup is a sql file, which only has
the relevant information.
Don't do a complete backup of the database as you won't be able to
import server settings which is also stored in the .bak file.
Do you think i could challenge this /
Thanks
Jerry
|
|
Rank: Administration
Groups: Administration
Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France
|
If your initial sql server (old host) was in the same (or a lower) version than the sql server used by your new webost, then this answer has no sense and they should be able to restore the .bak file.
What SQL Server version were you using with your old hoster? Which one with the new hoster?
May I also know who this new hoster is?
|
|
Rank: Member
Groups: Member
Joined: 4/11/2008
Posts: 8
Points: 0
|
I was using MSSQL version 5 with my old host MD Hosting, I am in process of moving to http://www.netregistry.com.au using their business hosting package. In a previous contact with their admin they said this: Unfortunately there is no simple way to dump a MS SQL server database.
> Your ability to complete this task is going to depend on the level of
> access you have to the existing DB server.
>
> You need to create an mdf file and create a local copy on your machine,
> send this to us (eg upload via ftp) then we can insert into the MS SQL
> server.Again appreciate your time Merci
|
|
Rank: Administration
Groups: Administration
Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France
|
MD Hosting is a customer of ours.
I do not know NetRegistry.
With a mdf file, they could use the "attach" method to "install" your db. (as soon as they are using SQL2005)
With a bak file, they have to use the "restore" method. They will need to take care of the user mappings etc...
If you want to make a dump file, then have a look at the db publishing wizard.
At last, tell them about myLittleBackup. They could purchase and install one license (or even try the free 14day trial version) and they will be able to get new customers that want to switch from their competitors...
|
|
Rank: Member
Groups: Member
Joined: 4/11/2008
Posts: 8
Points: 0
|
One last question Elian, is there any way I can create an mdf file ?
Thanks
Jerry
|
|
Rank: Administration
Groups: Administration
Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France
|
Restore your bak file on a new db using SQL Server Management Studio on your local machine. It will create the mdf and ldf files. Then detach this newly created database so that you can copy the mdf file and send it to your new hoster.
Hope this helps
|
|
Rank: Member
Groups: Member
Joined: 4/11/2008
Posts: 8
Points: 0
|
Elian
Can you recommend some hosting companies here in Australia that use mylittle admin, I am with MD but need to change.
Thank you
Jeremy
|
|
Rank: Administration
Groups: Administration
Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France
|
Here are a few of them: Apexhost: www.apexhost.com.auExpressnet Pty Ltd: www.expressnet.com.auJabbawoki Group Pty Ltd: www.jabbawoki.comTerritory Technology Solutions: www.techsolutions.com.auAdvance Vision Technology: www.avtech.com.au
|
|
|
Guest |