August 12, 2011 at 8:58 pm
Hi,
I tried to restore sql server 2008 R2 database backup file in sql server 2008 sp2 server, but it failed with error.
"The database was backed up on a server running version 10.50.1600. That version is incompatible with this server, which is running version 10.00.4000. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server."
I thought generate db script in R2 sql and run in sql 2008 sp2 sql server.
I tried to generate script -db all objects and data, script generated but failing when I tried to open it with below error
Error HRESLUT EFAIL has been returned from a call to a COM component.
Is there any other options, any tools? any process to create schema and import data?
Appreciate your help in regard this. Thank you
August 12, 2011 at 9:26 pm
laddu4700 (8/12/2011)
Hi,I tried to restore sql server 2008 R2 database backup file in sql server 2008 sp2 server, but it failed with error.
"The database was backed up on a server running version 10.50.1600. That version is incompatible with this server, which is running version 10.00.4000. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server."
I thought generate db script in R2 sql and run in sql 2008 sp2 sql server.
I tried to generate script -db all objects and data, script generated but failing when I tried to open it with below error
Error HRESLUT EFAIL has been returned from a call to a COM component.
Is there any other options, any tools? any process to create schema and import data?
Appreciate your help in regard this. Thank you
Returned an error from a COM Component?
Where are you trying to perform the restore from?
You can create schema and import data from a different number of ways.
You can import and export data using the wizard, SSIS, etc.
What exactly did you do to get that error? Could you please be more specific?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 12, 2011 at 9:46 pm
Welsh Corgi (8/12/2011)
laddu4700 (8/12/2011)
Hi,I tried to restore sql server 2008 R2 database backup file in sql server 2008 sp2 server, but it failed with error.
"The database was backed up on a server running version 10.50.1600. That version is incompatible with this server, which is running version 10.00.4000. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server."
I thought generate db script in R2 sql and run in sql 2008 sp2 sql server.
I tried to generate script -db all objects and data, script generated but failing when I tried to open it with below error
Error HRESLUT EFAIL has been returned from a call to a COM component.
Is there any other options, any tools? any process to create schema and import data?
Appreciate your help in regard this. Thank you
Returned an error from a COM Component?
Where are you trying to perform the restore from?
You can create schema and import data from a different number of ways.
You can import and export data using the wizard, SSIS, etc.
What exactly did you do to get that error? Could you please be more specific?
I used generate scripts option in SQL 2008 R2 version server and generated script for all db objects and data. Script is created successfully but when I tried to open that script.sql , throwing error. Do I need to copy the script to SQL server 2008 SP2 server and open and run?
I took SQL Server 2008R2 backup and trying to restore on SQL Server 2008 SP2.
Can you please in details exporting schema and data using SSIS?
August 12, 2011 at 10:07 pm
If you right click on the database from SSMS and Select , Select the objects that you want to transfer and Export Data and run the wizard to copy the objects and data.
It is very simple let me know if you need additional details.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 12, 2011 at 10:18 pm
Welsh Corgi (8/12/2011)
If you right click on the database from SSMS and Select , Select the objects that you want to transfer and Export Data and run the wizard to copy the objects and data.It is very simple let me know if you need additional details.
Thanks for your reply.
So you mean...I need to have both SQL Server R2 and sql server 2008 sp2 in my machine.
From sql server 2008 R2 management studio ...select Export data ..and select 2008 SP2 server as destination. which means it tranfers all tables data? i have 300 tables.
what about schema, i need to copy schema and create a database in 2008 sp2 server ...right? before exporting data?
please correct me if I am wrong?
August 12, 2011 at 10:28 pm
If you run the wizard it creates an SSIS package, creates the schema and copies the data.
Have you tried right clicking on the database, selecting tasks, selecting export data and clicking the tables, etc?
It is very easy.
Let me know if you have any additional questions.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 13, 2011 at 1:20 am
How to downgrade a database from higher version to lower version
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
August 13, 2011 at 6:15 am
Thanks!
buy my SQL Server 2008 R2 backup file size is 2 GB.
I am not able to generate script/export with data in one time.
I am thinking..
created schema script and execute in blank database(SQL 2008)
then create scripts for300 tables, generate scripts for every 25 tables.....
please correct me if I am wrong...
August 15, 2011 at 10:10 am
task is completed.
Below are the steps I did.
1. create a empty database in SQL Server 2008 SP2 server.
2. copy only schema from SQL 2008 R2 version database to SQL 2008SP2 database ( throwing error when I tried to script both schema and data)
used Generate scripts option
script for sql server = sql server 2008 sp2
type of data to script = schema only.
3. Used to import and export wizard to migrate the data
source server- sql 2008 R2
destination server- sql server 2008 SP2.
got 2 errors
error 1: issue with identity column insert
fix: I have identified the table names which has identity columns for those tables i have enabled 'enable identity insert'
error2: Got error because import/export wizard does not run the migration based on the dependencies (foreign key).
fix: deleted FK's in source database and recreated FK's in destination db after migrating data
Thank you all.
August 15, 2011 at 11:15 am
if you have a tool such as Redgate SQLBackup or Quest Litespeed these tools can generate the schema and data insert scripts for you.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply