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.

Reply via email to