Re: [Emerald] Need Help/Ideas on Transferring Database

( dan@dmn.com.au )
Tue, 19 Oct 1999 08:12:55 +0800

You may install SQL 6.5 on Intel box and transfer everything do the upgrade
on Intel box, to minimize the down time, you can implement replication
during off peak time and do the upgrade.

Regards,

Dan Tang
Network Operation
Domain Technology
----- Original Message -----
From: Nathan Haywood <nhaywood@whro.org>
To: <emerald@iea-software.com>
Sent: Monday, October 18, 1999 11:15 PM
Subject: [Emerald] Need Help/Ideas on Transferring Database

> Alright folks, here's the ugly situation. We're currently running SQL
> 6.5 SP5 on an Alpha and want to transition our Emerald database to our
> new SMP Intel box running SQL 7.0. The problem is that the 6.5->7.0
> upgrade wizard says that it won't run across platforms (Alpha->Intel),
> the Data Import Wizard only gets the tables, and having SQL 6.5 gen
> scripts for creating all the objects creates a script that gives a bunch
> of diff errors in some of the SPs. I have also tried creating a fresh
> Emerald database with the Admin (2.88) on the new box and then trying to
> transfer the data with the import wizard, but the web of interwoven
> dependencies kills that pretty quick.
>
> Any suggestions? Dale, do you have a magical tool in your collection
> that would let me transfer or export and then import the database?
>
> Nathan - WHRO
>
> For more information about this list (including removal) go to:
> http://www.iea-software.com/support/maillists/liststart

For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart