Re: [Emerald] Need Help/Ideas on Transferring Database
Dale E. Reed Jr. ( (no email) )
Mon, 18 Oct 1999 09:19:46 -0700
Nathan Haywood wrote:
>
> 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?
Install 6.5 on the Intel box and use the 6.5 transfer to transfer
from the Alpha to the Intel. Then install SQL 7.0 and do the upgrade
wizard.
--
Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com
For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart