DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Multi DBMS Environment

  1. 10-16-2002, 01:59 PM #1
    t3rryc
    t3rryc is offline Junior Member
    Join Date
    Oct 2002
    Location
    Canada
    Posts
    1

    Question

    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?
    Reply With Quote Reply With Quote
  2. 10-16-2002, 02:03 PM #2
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    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.
    Jeff Hunter
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width