Exporting SQL express to SQL

Hi, I have been developing a site locally, how can I export the sql object I made in my site to proper MS SQL Server?

Thanks

 

You'll need to paint a better picture of what you have currently and what you need.

i.e. ASP.NET framework? DataSource object? Records exist in another format, such as XML?

 

Sorry, I am using ASP.Net, In Visual Studio I added a SQL database (i think it's express, not sure exactly but it's the sql object you add in VS).

So I want to be able to upload the site, but the express objects do not work. So do I need to export it so it will work with the SQL server?

 

No problem, this is a fairly common question.

DASP doesn't support the Express versions.

However you have several options.

1. Purchase a SQL Server 2005 add-on for your DASP account and you can mount your Express data.
2. Port your code and data to an Access data source.
3. Use the .NET Framework v3.5 and Linq to use XML data sources.

 

Cool, i intend to buy one, How do i 'mount' it?

 

The SQL Tools in your account once you add it:


http://kb.discountasp.net/article.aspx?id=10411