Results 1 to 11 of 11
  1. #1
    Join Date
    Jun 2007
    Posts
    6

    Unanswered: Data migration Verification

    Hi all,

    I have somebody creating a C# class to migrate data from one SQL database to another slightly differently structured SQL database.

    Please can anybody suggest ways to verrify that the data has migrated successfully, in whole and acurrate??

    I feel a sample approach would not quite be substancial.
    I want to keep it seperate from the migration process itself (having my person write a verification script may also not work as he will be using the same thought processes and knowledge that he used for the migration)

    Free Software, scripts, utilities, packages, industry approaches??

    Sorry Im no Tech wizzard, Any ideas appreciated.....................

  2. #2
    Join Date
    Mar 2007
    Location
    636f6d7075746572
    Posts
    770
    How you verify it is going to be solely dependent on how the data is being migrated... i.e. by your developer

  3. #3
    Join Date
    Jun 2007
    Posts
    6
    Sorry can you expand on that.
    I appologise for not being able to be very specific with my question at this stage.

    What kind of dependancies? could you give some examples.
    What possible verification methods are there?
    This would probably help me plan the migration (its important to know this now before the data is migrated and it is too late to consider verification).


    Many thanks, its appreciated.

  4. #4
    Join Date
    Jun 2007
    Posts
    6
    Any data verification resources whatsoever?

    thanks
    Last edited by paulizaz; 06-15-07 at 05:58.

  5. #5
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    yeah, you got an answer to this 10 days ago

    http://lists.mysql.com/mysql/207213


    *** W000T *** 9000th post!!
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  6. #6
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Congratulations Rudy, you stud-muffin, you!
    George
    Home | Blog

  7. #7
    Join Date
    Jun 2007
    Posts
    6
    Are you talking about the MySQL Toolkit link?

    I would still like to find other resources, documentation, white paper, industry methods and standards, websites, industry examples, anecdotes, blogs etc.

    MySQL Toolkit is by far NOT the only (if at all suitable) solution. But keep boosting your posts up.

    thanks.
    Last edited by paulizaz; 06-15-07 at 06:49.

  8. #8
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Quote Originally Posted by paulizaz
    But keep posting as long as it boosts your figures and gets you a congratulations.
    You can't knock Rudy.
    He is one of the users who has contributed the most to this forum.

    So what if he's surly - it's allowed
    George
    Home | Blog

  9. #9
    Join Date
    Jun 2007
    Posts
    6
    Even bill gates can be knocked if he makes a mistake.

    I would like to think he has contributed with quality and not quantity.

    Thanks georgev
    Last edited by paulizaz; 06-15-07 at 06:08.

  10. #10
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Quote Originally Posted by paulizaz
    I will knock bill gates if he makes a mistake.
    That's fine as long as you're willing to admit when you too make a mistake
    George
    Home | Blog

  11. #11
    Join Date
    Jun 2007
    Posts
    6
    Indeed, i'd like to think people would tell me when I do. Its the only way to learn.

Posting Permissions

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