[EMAIL PROTECTED] wrote:
Hello all,
I have a Access 2000 database on a dedicated server running Cold
Fusion.
. . .
the corrupted parts)? This site has grown quite a lot over the last
2 years to the point where I know we probably need to move to a SQL
database now. Does anyone have any thoughts or suggestions on this
issue?
Best article on the subject:
Nine Reasons NOT To Use MS Access To Power A DB-Driven Website
http://www.aspemporium.com/tutorials.aspx?tid=12
Most likely the DB just can't keep up with the site. Back in '99 the
shop I was with had similar problems and we were sent to an ASP class so
we could switch away from "poor performing Coldfusion code". Once the DB
for those sites were switched from Access to SQL Server, the problem
went away and we kept on coding with CF. I still have the books from
that ASP class. They make great doorstops.
Is anyone available to contract to switch this data to a SQL / MySQL
database and update the code to work with it?
MySQL Migration Toolkit
http://mysql.com/products/tools/migration-toolkit/
Install a copy of MySQL locally, then run this on your Access file.
Unless you're using SQL that was generated by MS-Access, you shouldn't
have to change much. However, if your web host is on Linux, you'll have
to make your SQL code case sensitive.
My other question is: This site will be redesigned within the year
and most likely all in Flash. Will the SQL database be portable and
accessible to Flash?
AFAIK, Flash doesn't connect to a database. You will have to create
server-side (CF) code to provide data to your Flash files via Flash
remoting or a web service. The database doesn't have to change, you're
just going to be updating the user interface for it.
HTH,
Adrian J. Moreno
_______________________________________________
Reply to DFWCFUG:
[email protected]
Subscribe/Unsubscribe:
http://lists1.safesecureweb.com/mailman/listinfo/list
List Archives:
http://www.mail-archive.com/list%40list.dfwcfug.org/
http://www.mail-archive.com/list%40dfwcfug.org/
DFWCFUG Sponsors:
www.instantspot.com/
www.teksystems.com/
