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.
- 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
