Consolidating sql databases

There is a lot of redundancy and things have to be sorted out and the databases in the 2 boxes normalized and moved into one central Box.To give you an overview of the stuff here, there are close to 30-40 different web/windows/service type applications in production and quite a lot of them are what I would rate Legacy!!

consolidating sql databases-60

updating plone - Consolidating sql databases

I would look over the data which is actually being stored.

More than likely you will find whole tables with no records or whole fields with no data. Make a backup of everything before you make any changes and store it someplace where it won;t get overwritten.

You can note eachtask you need to do in it when you find it and then you won't forget to do it when the time comes that you are ready for that part. You will need to know exactly what you need to do and when.

Plus, after you put each task inthe tracker, you have record of exaclty what was done, to show management exactly how complex a task it was. (I am assuming you actually then go one to perform the tasks you put in the tracker.) I was amazed at how much better our development process was when we started putting all tasks into the bug tracker, not just bugs.

One of the largest US national energy suppliers wanted to upgrade their SQL Server system and deploy it on VMware.

As a consulting partner, we offered a new architecture for their virtualized system.

Then if you omit something in your redesign that turns out to be necessary, at least you can easily get the structure and original data back.

It is also best to not delte anything until your redesign is complete and tested.

not legacy applications, but apps written in VB/ASP that have existed for quite sometime...

Most of the people here are not even sure which ones are used and which ones are not! Profiler can be set up to run a trace that can be analyzed to see what databases, tables, queries etc are called over a period of time.

Yes this is a boring, tedious, time-consuming task.

Tags: , ,