Upgrading the GIS application and database.

In this article I will mention a specific issue that I experienced during my last GIS application and database upgrade.

Mission Critical: SQL Server Upgrade

You're faced with the task of doing a SQL Server Upgrade? Do you know all the steps, and the right order to do them? You do? Even with interruptions and distractions? Maybe, but it is wise to be able to refer to the Mission-Critical Task checklist.

Database Server Upgrades – The Plan, The Template, and The Task List

This article enables DBAs to efficiently upgrade servers by assembling an upgrade team, using an upgrade template, and communicating effectively.

Testing a SQL Server environment before an upgrade

Learn how application and full regression testing can ensure a successful SQL Server upgrade – and save on money and performance headaches.

Does Upgrading to SQL Server 2008 Fit Your Business?

While SQL Server 2008 offers several new benefits for organizations, the trick is figuring out if those performance and availability advantages are truly worth the upgrade.

Upgrade Strategies for SQL Server 2008

If you make the decision to upgrade to 2008, there are a number of tools that make the process easier, but you still need to understand what things you should consider. We have a new article from Arshad Ali to help you understand the process and what you should consider.

Restoring a database during SQL Server upgrade

Part 2 in this upgrade series lists the steps to point application traffic at a transition server while the primary cluster is rebuilt to Windows Server 2003 and SQL Server 2005.

Checkpoint

Microsoft SQL Server Migration Assistant

Are you looking to move your Oracle databases to SQL Server? You should be and when you convince your management to do so, Microsoft has a tool to help. New author Suresh Maganti of Scalability Experts brings us a look at how this works.

Access to SQL Server: Linking Tables

SQL Server 2000 and Access databases can be configured to work closely together. If you find that the Access storage format is not handling your needs and an upgrade is needed, you need not through away all of your access development. Instead, you can link Access tables to underlying tables in SQL Server and improve your application by using SQL Server as the backend for your Access project. Author Kathi Kellenberger brings us her second articles in an Access series looking at Linking tables to