How to export MS Server 2008 database for shared host?
Hi there,
I would like to ask for your expert advice please.
I have created a new website using Umbraco 4.7.1 and use SQL Server 2008 rather than SQL CE version.
What I am trying to do is, I would like to export SQL Server 2008 database and then import the database into the database with my web hosting company, which is 123-reg.co.uk.
I have installed SQL Server Management Studio and tried to export data by going into
My Database (right click) => Tasks => Export data ...during the process I've selected 'SQL Server Native Client 10.0' as my Destination ... (and followed the instruction.)
Then when I tried to import the exported data into the database at 123-reg, but it said I've exceed the maximum length.
Could you please help me, what do I need to do? Where did I went wrong?
What you can try to do is do an "Generat SQL scripts" on your database. From there you can generate the scripts to b uild the structure of your database, and you can also select the option to script the data.
By doing so, you just get a plain SQL script that contains all information: structure, constraints, and data.
And, since it is just SQL script, I guess it will execute correctly on your hosted database.
How to export MS Server 2008 database for shared host?
Hi there,
I would like to ask for your expert advice please.
I have created a new website using Umbraco 4.7.1 and use SQL Server 2008 rather than SQL CE version.
What I am trying to do is, I would like to export SQL Server 2008 database and then import the database into the database with my web hosting company, which is 123-reg.co.uk.
I have installed SQL Server Management Studio and tried to export data by going into
My Database (right click) => Tasks => Export data ...during the process I've selected 'SQL Server Native Client 10.0' as my Destination ... (and followed the instruction.)
Then when I tried to import the exported data into the database at 123-reg, but it said I've exceed the maximum length.
Could you please help me, what do I need to do? Where did I went wrong?
Thank you so much...
Hello,
What you can try to do is do an "Generat SQL scripts" on your database. From there you can generate the scripts to b uild the structure of your database, and you can also select the option to script the data.
By doing so, you just get a plain SQL script that contains all information: structure, constraints, and data.
And, since it is just SQL script, I guess it will execute correctly on your hosted database.
Hope this helps.
Cheers,
Michael.
OK. Thank you so much for your help. I will try it now.
is working on a reply...