Link to home
Start Free TrialLog in
Avatar of clifford_m71
clifford_m71Flag for United States of America

asked on

SQL Server 2008 R2 backup to SQL Server 2008

We are purchasing a company that uses the same software system as we do. I have been tasked to retrieve that data and get it into our database. I figured it's the same software so this will be easy. They have sent me a backup of their database (SQL Server 2008 R2). I thought I would simply be able to restore their database to a new database on our server until I realized we are on SQL Server 2008 standard and I cannot restore their R2 Database. Is there anyway for me to extract the data from the R2 Backup? It's not a very large DB so even if I can get it into some sort of csv file I would be happy.
ASKER CERTIFIED SOLUTION
Avatar of achaldave
achaldave
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
Avatar of clifford_m71

ASKER

Thank  you for the quick response. Can I download SQL Server 2008 R2 Express and restore the backup to that? Or do I need the regular R2 version?
Avatar of didnthaveaname
didnthaveaname

I don't see why you couldn't use R2 Express.  As long as their database is under 10GB (src: http://msdn.microsoft.com/en-us/library/cc645993%28v=sql.105%29.aspx).
Thanks for the help. I installed a 180 day trial version of R2 on another server. Thanks for the help.