Most visitors online was 12720 , on 2 May 2024
-
Unfortunately, we have experienced significant hard drive damage that requires urgent maintenance and rebuilding. The forum will be a state of read only until we install our new drives and rebuild all the configurations needed. Please follow our Facebook page for updates, we will be back up shortly! (The forum could go offline at any given time due to the nature of the failed drives whilst awaiting the upgrades.) When you see an Incapsula error, you know we are in the process of migration.
Is it possible to Restore RYL Database in SQL Server 2012?
- Thread starter 2304
- Start date
- Joined
- May 25, 2006
- Messages
- 1,688
- Reaction score
- 298
What version are you coming from? 2008? 2005? need a bit more info.
This should give you the info you need though
This should give you the info you need though
You must be registered to see links
//// 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:
Here's the error message.
You must be registered to see links
////Here's the error message.
- Joined
- May 25, 2006
- Messages
- 1,688
- Reaction score
- 298
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
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
RaGEZONE Sponsor
