Post reply

data migration

  • August 6, 2007 at 5:59 pm

    #92574

    I have an excel sheet and I am migrating it to another system.During course of migration if business people come and say that some more changes need to done to the excel sheet,how should such kind of things need to be handled?

  • August 7, 2007 at 1:35 am

    #725032

    I think you need to prepare a migration doc and once changes are done migrate it to the target system (SQL Server database I think) by DTS import wizard.

    Different options are available like create/append to the existing tables. You can even write a query according to your scenario to import the data  to the DB.

    Minaz

    "More Green More Oxygen !! Plant a tree today"

  • August 7, 2007 at 2:21 am

    #725039

    you should have a change management process in place to cover your back.

    Everything you can imagine is real.

  • August 7, 2007 at 3:09 am

    #725048

    Agree with the above comments.

    Also, sit down with the business sponsers and discuss the data that needs to be migrated.  Define the data in Excel so you can then build the database schema (or simply import using DTS and build the tables that way).

    The best approach is to document the findings from the meeting and get it signed off by the business.  Any further changes, add ammendments to the documentation - This is especially key if the project is delayed.  You can then demonstrate that the goalposts kept on moving!

  • August 21, 2007 at 6:21 pm

    #728460

    Thanks all for your suggestions..I will do that..

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply