Posted on: 9/20/2014 4:18:58 AM | Views : 595

I create a sql database from sql 2008 and now am using sql 2014 and azure database .I generate script and try to parse it from azure database . but it shows error .i change the compatibility to 120 and generate script then be its shoing somany errors
these are the errors
Msg 102, Level 15, State 1, Line 3 Incorrect syntax near 'CONTAINMENT'. Msg 102, Level 15, State 1, Line 9 Incorrect syntax near 'COMPATIBILITY_LEVEL'. Msg 40511, Level 15, State 1, Line 11 Built-in function 'FULLTEXTSERVICEPROPERTY' is not supported in this version of SQL Server. Msg 102, Level 15, State 1, Line 16 Incorrect syntax near 'ANSI_NULL_DEFAULT'. Msg 102, Level 15, State 1, Line 18 Incorrect syntax near 'ANSI_NULLS'. Msg 102, Level 15, State 1, Line 20 Incorrect syntax near 'ANSI_PADDING'. Msg 102, Level 15, State 1, Line 22 Incorrect syntax near 'ANSI_WARNINGS'. Msg 102, Level 15, State 1, Line 24 I ...

Go to the complete details ...