SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 2012 express alongside 2008r2
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

moorzee
Starting Member

United Kingdom
5 Posts

Posted - 08/26/2013 :  06:23:24  Show Profile  Reply with Quote
I developed a small application and client has deployed onto a sql express 2012 server. On my dev machine I have 2008 r2, I need to restore a backup from client for investigation, unable to on 2008 obviously, can I simply install 2012 express client tools or am i stuck?

James K
Flowing Fount of Yak Knowledge

3651 Posts

Posted - 08/26/2013 :  08:31:27  Show Profile  Reply with Quote
You cannot restore a SQL 2012 backup on to a 2008 R2 server. Installing 2012 Express client tools wouldn't help.
Go to Top of Page

moorzeee
Starting Member

2 Posts

Posted - 08/26/2013 :  10:48:54  Show Profile  Reply with Quote
quote:
Originally posted by James K

You cannot restore a SQL 2012 backup on to a 2008 R2 server. Installing 2012 Express client tools wouldn't help.


Great. so your advice is......
Go to Top of Page

James K
Flowing Fount of Yak Knowledge

3651 Posts

Posted - 08/26/2013 :  11:49:11  Show Profile  Reply with Quote
I don't have any advice that can be considered good.

1. If your database is less than 10GB, you might be able to install an Express edition of SQL 2012. Some of the features may not available either.

2. You can create a new database on your SQL 2008 installation, generate the creation scripts from SQL 2012, use that to create the objects in SQL 2008. Then bring over the data using SSIS or similar. See Pinal's blog here : http://blog.sqlauthority.com/2012/12/25/sql-server-restoring-2012-database-to-2008-or-2005-version-and-2-other-most-asked-questions/

3. Get an installation of SQL 2012. If you have an MSDN license, you can install developer editions. You can also get trial versions of SQL 2012, although I don't want to suggest one way or the other about the legality of using it for your specific purpose.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000