Is it possible to Restore RYL Database in SQL Server 2012?

[2304]

Hello, I've tried restoring database in SQL Server 2012 and error occured saying that the backup was done from previous version of SQL. Is there any other way to restore RYL database to SQL Server 2012?:blush:

 

[GhostSnyper]

What version are you coming from? 2008? 2005? need a bit more info.

This should give you the info you need though

You must be registered to see links

 

[2304]

//// TITLE: Microsoft SQL Server Management Studio------------------------------Restore of database 'Admintool' failed. (Microsoft.SqlServer.Management.RelationalEngineTasks)------------------------------ADDITIONAL INFORMATION:System.Data.SqlClient.SqlError: The database was backed up on a server running version 8.00.2039. That version is incompatible with this server, which is running version 11.00.2100. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server. (Microsoft.SqlServer.SmoExtended)For help, click:

You must be registered to see links

////


Here's the error message.

 

[GhostSnyper]

Umm... you can't expect SQL server 2003 (or older) to be compatible with SQL server 2012...

You're going to suffer with having to upgrade incrementally... move it from 2003 to 2005, 2005 to 2008, 2008 to 2012.

Or. Just rebuild the tables you want, use SSMS to SELECT the data from each table, dump it into an excel file, then write a VBA script to push that data to the new SQL server. It's not that hard, something tells me you're not experienced with working on Databases

so the easiest thing for you to do:
1) Create the tables/databases in the format required by the server
2) have SSMS Select the data from each table in your old data base, then export the results to Excel
3) Write a VBA script in excel to INSERT that data into the new server
4) ???
5) Profit