Migrate DB from MSSQL2008 to MSSQL2012

Hello,

We recommend to do a full backup / restore of the database.

Best regards,

And for the SQL2012. Any specific settings I need ?

Hello,

You haven't mentioned if you are doing an in-place upgrade, what edition you are running, etc.

The Microsoft documentation on the DB side of things is on https://msdn.microsoft.com/en-us/library/bb677622(v=sql.120).aspx

If you are doing an in-place upgrade, I am not aware of any additional steps because normally the DB stays with the original version of its internal schema.

A good recipe is

If you are using another server and/or changing server settings, then you need a DBA's assistance.

Best regards,

No its a new Server with new SQL instal.

I was able to easily migrate using the Studio Wizard from 2012.
Everything seems to be working smootly.

Thanks for the help and time