Multi DBMS Environment

[t3rryc]

We develop software products using VB6 against an Oracle Database. On the database side we have tables, indices, functions, triggers, and packages. Some of our clients want to us to offer our products for a SQL Server environment. Is anyone aware of any DB Management / Migration tools which would allow us to maintain the Oracle DBMS as our primary environment but ease the translations to SQL Server?

[marist89]

The best way, IMHO, to handle this situation is to put your business logic in the middle tier instead of stored procedures & packages. Your performance will suck, but you will be able to service every database vendor.