asked on

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

Lee

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.

akuss

ASKER

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?

Lee

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.

Lee

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

How big is the physical database?

akuss

ASKER

1.65 gb

ASKER CERTIFIED SOLUTION

Lee

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

akuss

ASKER

ok i will install express and let you know is there a specific tool i use like dts wizard?

SOLUTION

Lee

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

akuss

ASKER

I will let you know if it works

akuss

ASKER

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)

Lee

Do you have any DDL triggers? Try disabling them.

akuss

ASKER

I dont think i have any DDL triggers how would i go about finding them and disabling them?

akuss

ASKER

any ideas? i have no ddl triggers

akuss

ASKER

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.