SQL Server migration: 30 servers and 700 DBs


This week should be the last full week for current project at work. This project for handling receipts using mobile clients. I have been responsible for the database modelling, implementing a JSON service as an interface for Android and Window Mobile clients. I have been learning a lot the last weeks, regarding new features like using ASP.NET Web API and Entity Framework Code-First.  I have used Windows Azure for deploying the database and Web API during the development phase. Next week we will deploy the solution in one of our data centers and prepare deployment of new clients to the customers.

Today, I started at on a new project at work. This is part of a project where EVRY shall provide a high-performance data center solution to customer. My part of the project will involve upgrading, migrating and cancellation of databases from the customer environment to EVRY database hotel solution in one of our data centers.  All the databases involved for my part will be SQL Server. The current customer solution involve not less than 30 database servers (SQL Server 2000, SQL Server 2005 and SQL Server 2008 (R2). The customer has over 700 databases, which is very large in Norwegian scale.

The first step is to categories all the databases in the current customer environment. One of the first we need to address is the circa 50 SQL Server 2000 database. Since the support for SQL Server 2000 will expire in April 2013, we need to determine which database we have to upgrade and which ones we should exclude from the migration process as a part of the data center solution.

In addition, there are about 300 SQL Server 2005 and circa 400 SQL Server 2008 (R2) databases.

The new customer environment at our data center will include a development, test, QA and production domains. I think this will be a very interesting project, and hopefully we have completed the migration before the summer holidays.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s