Sql server 2016 into sql express hulp

[Solarion]

I have to get all the objects and data from a Sql server 2016 database into a Sql Express instance.

How do this?

 

[Baxteen]

first off we have to ask, what size is the entire DB on the SQL server because express limits at 2GB.

but the easiest way would be to create a back up of the different Databases and restore them on the Express instance.

 

[VG008]

first off we have to ask, what size is the entire DB on the SQL server because express limits at 2GB.

but the easiest way would be to create a back up of the different Databases and restore them on the Express instance.

10GB for 2016 Express.
Anyway, Backup and Restore as suggested or generate scripts with data and schema

 

[Baxteen]

10GB for 2016 Express.
Anyway, Backup and Restore as suggested or generate scripts with data and schema

backup has no down side, you if the restore does not work you have a back up.

but extracting scripts to data and schema is a good second option.

btw, I recommend Heidi sql for generating scripts, its the one place where it is better than sql manager IMHO.

 

[Traq]

first off we have to ask, what size is the entire DB on the SQL server because express limits at 2GB.

but the easiest way would be to create a back up of the different Databases and restore them on the Express instance.

SQL express has a database size limit of 4GB from 2005 - 2008, and 10GB limit from 2008 R2 - 2016.



Firs run the following query:

USE <yourdb>;
GO

select * from sys.dm_db_persisted_sku_features

If you get no results, then back up and restore like Baxteen recommended assuming that the database size is within the limits for SQL Express

https://msdn.microsoft.com/en-za/library/ms187510.aspx

 

[Solarion]

Out of the office right now will come back to this later on today. Thanks guys I will check out your solutions.

 

[Solarion]

10GB for 2016 Express.
Anyway, Backup and Restore as suggested or generate scripts with data and schema

backup has no down side, you if the restore does not work you have a back up.

but extracting scripts to data and schema is a good second option.

btw, I recommend Heidi sql for generating scripts, its the one place where it is better than sql manager IMHO.

My database is only 1.5G

Thanks guys you are very helpful, it worked!