Post reply

Compare and Script 2 Databases

  • November 24, 2005 at 2:03 am

    #102955

    This is not a problem, as such as an offer of a tool I use.

    Being on a tight budget add ons and expensive tools are out of my reach. As many of you probably do, I write tools to help my day to day life. One of Which is a HTA app which I run locally that allows me to compare 2 databases (on 2 different servers if that is required) and inform me where the differences are. It also scripts the delta (if required)

    It scripts....

    Tables

    SP

    Views

    UDF

    Triggers

    permissions

    Indexes

    Default values

    etc

    If this is of interest to anyone, leave a thread. I also have other widgets e.g. that scripts data, based on a query

    Amongst others

    Adrian

  • November 25, 2005 at 7:22 am

    #605844

    Sounds good, if for no other reason then to make sure my manually created stuff is working right.

    I'm a big fan of commented code.

    - Robert Sterbal

  • November 26, 2005 at 11:42 am

    #605961

    a widget like that would be handy for me; I often have to find schema differences between a client db and the expected schema.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • November 27, 2005 at 1:18 pm

    #605986

    very good ,am interested too.

  • November 27, 2005 at 3:04 pm

    #605996

    There are lots of useful scripts here

    http://www.sqlservercentral.com/Scripts/

    I seem to remember a comp2db script; but did not see it when I looked.  This is obviously a worthy script to have in your toolbox.

    Cheers,

    david russell

  • November 28, 2005 at 7:00 am

    #606061

    I'd be interested as well!

    Thanks,

    Mike

  • November 28, 2005 at 1:19 pm

    #606211

    Adrian, please count me in.

  • November 29, 2005 at 2:29 am

    #606347

    Sorry for the delay, have only just looked back at the response. I have just realised that this does not allow upload of files(perhaps that could be reviewed).

    I was going to attach 2 files...

    Database Compare

    Data scripter

    These files are a bit too large to paste in here. My email is ade_turner@hotmail .com (please dont mis-use this - I get enough spam) and I will send you the files with a brief explanation. Use the subject 'SQL Widgets'.

    I will also have a look at the scripts section and see if there is an upload area there. So if you cant do the email route check for the files there.

    Obviously, the usual applies... Use these at your own risk, no guarantees etc

    Adrian

  • November 29, 2005 at 8:19 am

    #606426

    Adrian - have you thought of converting this to an article (or two) & sending it to Steve - I'm sure a lot of us would be interested in something so very useful and would definitely be nice to have in the "archives" to unearth at will....







    **ASCII stupid question, get a stupid ANSI !!!**

  • March 22, 2015 at 11:18 pm

    #1785611

    Adrian, Can u share the code here?

Viewing 10 posts - 1 through 9 (of 9 total)

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