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

    Unanswered: data transfer from old sql server databse

    Hello
    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
    Columns:

    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

    AreaScan
    AreaScanID varchar
    AreaScanDone bit
    Minerals Identified bit

    MineralInfo

    MineralID varchar
    AreaScanID
    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

    Location1,Location2,Location3.

    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
    Posts
    1
    Hello,

    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
    Location
    United Kingdom
    Posts
    77
    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
  •