Q:  I am developing a web application using SQL Server 2005 Express. When I deploy it I will need to create the database on my host’s database server, which is of course the full editon. How does one go about converting the Express file to a full version database?

Bryan Oliver says:  SQL Server Express uses the same reliable and high-performance database engine as the other versions of SQL Server 2005. It also uses the same data access APIs such as ADO.NET, SQL Native Client, and T-SQL. In fact, it is differentiated from the rest of the SQL Server 2005 editions only by the following:

Lack of enterprise features support
Limited to one CPU
One GB memory limit for the buffer pool
Databases have a 4 GB maximum size

So in other words you have nothing to worry about moving from the express edition to the full version of SQL Server

Technorati Tags:
SQL Server 2005 Express, migration, database engine, API
Add to: | Technorati | Digg | del.icio.us | Yahoo | reddit |