How to To transfer SQL server Express to web hosting Provider

Hello,

FYI, I'm using Visual Studion 2005 with SQL server Ex Edition in my developer PC. So the problem now is how i can migrate the database into my web hostin provider??. The provider also use the same version of SQl server. What i noticed the expree editon dont have function to import or export.

Anybody iin here know how to solve? Right now, i'm create the databse using my controll panel in my web hosting then i create tables usin management studio express, this way i must do twice works, 1st in my developer PC then into my web hosting..please anybody give a hand please

You can move the .mdf file (the database file) to the server, so you don't need to import or export data.

|||

Tq for the reply, I already copy web site include the app_data into my web hosting, but unfortunately i dont know the connections strings?? when i ask the provider they told me to use the management studio for the databse for connection into their server. But i also noticed if i install the application which use sql server dataabse it can run, so how is it i wanto make my web site including the database be like installer..so i just install into web hosting..is it possible??

note: I'm newbie in VS and Sql server

|||I've heard that creating database can be included in application installer. However you still need to change your connection string to connect to the new SQL instance, so that the database created by the installer can be attached to the new SQL instance.|||So anybody in here can help me.. please..i need a way..i have a dateline..huhuh|||Hello friends,, I really need this solutions, please somebody in here..can anyone give any suggestion?? Thank you|||

Check out the new Database Publishing Wizard on Codeplex athttp://www.codeplex.com/Wiki/View.aspx?ProjectName=sqlhost&title=Database%20Publishing%20Wizard

We've just released out first CTP and we've still got a ways to go on perfecting it, but there's a good chance it'll help you.

Thanks,

Dan Winn

Senior Program Manager, Microsoft SQL Server

|||Tq for the reply..i already install it..but unfortunately i'm do not know how to use it..i prefer use with GUI...can u help me the steps how to use it? anyway thanks again for the reply