Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
moorzee
Starting Member
5 Posts |
Posted - 2013-08-26 : 06:23:24
|
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
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-08-26 : 08:31:27
|
You cannot restore a SQL 2012 backup on to a 2008 R2 server. Installing 2012 Express client tools wouldn't help. |
|
|
moorzeee
Starting Member
2 Posts |
Posted - 2013-08-26 : 10:48:54
|
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...... |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-08-26 : 11:49:11
|
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. |
|
|
|
|
|