Sql Server Upgrade – my 5 Tips
| 1) How Can I Upgrade The SQL Server 2005 Enterprise X64 Trial Edition To Retail Version( I Bought The S/W)? |
| The server with trial edition has SP2 installed. But the retail version CD is just plain raw SQL server 2005 – without SPs. When I try to upgrade the database server as Microsoft spells out, it gives an error ‘Missing component error’. Can I go ahead and uninstall all the SPs and try to upgrade at that point? Any help would be great. |
| What I would do is make a backup of all your databases, uninstall SQL Server, then install the retail version. Once it is up and running, you can add the databases back in. |
| 2) Can I Upgrade From Sql Server 2005 Express To Developer Edition Without Any Conflicts? |
| I have VS2005 coming with sql server 2005 express edition. I am planning to upgrade to SQl Server Developer edition. Should I remove Express?/ Or just upgrade??
Thank you. |
| SQL Sever installation is long and involved. To ensure that you have a really stable installation without any conflicts its highly recommended that you completely uninstall express edition before installing developer edition.
Otherwise you’ll run into problems where instances use the express edition defaults even though you have developer edition. (Ran into several problems trying the upgrade method) |
| 3) I Have Access Database, How Can I Upgrade It To SQL Server Database? |
| I have a good experience in Using and Programming MS Access database and I am practicing it everyday. but it is a little bit slow because it is shared on the LAN with multiple users. As I know from a course I tooke about SQL sever database it is very fast . what are the basic steps to upgrade MS Access database to SQL server database? |
| Good answers, but no one has addressed the front end.
Only your data can migrate over to SQL. Your forms, queries, reports, macros, and modules cannot migrate. You can however use Access Project for your front end. Queries get replaced by Stored procedures, which are all SQL Code. There is no nice GUI to help with the design. The good news is that you can take the SQL code for a query and make a stored procedure after some modifications. All your forms and reports will be OK in Project, but the code has to be ADO, not DAO. If you are using ADO Code now, then you are going to be able to debug it more easily than if you are using DAO now. It can be frustrating. Good Luck and have fun. |
| 4) How To Upgrade Sql Server 2000 To 2005? |
| tell what is the best plan for updating data from sql server 2000 to sql server 2005 i have around 3 GB data on sql server 2000 and now i want to shifted all that data in my new database server so tell how it possible upgrate it on 2005 so tell me how can i start it?? |
| You can just insert your sql server 2005 CD-Rom in your Cd drive. Follow the steps shown by the setup wizard. In one it will ask you whether to update , Repair or install. You just select the update option and go on.
If Sql server 2005 is the available with you in Cd then just go to microsoft service centre i.e., http://www.microsoft.com You just backup your 3 GB data’s in your another drive so that it will be safe if some mistakes are done while updating sql server 2000 by sql server 2005. |
| 5) How Pressing Is It That I Upgrade From SQL Server 2000? |
| Our site/intranet is on a Windows Server 2003 box and our database is in MS SQL 2000. Our codebase is ASP Classic. Needless to say we are a bit behind. I noticed that the mainstream support for SQL 2000 ended last year and extended support for ends in 2013. This database has to be around for quite sometime and I’m assuming this is a good idea to tackle this sooner rather than later. How pressing is this issue really? Is it a very costly operation to upgrade to MS SQL 2008/ASP.NET? |
| If your site is stable now, you don’t need to upgrade to ASP.NET/MSSQL2008.
I know there some commercial sites still using ASP/SQL2000. One of these site are my company site, which has thousands transactions per day and bring to us about $8M/year. My company has a plan to upgrade to ASP.NET/MSSQL2008 in next 2 years. The cost is crazy. We are building a team with 4 senior.NET developer, 1 team leader, 2 tester, 1 graphic designer for this plan. Beside the human resources, we also need to buy a server, windows server 2008, MSSQL2008, VS2008 … |