No backward compatibility is supported by SQL, you need to either backtrack your SQL version, or create script from old database (script with data) and run that script on new SQL database, see below snippet
use below steps to create script file with schema and data
1.Right click database ? Tasks ? Generate Scripts ? Choose DB ? Change "Script Data" option to true ?
If we have a .sql file and it's not too big we can just open it with SQL Server MS and run it.
If we have a .sql file but it's too big to be opened with SQL Server MS we have to use sqlcmd like this:
>sqlcmd -i C:\panels_QA28July11.sql -o C:\PanelsImportResult.txt
The parameter after -i is the file to import. The parameter after -o is where to save the output. We can omit the second parameter if we want to see the process on the screen.
By default it will use the local machine and local database server. If we want to use a different machine and server we use the -S option.
Editor, DotNetSpider MVM
Microsoft MVP 2014 [ASP.NET/IIS]