• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 166
  • Last Modified:

Convert SQL 7.0 to 2000

Is there a way to convert SQL 7.0 to 2000?

If so what is the process???

Does anything have to be modfied after conversion. Tables etc.
0
Idarac
Asked:
Idarac
1 Solution
 
JesterTooCommented:
Here is an excellent description of how to do that...

   http://www.sqlteam.com/item.asp?ItemID=9066

HTH,
Lynn
0
 
geotigerCommented:

There are not many differences in the internal architecture between SQL Server 7.0 and SQL Server 2000. SQL Server 2000 has the same features as SQL Server 7.0: autogrow features, new storage engine, complete row level locking and so on. So, the general characteristics of these versions are the same.

But there are some pros and cons as discussed in this article: http://www.mssqlcity.com/Articles/Compare/SQL70vs2000.htm.

0

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

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