Results 1 to 12 of 12
  1. #1
    Join Date
    Jul 2004
    Posts
    32

    Unanswered: Needs a SQL 2005 data and schema compare tool

    Just wondering if there are any tools available for SQL Server 2005 which allow the comparison and scripting of data and schema between two databases. This is so that I can migrate between Dev, QA, and Live easily.

    A free tool would be best please..

    Thanks in advance.
    Gaj

  2. #2
    Join Date
    Feb 2004
    Posts
    88
    I use sql compare and sql data compare from red gate. Not free, but not expensive either.

  3. #3
    Join Date
    Jul 2004
    Posts
    32
    I was looking at that but to be honest I'm looking for a free version if possible.

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Script the entire SQL and DDL for both databases to text files.
    Using NOTEPAD, print both scripts (preferably to onion-skin paper).
    Tape both scripts to a large, east-facing window, with one script on top of the other.
    Wait for morning.
    Using an exact-o knife, slice out the portions of the code that do not match, which will be clearly visible as the light shines through the papers.
    Paste the bits together and then type them into a script.

    FREE! Yeah!
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  5. #5
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    plz help. i ran out of onions.

  6. #6
    Join Date
    Jul 2004
    Posts
    32
    Quote Originally Posted by blindman
    Script the entire SQL and DDL for both databases to text files.
    Using NOTEPAD, print both scripts (preferably to onion-skin paper).
    Tape both scripts to a large, east-facing window, with one script on top of the other.
    Wait for morning.
    Using an exact-o knife, slice out the portions of the code that do not match, which will be clearly visible as the light shines through the papers.
    Paste the bits together and then type them into a script.

    FREE! Yeah!
    lol, very funny, not sure why your trying to say you don't get things for free, Microsoft has been providing loads of these tools lately and they are very good expecially the database publishing wizard..

    No wonder you've gone blind, take it easy with those onions..

  7. #7
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    I won a tool from SQLTeam for free that does this but I guess it does not count....

    You could script out to file and use UltraEdit (or a free text editor - I'll bet there are loads that can do this) to compare the scripts. Comparing data is much harder. In any event, apart from fixed lookup tables you really shouldn't care if prod, dev and test are out of synch.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  8. #8
    Join Date
    Jun 2007
    Location
    Ohio, USA
    Posts
    142
    I'm a papyrus/pen-knife man, myself...

    Good luck finding a one-stop free tool for that. You may be able to find individual tools for the individual tasks (one for scripting, one for compare, etc...). If you want 'easy', though, you're going to be paying for it.

    What have you found on Google?

  9. #9
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Sarcasm from gaj?!?!?
    I've given the best answer so far!
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  10. #10
    Join Date
    Sep 2003
    Location
    New York, NY
    Posts
    136
    have you tried sp_comparedb?
    google it

  11. #11
    Join Date
    Jul 2004
    Posts
    32
    Well I really had no Idea, seeing quite a few of these tools now I expected to be able to get it for free.

    No offence Blindman..

  12. #12
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    None taken. People around here already know how difficult it is to offend or irritate me.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

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