Migration error from SQL 2014 to SQL 2012

Kala Vairakkannu

I have a database(Eg. SALES) in SQL Server 2014 which needs to be recreated in SQL Server 2012 version. Since I can not use the SQL 2014 back up file in SQL 2012 environment, I have proceed with the Generate Script option and trying to run the script in SQL Server 2012 environment. However it is giving an error as Msg 102, Level 15, State 6, Line 1 Incorrect syntax near 'DELAYED_DURABILITY'. which is pointing to the ALTER DATABASE [SALES] SET DELAYED_DURABILITY = DISABLED line in the script and not able to proceed further. Please help me to get this sorted out.

Thanks, Kala

LloydA111

Wrong forum and, http://mssqltrek.com/2013/12/12/delayed-durability-in-sql-server-2014-a-hidden-gem/[^] "DELAYED_DURABILITY" was only introduced with SQL Server 2014. I don't know what the equivalent is in 2012.

       .-.
      |o,o|
   ,| \_\\=/\_      .-""-.
   ||/\_/\_\\\_\\    /\[\] \_ \_\\
   |\_/|(\_)|\\\\  \_|\_o\_LII|\_
      \\.\_./// / | ==== | \\
      |\\\_/|"\` |\_| ==== |\_|
      |\_|\_|    ||" ||  ||
      |-|-|    ||LI  o ||
      |\_|\_|    ||'----'||
     /\_/ \\\_\\  /\_\_|    |\_\_\\

Kornfeld Eliyahu Peter

You are in the wrong forum!!!

Welcome to the Lounge Technical discussions are welcome, but if you need specific help please use the programming forums.

DELAYED_DURABILITY is a 2014 only - new - feature, so 2012 do not know it...Change database compatibility to 2012 (110) and try again...

I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)

ZurdoDev

Lloyd Atkinson wrote:

I don't know what the equivalent is in 2012.

It is empty string. :)

There are only 10 types of people in the world, those who understand binary and those who don't.

ZurdoDev

Correct and Correct. +5 :thumbsup:

There are only 10 types of people in the world, those who understand binary and those who don't.

Kala Vairakkannu

Didn't notice the forum. Thank you.

KV

Kala Vairakkannu

As far as I know, there is no such property DELAYED_DURABILITY in SQL 2012. Hence removed that line and ran the query, it works fine. Not sure if this is the right approach, but just tried it out.

Thanks, KV

Kornfeld Eliyahu Peter

There is not such property. Removing it is just right...

I'm not questioning your powers of observation; I'm merely remarking upon the paradox of asking a masked man who he is. (V)

Kala Vairakkannu

Thank you Kornfeld Eliyahu Peter.

KV