Solved

Coldfusion previously with Access but now will be in DB2

Posted on 2004-09-22
6
162 Views
Last Modified: 2013-12-24
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
0
Comment
Question by:mdbbound
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 17

Assisted Solution

by:Tacobell777
Tacobell777 earned 160 total points
ID: 12128444
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
 

Author Comment

by:mdbbound
ID: 12129462
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
 
LVL 9

Expert Comment

by:Jerry_Pang
ID: 12129641
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
Flexible connectivity for any environment

The KE6900 series can extend and deploy computers with high definition displays across multiple stations in a variety of applications that suit any environment. Expand computer use to stations across multiple rooms with dynamic access.

 
LVL 9

Assisted Solution

by:Jerry_Pang
Jerry_Pang earned 160 total points
ID: 12129661
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
 
LVL 35

Accepted Solution

by:
mrichmon earned 180 total points
ID: 12134112
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
 

Author Comment

by:mdbbound
ID: 12138059
Thanks for all the helpful comments.  I'll split the points
0

Featured Post

Report: Liquid Web beats Amazon, Rackspace & More

A study by performance analyst firm Cloud Spectator finds that Liquid Web beats rivals Amazon, Rackspace and DigitalOcean when it comes to website and cloud application performance.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Most ColdFusion developers get confused between the CFSet, Duplicate, and Structcopy methods of copying a Structure, especially which one to use when. This Article will explain the differences in the approaches with examples; therefore, after readin…
Objective of This Article In 1990’s, when I was a budding software professional, I had a lot of confusion about which stream or technology, I had to choose to build my career. In those days, I had lot of confusion like whether to choose System so…
The purpose of this video is to demonstrate how to add AdSense Ads to a WordPress Website, and how to set up WordPress to automatically place Ads in Sidebars. This will be demonstrated using a Windows 8 PC. Log into your AdSense account. : Cli…
The purpose of this video is to demonstrate how to integrate Mailchimp with Facebook. This will be demonstrated using a Windows 8 PC. Mailchimp and Facebook will be used. Log into your Mailchimp account. : Click on your name. Go to Account Setti…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question