Is Conversion from SQL Server Express to Full SQL Server Required?

If I develop my app in SQL Server 2005 Express, and then want to use a hosting service that only offers full SQL Server 2005, do I have to do some kind of conversion to my DB file, and if so, what might that be? (I notice that there are hosting services that provide SQL Server Express...I'd like to know how much work it would be to be able to use other services.)

Any guidance on this would be appreciated.

Thanks!

it is an easy process to upgrade the database... you have two methods that you can use. the first is to use the detatch/attach method... with this you would just detatch the database on you server and then have the hosting company attach it for you. Or you could just use the backup restore method.... This is the way I would go.

|||In case that your hosting company isn′t that friendly to attach the database for you nor will let you know where you can put your backup files on to restore it from that media (like my hosting company isn′t doing for me :-) ) you can use the Database Import Wizard (which works in my case because my hosting company offers port 1433 to the internet for the server) and create a SSIS package to do the job.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de|||

Glenn, thanks for the input.

I'm assuming in the scenario you describe that I would upload the mdf and ldf files to "my" directory on the hosted service systems, and then the operations you suggest would be performed from there...is that correct?

|||

Jens, thanks for the input.

In the scenario you describe, would I upload my DB to the hosted service first, and then operate the Database Import Wizard? Or is there another set of file moves involved? (Kind of piecing this together from newbie space :-)

|||No, actually not. As I don′t know which server is hostingn my SQLServer database on the hosting server. Even if I would upload my database I would not know the paths to attach the database. I use the DTS Import / Export wizard over the internet, directly importing the data into the "Internet" database.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||I would assume you have a "db" folder or "database" folder that you have access to on your hosted web server and, if so, that's where they'll likely go. Talk to your webhost and ask their advice since they'll be the ones working with you on it.|||

Thanks for input. I appreciate that I'll need more detail and coordination with the hoster; this thread has been useful in providing me with orientation on the basic mechanics.

Grazie!