Last post Jul 31, 2013 03:33 AM by feelwang
Jul 24, 2013 02:31 PM|nivekd|LINK
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).
Jul 25, 2013 05:50 AM|Michelle Ge - MSFT|LINK
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.
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.
Jul 25, 2013 04:12 PM|nivekd|LINK
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).
Jul 31, 2013 03:33 AM|feelwang|LINK
They have not necessary relation. You can upgrade the application without upgrading the DataBase. But you should make sure the connection is creect.