restore a sqlserver 2005 database into sqlserver 2012

Question

I have a db running on an instance of sqlserver 2003, Ive tried to import it into sqlserver 2012 but that wont work it's says it's to old.

so I've imported it into sqlserver 2005, I have then backed it up again and tried to import it into sqlserver 2012 but it comes up with the same error.

I can restore other db's from sqlserver 2005 so I can only presume its keeping its 2003 settings when I back it up.

Can anyone help

i don't think you really have sql server 2003 because it never existed ... there was sql server 2000 and then 2005 ... anyway ... maybe it helps if you change the compatibility level of your database after you restored it to sql server 2005 — PrfctByDsgn
– PrfctByDsgn, Commented Jan 9, 2014 at 14:23
Keep in mind that the suggestion to change compatibility levels of your database might end up breaking functionality. If, for instance, you have views, functions or stored procedures using functionality that was deprecated in 2005, those objects would no longer work as intended. — SchmitzIT
– SchmitzIT, Commented Jul 3, 2017 at 12:44

SchmitzIT · Accepted Answer · 2017-07-03 12:48:52Z

1

I suspect that your database might have some deprecated functionality that prevents your upgrade from working.

There's a list of deprecated functionality between SQL Server 2000 and SQL Server 2005 on technet.

I would strongly advise you to use the SQL Server 2005 Upgrade Advisor to identify such functionality, and address any potential issues. Then, and only then you should have a database compatible with SQL Server 2005, and can (hopefully) proceed from there.

answered Jul 3, 2017 at 12:48

SchmitzIT

9,74912 gold badges71 silver badges96 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

sivaprakash · Accepted Answer · 2019-07-31 11:29:52Z

1

if u want database structure only then take database script then run into sql server 2005, if u want database with data also mean

right click the Database go task
click Generate Script
There Two options entire database or with specific objects
entire database for DataBase structure only
with specific objects - select all objects then click Next you find the Advance button then click it.
scroll down and Find Type of Data Scripts click and change to Schema and data then you will save as file file or new query window

this is one of the method to restore the database.

answered Jul 31, 2019 at 11:29

sivaprakash

216 bronze badges

Comments

Andre Gompelman · Accepted Answer · 2017-07-03 12:34:03Z

0

Set your compatibility level to (90) Sql server 2005 in your database properties after restoring.

answered Jul 3, 2017 at 12:34

Andre Gompelman

442 bronze badges

Comments

Abu Ben Reaz · Accepted Answer · 2024-09-25 09:01:48Z

0

Needs step by step database version upgrade

You cannot directly upgrade a SQL 2005 database to SQL 2012. You need to first upgrade your databases to SQL 2008 after that you can upgrade to SQL 2012. If the database size is within limit of SQL Server 2008 Express version database size limitation, you can use this free version to upgrade.

answered Sep 25, 2024 at 9:01

Abu Ben Reaz

1881 silver badge8 bronze badges

Collectives™ on Stack Overflow

restore a sqlserver 2005 database into sqlserver 2012

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related