Link to home
Start Free TrialLog in
Avatar of samsar
samsar

asked on

SQL DB restore from SQL 2008 R@ to SQL 2008 Web Edition

I would like to know how can I restore a database from a server which has SQL 2008 R2 to a server which has SQL 2008 Web Edition installed on it
Avatar of Paul Jackson
Paul Jackson
Flag of United Kingdom of Great Britain and Northern Ireland image

Is the SQL Server 2008 Web Edition R2? if not it is not possible to restore an R2 backup to a none R2 SQL Server.
ASKER CERTIFIED SOLUTION
Avatar of Kevin Cross
Kevin Cross
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Good catch, jacko72. The limitation is in version of SQL and not edition. You can run SQL 2005 or SQL 2008 databases on SQL 2008 R2, but you could run a SQL 2008 R2 database on SQL 2005 as an example.
>>I would like to know how can I restore a database from a server which has SQL 2008 R2 to a server which has SQL 2008 Web Edition installed on it <<
You can't.  Consider moving the schema and data with something like Red-Gate's tools:
SQL Compare
SQL Data Compare.
Kevin.

>>but you could run a SQL 2008 R2 database on SQL 2005 as an example. <<
I suspect you are missing a "not" here.
Yes. *laughing*
it is not possible to restore a R2 databata to SQL SERVER the onll option is

Generate the scriprt and execute the date

i mean data not date
>>it is not possible to restore a R2 databata to SQL SERVER the onll option is<<
Yes, I think you will find that has been established.
Avatar of samsar
samsar

ASKER

Thank you for your help