Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

SQL Server 7.0

Posted on 2013-11-01
14
Medium Priority
?
324 Views
Last Modified: 2013-11-01
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
Comment
Question by:akuss
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 8
  • 6
14 Comments
 
LVL 25

Expert Comment

by:Lee Savidge
ID: 39616679
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
 

Author Comment

by:akuss
ID: 39616684
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
 
LVL 25

Expert Comment

by:Lee Savidge
ID: 39616685
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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 25

Expert Comment

by:Lee Savidge
ID: 39616703
Ahh, yes you are quite right. I totally forgot that :)

How big is the physical database?
0
 

Author Comment

by:akuss
ID: 39616722
1.65 gb
0
 
LVL 25

Accepted Solution

by:
Lee Savidge earned 1500 total points
ID: 39616749
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
 

Author Comment

by:akuss
ID: 39616769
ok i will install express and let you know is there a specific tool i use like dts wizard?
0
 
LVL 25

Assisted Solution

by:Lee Savidge
Lee Savidge earned 1500 total points
ID: 39616782
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
 

Author Comment

by:akuss
ID: 39616862
I will let you know if it works
0
 

Author Comment

by:akuss
ID: 39617097
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
 
LVL 25

Expert Comment

by:Lee Savidge
ID: 39617128
Do you have any DDL triggers? Try disabling them.
0
 

Author Comment

by:akuss
ID: 39617159
I dont think i have any DDL triggers how would i go about finding them and disabling them?
0
 

Author Comment

by:akuss
ID: 39617393
any ideas? i have no ddl triggers
0
 

Author Comment

by:akuss
ID: 39617683
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

Featured Post

Survive A High-Traffic Event with Percona

Your application or website rely on your database to deliver information about products and services to your customers. You can’t afford to have your database lose performance, lose availability or become unresponsive – even for just a few minutes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question