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
mdbboundAsked:
Who is Participating?
 
mrichmonConnect With a Mentor Commented:
If you are talking about the CF code changing then things you need to watch out for:

If you did not use cfqueryparams then you should change to those as part of this process.  If you did then there will be little changes needed to escape your input variables in your queries.

If  you used Access specific functions like iif() then you will need to convert those to DB2 functions.


If you are looking for how to convert the database itself then see the above comments.
0
 
Tacobell777Connect With a Mentor Commented:
If DB2 is using the sql standard then you should not have to much trouble - if you do, it will mainly be when you use functions in Access, they might not be called the same in DB2...
And if you use any other non standard functionality from Access...
0
 
mdbboundAuthor Commented:
Thanks Tacobell777

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
0
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

 
Jerry_PangCommented:
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
0
 
Jerry_PangConnect With a Mentor Commented:
from that site
[quote]
Summary
On the Microsoft Windows platforms it is common to prototype Microsoft Visual Basic applications using Microsoft Access databases. When the prototype phase is completed, applications are then migrated to a relational database server, specifically IBM DB2 Universal Database V7.2.

There are a number of ways to export Access database tables to DB2. This article described two such methods: the Access Export Tool and the DB2 OLE DB Table UDF Assist Wizard. The UDF wizard has many advantages over the alternative. Some of these include the flexibility it offers in terms of remapping of column types, reordering of columns, selecting a subset of columns, providing more accurate default data types, and the ability to export tables, accommodate results of a query from possibly multiple-joined tables, as well as the ability to create a view to access the data directly from the OLE DB data source.
[\quote]

another way of migrating is using MsSQL Server ImportExport  Data.

note that there are SQL statements that works well in MsAccess but not on other languages.
like Custom defined functions used in SQL statements, the NZ() funtion will not work, etc.
0
 
mdbboundAuthor Commented:
Thanks for all the helpful comments.  I'll split the points
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.