comparing vs script files
Brian Donahue
Posts: 6,590 Bronze 1
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" <mrmikehead@yahoo.com> wrote in message
news:rT$xJ3OuDHA.1244@server53...
> 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
>
>
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" <mrmikehead@yahoo.com> wrote in message
news:rT$xJ3OuDHA.1244@server53...
> 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
>
>
This discussion has been closed.
Comments
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" <mrmikehead@yahoo.com> wrote in message
news:hNVf8tguDHA.1668@server53...
> 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
>
>
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" <mrmikehead@yahoo.com> wrote in message
news:W5KUvPfvDHA.1552@server53...
> 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?
>
>