Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 328
  • Last Modified:

SQL Server 7.0

Hello i need help migrating SQL 7.0 Dbase to SQL 2005 then to SQL 2012

I am unable to upgrade SQL 7.0 to 2005 because its on a windows NT machine and i've been trying everything with what i've been reading online to do this but every option given i've run into brick walls

so can someone give me a clear way to do this
0
akuss
Asked:
akuss
  • 8
  • 6
2 Solutions
 
Lee SavidgeCommented:
Back the database up.

On a new machine, install SQL 2012.

Patch SQL 2012 to latest Service Pack.

Restore database.

You may need to manage the migration of the SQL users to the new server.
0
 
akussAuthor Commented:
I was under the impression the SQL 2012 was not able to accept an sql 7.0 dbase without a go between like sql 2005?
0
 
Lee SavidgeCommented:
One thing to note is that when you restore the database the compatibbility level will still be on the previous version of SQL. This may be necessary though.
0
Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

 
Lee SavidgeCommented:
Ahh, yes you are quite right. I totally forgot that :)

How big is the physical database?
0
 
akussAuthor Commented:
1.65 gb
0
 
Lee SavidgeCommented:
There is no reason then why you can't install SQL Express and restore the database to that and then perform another backup.

You should be able to put SQL Express 2005 on any machine and restore you current database to it.
0
 
akussAuthor Commented:
ok i will install express and let you know is there a specific tool i use like dts wizard?
0
 
Lee SavidgeCommented:
No. Just do a database backup in the old one.

In the new SQL isntall create a new database with the same name as the one in the old SQL install. Restore your database over the top. Ensure that the paths are correct. Then once you have restored it you can back it up again from SQL 2005 and then restore onto SQL 2012.
0
 
akussAuthor Commented:
I will let you know if it works
0
 
akussAuthor Commented:
I received error message it gets to 100% done then throws error see below

System.Data.SqlClient.SqlError: DDL statement is not allowed. (Microsoft.SqlServer.Smo)
0
 
Lee SavidgeCommented:
Do you have any DDL triggers? Try disabling them.
0
 
akussAuthor Commented:
I dont think i have any DDL triggers how would i go about finding them and disabling them?
0
 
akussAuthor Commented:
any ideas? i have no ddl triggers
0
 
akussAuthor Commented:
well after installing sql express 2005 on three computers i guess third time is a charm it finally worked dont know what was going on.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 8
  • 6
Tackle projects and never again get stuck behind a technical roadblock.
Join Now