Version compatibility

• Ashok-148808

  SSC Veteran

  Points: 217

  More actions

  January 8, 2006 at 8:52 pm

  #170061

  I have my Applications (ERP) developed in VB 6.0 using SQL Server 2000 as Backend.

  We have planned to go for SQL Server 2005 ie migrate the data to SQL Server 2005 and Use the same applications.

  Will I need to change anything on my VB Code or SQL Server Tables, SProcs, Views Used. Kindly Update.

  ASHOK S

   

   

• peterhe

  SSChampion

  Points: 11469

  More actions

  January 9, 2006 at 7:14 am

  #613526

  There are some breaking changes. Please check ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/47edefbd-a09b-4087-937a-453cd5c6e061.htm in BOL.

  The test will be the last say. Take a backup of your current db and upgrade to 2005. Test your ERP application.