Converting SQL Server Express To SQL Server?

Question

I have created a program that uses SQL Server Express as its database.

Now I want to convert the database to SQL Server.

How can I do this?

SQL Server Express IS SQL Server - no "conversion" necessary. Just simply (1) backup your database in SQL Server Express, and then (2) restore that backup on your "full" SQL Server instance. You need to make sure that the version of the target platform is at least as new as the SQL Server Express you're coming from - you cannot "go back" in versions (e.g. backup from SQL Server 2014 Express, and then restore to SQL Server 2012) — marc_s
– marc_s, Commented Mar 18, 2015 at 9:31

marc_s · Accepted Answer · 2015-03-18 09:42:29Z

2

There is no converter or something needed.

You just have to select your database in your Management Studio (Express) and detach it from your SQL Server Express instance.

Then connect to your SQL Server and attach the database with a right-click on Databases -> Attach.

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Mar 18, 2015 at 9:06

Obl Tobl

5,6828 gold badges44 silver badges67 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1