Activity overview
Latest activity by muaddba
DDL Triggers not showing as different
I have 2 databases with the same schema, except 1 has DDL triggers and one does not. I have no "Ignore trigger" options checked but SQLCompare is not showing me (that I can see) the DDL triggers d...
Thanks for the responses....so can you tell me how you would propose to get these changes out to my production database(s) and include the migration scripts with them?
Start me with the trunk, and I have a developer who needs to branch the code. What steps should we take, from development, to merging back to the trunk, to deploying to production, to get this to perform correctly and include the migration scripts?
Thanks,
Joe / comments
Thanks for the responses....so can you tell me how you would propose to get these changes out to my production database(s) and include the migration scripts with them?
Start me with the trunk, and ...
thanks for the reply, Brian. Unfortunately, I can't link my production DB to source control, because that would be bad. So doing "get latest" there would not be possible. I have to use SQLCompare.
I tagged 2 releases, release 1 and release 2, in SVN (which is essentially just making a copy of both the Schema folder and the Migration Scripts folder).
I then did a compare of these two, but because the migration script was added somewhere in the intermediate steps between the final releases, SQL Compare doesn't seem to be picking it up. / comments
thanks for the reply, Brian. Unfortunately, I can't link my production DB to source control, because that would be bad. So doing "get latest" there would not be possible. I have to use SQLCompar...
Working with Migration Scripts and Branching in SVN/SSC
We're using an SVN repository.
If I understand the documentaiton correctly, to branch in SSC/SVN, you copy the repository folder and link your DB to the new branch location.
Once I am done with my ...
Hi chris,
This was a brand new repository, created by first committing the changes from the existing database...
The discrepancy is a single row that exists both in the DB as well as in the repository. Here is the full statement:
INSERT INTO [dbo].[FILE_TYPE] ([FILE_TYPEID], [FILETYPE], [DESCRIPTION], [ICONIMAGE], [VIEWABLE], [EXTENSION]) VALUES (N'x-zip-compressed', 'ZIP Document', NULL, 'Zip.gif', NULL, N'.zip')
This is repeated on both sides of the comparison, but one one side it says "Only in Database" and the other side it says "Only in Source Control" / comments
Hi chris,
This was a brand new repository, created by first committing the changes from the existing database...
The discrepancy is a single row that exists both in the DB as well as in the reposit...
Issues with Comparing Static Data in SSC 3.0.5.7 (and prior)
I have a table that seems to be throwing SSC for a loop. No matter how many times I sync it with source control, it still shows up with 1 row to commit when I run a comparison.
Using SQL Data Comp...
Sorry it's taken so long to get back on this one....a slew of other projects considerations are splitting my time way too much [image]
The advanced scenarios weren't terribly advanced, things like changing the size of a column referenced by a foreign key, or adding a "not null" property to a column, both things that would normally cause SQLCompare to drop the column (and/or FKs) and recreate them, which could result in a loss of data. / comments
Sorry it's taken so long to get back on this one....a slew of other projects considerations are splitting my time way too much
The advanced scenarios weren't terribly advanced, things like changin...
Migration Scripts not supported for Mercurial?
After demoing SQL Source Control to my development team to much hoopla, I went about testing more advanced scenarios, including when a migration script would be necessary.
Oops! "Migration scripts...
I am using SQL Source Control 3.
My config file looks just like the one below, thanks. / comments
I am using SQL Source Control 3.
My config file looks just like the one below, thanks.
Linking DB to local repo committed changes
I'm just getting started with this tool, so please bear with me.
I was demonstrating how to link a DB to source control with one of my developers who uses Mercurial for source control. To show him...