mdbbound
asked on
Coldfusion previously with Access but now will be in DB2
Hello
I developed this application with Coldfusion and Access. My IT Dept wants to convert the backend database from Access to DB2. If the data will now be in DB2, will I have to adjust my SQL that now works with Access. How will this work, and what problems will i have along the way. Please help
Thanks
I developed this application with Coldfusion and Access. My IT Dept wants to convert the backend database from Access to DB2. If the data will now be in DB2, will I have to adjust my SQL that now works with Access. How will this work, and what problems will i have along the way. Please help
Thanks
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Migrating a Microsoft Access 2000 Database to IBM DB2 Universal Database 7.2
http://www-106.ibm.com/developerworks/db2/library/techarticle/alazzawe/0112alazzawe2.html
http://www-106.ibm.com/developerworks/db2/library/techarticle/alazzawe/0112alazzawe2.html
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for all the helpful comments. I'll split the points
ASKER
My queries are Select, some with INNERJOIN, the most number of tables i join is three.
I also have some ADD, DELETE, UPDATE. I used some simple Query of Queries in coldfusion.
Thanks