clifford_m71
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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/libr ary/cc6459 93%28v=sql .105%29.as px).
ASKER
Thanks for the help. I installed a 180 day trial version of R2 on another server. Thanks for the help.
ASKER