You can use spectra!
Create an empty database in mysql... name it cfaojbects_mysql
Select -> Applications and Data
-> Database Manager\
-> click the Database Migraiton tab.
Next...
Select the "Original Data Source" = cfaobjects
Select the "Destination Data Source" = cfaojbects_mysql
Then select the migrate button...this will move the
data from one database to the other.
Do this for the following databases
cfaobjects = webtop database (required)
cfaversiondb = versioning database (required)
cfaapplicationdb = default logging database (required)
cfarestorenet = example app database
cfaibuild = example app database
-Kurt.
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 17, 2003 3:41 PM
To: Spectra-Talk
Subject: RE: Core Spectra Databases on MySQL?
Thanks Kurt. I've got them in Access now, just trying to get them to
MySQL. Ugh.
S
Kurt Mossman <[EMAIL PROTECTED]>
09/17/2003 03:31 PM
Please respond to spectra-talk
To: Spectra-Talk <[EMAIL PROTECTED]>
cc:
Subject: RE: Core Spectra Databases on MySQL?
I have the access databases if your interested.
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 17, 2003 2:38 PM
To: Spectra-Talk
Subject: Re: Core Spectra Databases on MySQL?
The originals shipped in the Sybase SQLAnywhere and then they had you use
the webtop to do migration to other DB's. I'm looking to shortcut that
step. MySQL isn't very friendly at all to SQL Server DTS Imports.
"Neil Robertson-Ravo" <[EMAIL PROTECTED]>
09/17/2003 01:59 PM
Please respond to spectra-talk
To: Spectra-Talk <[EMAIL PROTECTED]>
cc:
Subject: Re: Core Spectra Databases on MySQL?
The Core Spectra DB's will be in the Spectra source install .cfm templates
-
or they should be?!
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: "Spectra-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, September 17, 2003 3:58 PM
Subject: Core Spectra Databases on MySQL?
> Is anyone running Spectra on MySQL? I'm trying to get my hands on the
core
> databases (cfaobjects, cfaapplicationdb, cfaversiondb, cfarestorenet.
> cfaibuild) as MySQL files or backups for an implementation.
>
> Thanks,
>
> Shawn Gorrell
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm?link=i:17:5429
Archives: http://www.houseoffusion.com/lists.cfm?link=t:17
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:17
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=<:emailid:>.<:userid:>.<:listid:>
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community.
http://www.fusionauthority.com/ads.cfm
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.