Ask a Question related to Coldfusion Database Access, Design and Development.
-
KnotNEditor #1
Converting an old site from Access to MySQL?
Hi
Hope someone can advise me. I have a site (a voluntary-run educational
website) running on an old server and am looking for new hosting. However I
notice that only MySQL hosting is offered now and my databases are in Access.
How difficult is it to convert Access to MySQL in the context of ColdFusion?
The related question is that my old CF installation is 4.5 - are there
implications for the code if moving to current versions of Cold Fusion? I am
not highly skilled with CF - the code was written for me by someone else and I
can maintain it but I'm not sure whether I could upgrade it.
KnotNEditor Guest
-
converting a MySQL 4.1 subquery to something that'll work with MySQL 4.0
Say I have the following SQL query: UPDATE phpbb_users SET user_nthpost = ( SELECT post_time FROM phpbb_posts WHERE phpbb_users.user_id =... -
Converting existing site to Contribute
I have an existing site that I want to set up for Contribute, to allow someone to do minimal editing. The actual web site is with a web-hosting... -
CONVERTING MS ACCESS TO FILEMAKER PRO 5
I am not sure if this is the right place to ask this question. I want to convert an MS ACCESS 2000 data to FileMaker Pro 5. Any ideas Thanks -
Converting a MySQL result into a complex array
How would I take the results of the following MySQL statement and put it into an array as follows? SELECT * FROM numbers WHERE type=`1`; SELECT... -
Converting Access to SQL Server
> I am getting request in the area OF 'SQL Server' and my Really depends on how much code you wrote in Access / VBA, and how much is based on... -
Dan Bracuk #2 Re: Converting an old site from Access to MySQL?
I once converted one from Access to Oracle and, while the work was not
exceptionally difficult (but I'm good at this sort of thing), there was a very
large amount of it.
Generally, what I did was:
1. Create the new tables and relationships in Oracle.
2. Bring in the existing data from Access.
3. In development, test and, if necessary, change the existing cold fusion
templates.
While this was happening, the existing data was being updated so, when I was
ready to go live, I :
1. Took away all the cold fusion pages that used the Access database.
2. Updated the data in Oracle.
3. Put the new pages into production.
One thing that I remember is that I had to change the dsn name in Cold Fusion.
Something very strange was happening (I forget the details), and after much
head scratching, and trying different things, we changed the dsn name and the
pages started playing nicely.
Dan Bracuk Guest
-
The ScareCrow #3 Re: Converting an old site from Access to MySQL?
If you go to the mySQL site they have a free tool that will import the ms access db stright into mySQL
Ken
The ScareCrow Guest
-
BKBK #4 Re: Converting an old site from Access to MySQL?
You might benefit from
[url]http://www.macromedia.com/cfusion/webforums/forum/messageview.cfm?catid=6&thread[/url]
id=1103274. There, you will also find a link to the MySQL Migration Toolkit
that The ScareCrow mentioned.
BKBK Guest
-
KnotNEditor #5 Re: Converting an old site from Access to MySQL?
Many thanks for the replies.
KnotNEditor Guest
-
dmsoft@gmail.com #6 Re: Converting an old site from Access to MySQL?
Hello,
Try Access2MySQL Pro at
[url]http://www.data-conversions.net/access-to-mysql-pro-converter.html[/url]
Hope it will help
Best regards,
Dmitry Narizhnyh,
[url]http://www.data-conversions.net[/url]
dmsoft@gmail.com Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
