Exporting SQL Server 2005 Express Database Data to a Remote SQL Server

June 7, 2006

[From ASPAlliance]

When ASP.NET v2.0, Visual Studio 2005, and Visual Web Developer were released to manufacturing, ORCS Web began supporting those technologies, making them immediately available to our clients. Visual Web Developer 2005 has a very cool feature that will allow you to dynamically create a SQL Server Express database for use when developing web applications, which is great for developers. But, after the web application is developed, how is the database schema and data uploaded to your production database on a remote SQL Server? What a dilemma! It turns out, though, that there are a few options.

The article continues at http://aspalliance.com/888