Working with Other Databases

There may be occasions where we will need to connect to, and interact with, databases other than SQL Server Compact. In this section, we will see how an existing SQL Server Compact database can be migrated to a different version of SQL Server and how to connect to an SQL Server or MySQL database with ASP.NET Web Pages.

Migrating an SQL Server Database

While the SQL Server Compact database supplied with Microsoft WebMatrix is perfectly usable for small- to medium-sized web sites, it may become necessary to use one of the more powerful versions in the SQL Server family to meet performance or space requirements.

WebMatrix makes it easy to migrate an existing SQL Server Compact database from within the WebMatrix IDE.