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.

 All Forums
 SQL Server 2012 Forums
 Other SQL Server 2012 Topics
 SQL Server 2012 Express won't restore dbs

Author  Topic 

madlo
Starting Member

41 Posts

Posted - 2013-05-20 : 18:39:09
I have SQL Server 2012 Express insalled on my dev machine because it is lightweight( I have to supported many systems) and the licence is free.

However I have clients that have proper version of SQL Server anything from 2000 to 2008. Now I had a clients who send me their dbs and I hav to do queries on their dbs however I can't since as soon as I try to either restore or attach those databases to SQL Server 2012 Express I get it is not allowed due to product incompatibility and it refuses to restore or attach the datase to Express.

1. Is their away around this?

2. I know sql 2000 had a publishing wizard which at least generated the data with it which I could ask clients to send me but later version don't have this. Is there any such tools for sql 2005 to 2012

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-05-21 : 05:07:52
http://blogs.technet.com/b/mdegre/archive/2012/06/15/migration-sql-server-2000-to-sql-server-2012.aspx

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
   

- Advertisement -