SQL 7 to SQL 2000 question..

MagarG

MagarG

VIP Member
We would like to upgrade our Deployment Server from SQL 7 SP3 to SQL
2000.

Are there any issues with this? Just run the upgrade?

I couldn't find much on the KG except for the MTRs and MDAC levels
- SQL 2000 SP2 is supported beginning with SP19 (we are at SP19).
- Looks like we can't install SQL 2000 SP3 until SP21 is released.

TIA,

gm.

ENT: AS400 V5R1 OW Xe Update 5 Coexistence SP19 D1
DEP: NT 6a SQL 7 SP3
JAS: Win2000 (pending)





AS400 V5R1 Coexist CO-Win2000 NT Xe SP19 D1
 
I thought this was going to be an easy upgrade but encountered problems. I attempted an upgrade from SQL 7 to SQL 2000 2 weeks ago and had problems with the upgrade. The upgrade aborted part way thru with "error running script: upgrade.sql(1). We needed to restore the database to SQL 7 from the backup taken before the upgrade. I did research on this error and this was not an isolated occurance.

Here's the URL of one of the SQL Server forums addressing this problem.

http://www.sqlmag.com/forums/messageview.cfm?catid=4&threadid=5648

Good Luck,
Bill
 
Magar :

a) Run the upgrade.
b) Drop indexes, and reindex tables (and statistics) for all your tables.

Sebastian
 
MagarG-

I have performed several successful SQL upgrades, from 6 to 7. In every case
we installed a fresh SQL 7 on a new machine and imported the data from the
SQL 6 DBs.

Do you have such an option?

Regards,
David

Brightpoint NA
Sun/Oracle 8.1.6 / Citrix Xe base Sp15.1 live
Update 4 / SP18.1 sandbox
 
I agree with David. Unless you have a large number of scheduled jobs, DTS
packages, logins, etc. you will probably be better off installing fresh and
restoring or attaching the database. Especially if this database is just
used for the Central Objects storage.

I also second the DBCC CHECKDB and update statistics advice.

Brent Marxhausen
DBT, Inc.
email: [email protected]
 
It could possibly be an option but one of our other newer (non-JDE) SQL
7 servers was upgraded with no problem. Our COs are stored on this DS,
4 environments each taking about 3 gig.

I have to look about updating indexes and statistics. I have done the
CO reindexing through OMW manually on all the CO tables before and it
didn't take to long.
I haven't done Update Statistics. Looks like it is in the Data
Maintenance Plans in Enterprise Manager? Any idea how long this takes
to run per path?
Thanks,

Grant(gman)

MagarG-
I have performed several successful SQL upgrades, from 6 to 7. In every
case
we installed a fresh SQL 7 on a new machine and imported the data from
the
SQL 6 DBs.
Do you have such an option?
Regards,
David
Brightpoint NA
Sun/Oracle 8.1.6 / Citrix Xe base Sp15.1 live
Update 4 / SP18.1 sandbox
--------------------------
To view this thread, visit the JDEList forum at:
http://www.jdelist.com/ubb/showflat.php?Cat=&Board=OW&Number=46974
+ - - - - - - - - - - - - - - - - - - - - - - - -+
This is the JDEList One World« / XE mailing list/forum.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found on the JDEList Forum at
http://www.JDEList.com

JDEList is not affiliated with JDEdwards«

+ - - - - - - - - - - - - - - - - - - - - - - - -+



AS400 V5R1 Coexist CO-Win2000 NT Xe SP19 D1
 
Back
Top