Options
VSS and SQL Compare
hortoristic
Posts: 2
SQL Compare rocks for keeping our DB in sync as we move up from dev to test to pre-prod and finally production.
Now the developers aren't keeping VSS in Sync - is there an easy way to compare VSS with our Dev environment?
As far as I can tell - Getting all the Objects from VSS and loading them into a temp DB ans using SQL Compare works well - but is time consuming. Any better ways?
Now the developers aren't keeping VSS in Sync - is there an easy way to compare VSS with our Dev environment?
As far as I can tell - Getting all the Objects from VSS and loading them into a temp DB ans using SQL Compare works well - but is time consuming. Any better ways?
This discussion has been closed.
Comments
Sorry for the delay in answering. SQL Compare doesn't integrate particularly well with source control solutions. The best idea I can come up with is to simply keep the SQL Compare database snapshots in the source control system. This keeps you up to date not only with singular objects in the database, but any objects that they depend on as well. But then you have to worry about tying yourself to the .snp format and how you would go about checking the snapshots in and out as well.