comparing vs script files

Brian DonahueBrian Donahue Posts: 6,590 New member
edited December 11, 2003 7:48AM in SQL Compare Previous Versions
Hi Mike,

Thanks! We don't profide a way to directly compare a SQL script against
a database instance. The best we can do is to allow you to save a schema as
a snapshot (.snp) file, so you can compare the snapshot against the
database. You'll find that option discreetly hidden under the 'More' button
on the project settings wizard.

Kind Regards,

Brian Donahue
Red Gate Technical Support



"Mike D" <[email protected]> wrote in message
news:[email protected]
> We keep our sp and table scripts under version control in CVS. Is there
any
> way to compare a SQL instance (tables and sp's) vs individual .sql script
> files that reside on a drive somewhere?
>
> This will help us ensure that the .sql scripts for sp's and tables are in
> sync with the server
>
> BTW, great product
>
>

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    Hi Mike,

    It's the screen you usually see when you first start the program. You
    can also get to it through the toolbar from the first icon on the left.

    Yours,

    Brian Donahue
    Red Gate Technical Support

    "Mike D" <[email protected]> wrote in message
    news:[email protected]
    > Brian,
    >
    > That might work. I'm using the 14 day bundle, couldn't find the "project
    > settings wizard" - can you guide me to it?
    >
    > Mike
    >
    >
  • Brian DonahueBrian Donahue Posts: 6,590 New member
    Hi Mike,

    Sorry, I don't know of any way to manually construct a snapshot file. At
    any rate, the software expects all of the SQL database objects to appear in
    the snapshot. Also, the format is internal and it's subject to change, so
    I'd definitely avoid messing with it because it could be a potential
    time-waster!

    yours,

    Brian Donahue
    Red Gate Software Support


    "Mike D" <[email protected]> wrote in message
    news:[email protected]
    > OK, I see the direction. The problem is that the snapshot file contains
    > code generated by sql compare from a sql server instance. If I am going
    to
    > use the snapshot file as one side of the compare, then I need a means of
    > creating a .snp file from the series of scripts that I have on the hard
    > disk.
    >
    > Is there a way to paste my individual stored procedure files together into
    a
    > .snp file? is there an internal file layout for the .snp file available?
    >
    >
This discussion has been closed.