Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2010

    Unanswered: data transfer from old sql server databse

    I am looking for directions for the following scenario.

    One of the legacy application is going through an upgrade.

    The database of this application is going through changes like the tables are expanding. Like suppose Initially a table was like

    Name :AreaScan

    AreaScanID varchar
    AreaScanDone bit
    MineralsIdentified bit
    MineralAreaSize varchar
    MineralLocation varchar
    MineralAreaSurroundings varchar

    Such table(above example) are being broken into two tables
    AreaScan and MineralInfo

    AreaScanID varchar
    AreaScanDone bit
    Minerals Identified bit


    MineralID varchar
    MineraLocation varchar
    MinearLocSizeX float
    MinearlLocationSizeY float
    MineralLocationSizeZ float

    MineralLocationAreaScanID varchar
    AreaScanDone bit
    Minerals Identified bit
    MineralAreaSize varchar
    MineralAreaLocation varchar
    MineralAreaSurroundings varchar

    If you notice the above that the information that was stored as varchar intially is not stored in a more detailed manner, and in float format .

    Most of the tables are going through this kind of change.

    I am trying to know, what is the best way of transferring data from the old database to new database.

    For example initially MineralLocation was text field and could contain text like


    but now, for each location in a particular area, I will have a new row in new table MineralInfo.
    what is the best way of extracting such info, from old table and put in new table

  2. #2
    Join Date
    Aug 2010

    you can try to use Microsoft SQL Server Migration Assistant for MySQL v1.0 ans is free :

    Download details: SSMA for MySQL v1.0

    Good luck.

  3. #3
    Join Date
    Jan 2009
    United Kingdom
    1)Export the data either in the way you wish to reimport or
    2)create some intermediary tables where you can get the data into the right columns \ data types
    3)Use the SQL server Import\Export wizard - and there is an option to create custom sql statements

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts