Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  SQL Server Administration (2005)  Upgrading from Sql Express to Sql Enterprise

Author  Topic  sajid08 Starting Member 1 Post Posted - 2007-01-22 : 03:06:29 Hi All, We on a Windows 2003 server machine, firstly installed the VS 2005 with SQL Express and then installed the Biztalk 2006 Evaluation edition. Then after a few days we upgraded the Evaluation version to the Enterprise version. Now since we cant develop BAM activities on SQL Express we need to upgrade it to Sql Enterprise version, but we want to keep all the data that we've put so far on to the Express edition. Please guide me how to upgrade it in a way that all the biztalk deployments and databases on sql express remain intact. I noticed once I ran the enterprise edition installer of sql server that it asks for keeping the SQL Express instance, if we choose that would that do the job for us? Regards, Sajid.