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
akussAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Lee SavidgeConnect With a Mentor Commented:
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
 
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
Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

 
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
 
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
 
akussAuthor Commented:
ok i will install express and let you know is there a specific tool i use like dts wizard?
0
 
Lee SavidgeConnect With a Mentor Commented:
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
All Courses

From novice to tech pro — start learning today.