Connecting Tech Pros Worldwide Forums | Help | Site Map

SQL Server Queries to DB2 compatible

Member
 
Join Date: Jun 2007
Posts: 99
#1: Nov 15 '08
Hi All,

I have a application that is using SQL Server Database.
But now we have to switch its database to DB2 as per requirement.

Please tell me how can I make SQL Server queries compatible to DB2?
as some of command are not supported by DB2 or syntax is different...

Help..

ck9663's Avatar
Expert
 
Join Date: Jun 2007
Posts: 1,925
#2: Nov 15 '08

re: SQL Server Queries to DB2 compatible


I doubt if you can make it compatible. As you said they have different syntax. Which means you can not have a query that can run on both. If your converting to a different DB, that means you have to re-write your queries.

-- CK
Reply