2008 Express --> 2005

Can you help a beginner? I developed my site in part using Visual Web Developer 2008 Express and my database was created that way. What do I need to know to upload it to DiscountASP.NET and make it work with 2005 Server? I've read all of the relevant KB items I could find, but they apparently assume an experience level beyond mine.

Thanks in advance.

 

I'm afraid you overestimate my level of experience doing this. In your item 2, how do I create a script in SQL Server Express, what is it supposed to accomplish, and how do I execute it on the server. In item 3, how do I 'pump' the data? Is there something I should be reading that explains all of this?

Thanks.

 

Hi,
This can be very complicated but once you get used to these things it's a breeze.

1. Up until now SQL Server Express couldn't be used to Import and Export data like the full versions.
   The new version of SQL Server Express 2008 can however be used for that.
   I blogged about the new version a few weeks ago.
   http://blogcastrepository.com/blogs/wisemx/archive/2008/06/12/sql-server-2008-express-rc0.aspx
2. With the 2005 versions of SQL Server Express you can Right-click on a database and create scripts.
   Then you can connect to your remote SQL Server and with a new query window you can execute those scripts.
3. Scott Guthrie posted a lot of information about some of the ways to do this:
   http://weblogs.asp.net/scottgu/archive/2006/12/22/recipe-deploying-a-sql-database-to-a-remote-hosting-environment-part-1.aspx
   The easiest method however is with the DiscountASP.NET Attach Database feature.

Here are some resources for you...


How to Script your Database:
http://blogs.msdn.com/robburke/archive/2006/05/30/610803.aspx


Use the Attach tool for SQL Express databases:
http://kb.discountasp.net/article.aspx?id=10411

 

Hi,
I'm sure you can find help here.

By 2008 Express to 2005" are you referring to SQL Server 2005? Seem so.

If so, getting a SQL Server 2005Express database on your DASP SQL Server 2005 DB can be done several ways.

1. Using the Attach feature in the Control Panel, under the SQL Server 2005 section.
   Just upload your Express DB, preferably the App_Data folder with the files in it.
   Then in the CP attach that Express DB.
   Be aware that it will wipe out any data you many already have in the SQL Server 2005 DB.
2. Create scripts in SQL ServerExpress then execute them on the SQL Server 2005.
3. Use the new SQL Server 2008 Express and pump the data from Express to your DASP 2005 DB.

Hope that helps a little bit.
Salute,
Mark