Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004
    Peg City

    Unhappy Unanswered: SQL Conversion (of doom)

    Hello scholars,

    I am just starting to tackle a monster project of magically enhancing a VB app built on Access 2000 to be able to work with SQL Server. Unfortunately, the queries have been hard-coded into VB so I am afraid I may have to manually go through the entire app modifying each query. I have read about SQL Server's builtin migration tools (and Access' Upsizing Wizard) but not sure if it applies.

    Ideally, I would love to use all ansi SQL statements and have the connection object transform the SQL statement so it can be run against either one of the DBMSs.

    Is this possible without having to rewriting everything?
    Thanks for all input!

  2. #2
    Join Date
    Aug 2003
    Kingston, Ontario
    Just change the connection string. The queries will probably not need to be touched. I flip my apps back and forth all the time.

  3. #3
    Join Date
    Jun 2003
    Provided Answers: 1
    An SQL Conversion of Doom? That has got to be the coolest project I've ever heard of. Doom I or Doom II?

    Let me know if you need any help writing stored procedures for those big pink demon monsters. They were ultra-wicked!
    If it's not practically useful, then it's practically useless.

    blindman "sqlblindman"

Posting Permissions

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