locked
VB.Net ver 7.1 & SQL 2k5/2k8 RRS feed

  • Question

  • User-773355071 posted

    We have some in house application (production) develop in 2003 VB.Net ver 7.1 using a SQL 2000.  One, will the apps work if they were point to an upgrade version of SQL such as 2K5 or 2K8 r2.  If the apps were upgraded to Visual Studio 2010 with a back-end of SQL 2K5/SK8, they should work just as well or would it require some re-write (the .aspx modules).

    Wednesday, July 24, 2013 2:31 PM

All replies

  • User-734925760 posted

    Hi,

    As far as I know, there are two upgrading. The Vistual Studio 2003 will upgrade to Vistual Studio 2010, and the SQL 2000 will upgrade to SQL 2005/2008.

    1. Will the apps work if they were point to an upgrade version of SQL such as 2K5 or 2K8 r2?

    In SQL Server 2000 database Machine, start the SQL Server 2005 setup, setup program automatically detects a previous version of the SQL Server instance, and prompts you to upgrade to 2005. Setup will start the Upgrade wizard, we just use the Upgrade Wizard step by step operation can complete the entire upgrade process from SQL Server 2000 to 2005.

    There is no need to plan the database. All structures that preserve the original SQL Server 2000, including user, role, login, permission sets, and so on. Without having to set.

    Just be sure to back up before upgrading all of the original database file, such as data files and log files to ensure that in case the upgrade fails to recover, not disrupting the business.

    2. The apps were upgraded to Visual Studio 2010 with a back-end of SQL 2K5/SK8.

    It’s ok to upgrade Vistual Studio 2003 to Vistual Studio 2010, please back up your application.

    Generally higher version will compatible the lower version, if you use a later version has left behind will need to manually modify. You use the Vistual Studio 2010 to open the Vistual Studio 2003 Projects, it will prompt conversion.

    3. Vistual Studio 2010 work with SQL 2005/2008

    SQL as an interface be provided to the Vistual Studio applications, if we promise the DB and application are ok, the application will work ok.

    If you have problems, please feel free to contact to me.

     

    Best regards,

    Michelle Ge

    Thursday, July 25, 2013 5:50 AM
  • User-773355071 posted

    So if I understand you right, I must do a database upgrade as well as an application upgrade.  I just can't do a database upgrade only (or vice versa, an application upgrade).

    Thursday, July 25, 2013 4:12 PM
  • User1505679561 posted

    Hi,

    They have not necessary relation. You can upgrade the application without upgrading the DataBase. But you should make sure the connection is creect.

    Wednesday, July 31, 2013 3:33 AM