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
samsarAsked:
Who is Participating?
 
Kevin CrossConnect With a Mentor Chief Technology OfficerCommented:
I have not yet tried the Web Edition of SQL 2008, but I do not believe there was a compatibility issue with restoring a database created in standard edition. Might be wrong, so please advise what specific error you are getting in the restore process.

You can also try copying the database objects over:
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/A_7251-Database-Copying-Wizardry.html
0
 
Paul JacksonSoftware EngineerCommented:
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.
0
 
Kevin CrossChief Technology OfficerCommented:
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.
0
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
Anthony PerkinsCommented:
>>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.
0
 
Anthony PerkinsCommented:
Kevin.

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

Generate the scriprt and execute the date

0
 
Ramesh Babu VavillaCommented:
i mean data not date
0
 
Anthony PerkinsCommented:
>>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.
0
 
samsarAuthor Commented:
Thank you for your help
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.