Comments
Sort by recent activity
I have a database.
I have an empty folder.
I compare the database to source control i.e. the empty folder
All the scripts are created and work correctly.
i.e. the database's objects are correctly dropped
However
If I recreate the database using scripts, then the DROP script no longer works due to unique constraints that have been scripted for dropping.
I have tried various 'ignore' checkboxes but still the unique constraints are scripted for deletion
Am using SQL Compare 8.5.12.20 against sql server 2005 / comments
I have a database.
I have an empty folder.
I compare the database to source control i.e. the empty folder
All the scripts are created and work correctly.
i.e. the database's objects are correctly d...
e.g.
SELECT ...
FROM tableA A
INNER JOIN tableB B on A.ID = B.ID
LEFT OUTER JOIN tableC C ON C.val = B.val
would show a simple diagram showing 3 tables (no columns) with lines linking A to B, B to C
perhaps also showing the aliases of the tables and the IDs with which they're linked
[I guess you could always extend this so clicking on any table highlights output columns within the text] / comments
e.g.
SELECT ...
FROM tableA A
INNER JOIN tableB B on A.ID = B.ID
LEFT OUTER JOIN tableC C ON C.val = B.val
would show a simple diagram showing 3 tables (no columns) with lines linking A to B, B to ...
It's just running the "sqlcompare.exe -blah -blah -blah" tool
It runs ok, but one of the scripts is causing it to fail and I don't know which one.
Using the /verbose switch does not help either / comments
It's just running the "sqlcompare.exe -blah -blah -blah" tool
It runs ok, but one of the scripts is causing it to fail and I don't know which one.
Using the /verbose switch does not help either
The database I mentioned will run standalone.
The parts we add are not depended on by the standalone part.
e.g. we might have views, procs, functions that use all this
Perhaps think of it like a wrapper.
There are releases from the 3rd party company (who someone else looks after) which are frequently applied to the db - we don't see this until it is in production.
I want to take the latest version of the db (including any 3rd party updates) and add the latest verison of all of our 'extensions' currently under development'
Everything appears to work, get the db, restore, get our code from source control, populate the tags.
But when I do a sync between the newly copied version of prod (now in dev) and the scripts we have (ordered in folders), I'm not getting a combination of "prod+scripts" instead I just get "scripts". It is dropping everything that is not in the "scripts" folders.
I don't understand why this should be as when using the GUI you can select from the 4 groups:
Identical in A and B
Only in A
Only in B
Different in A and B
So why is using "/sync" causing it to drop stuff? / comments
The database I mentioned will run standalone.
The parts we add are not depended on by the standalone part.
e.g. we might have views, procs, functions that use all this
Perhaps think of it like a wr...
This sounds like it is more of a 'data compare' issue rather than a straight SQL Compare (the solution you have linked to)
This is our set up:
- 3rd party db, regular updates received
- in house extensions (no 'combined' extensions e.g. we add a col to their table)
What we are trying to achieve
- Get prod backup
- Put into dev, apply our extensions
However, when running with the 'sync' flag, instead of having prod+extension, it drops all the prod stuff and I'm just left with the extensions. / comments
This sounds like it is more of a 'data compare' issue rather than a straight SQL Compare (the solution you have linked to)
This is our set up:
- 3rd party db, regular updates received
- in house ex...
I'm using an earlier version of sql compare (I do have 7 installed but for the purposes of our automated build, we are currently using 6)
If I run the command line and it encounters a table which is present on the db and tries to compare it to a script in a folder (which I know does not exist) it errors.
I would expect it to continue, just noting that the object was missing.
Instead it errors with 'invalid object'
I just wanted to know if this was fixed in v7 / comments
I'm using an earlier version of sql compare (I do have 7 installed but for the purposes of our automated build, we are currently using 6)
If I run the command line and it encounters a table which i...
I can't seem to get /ignoremissing to work at all via the command line.
I also can't seem to find it documented anywhere.
The syntax
/options:IgnoreMissing
does not work at all
Help! / comments
I can't seem to get /ignoremissing to work at all via the command line.
I also can't seem to find it documented anywhere.
The syntax
/options:IgnoreMissing
does not work at all
Help!
Actually I'm comparing a folder structure with a db (not a backup)
It would seem like a fundamental product flaw that it can't cope with the comparison object not being there.
Regardless, is this fixed in v7? / comments
Actually I'm comparing a folder structure with a db (not a backup)
It would seem like a fundamental product flaw that it can't cope with the comparison object not being there.
Regardless, is this f...
Table functions are not supported on linked servers, so I have been informed / comments
Table functions are not supported on linked servers, so I have been informed
I usually line them up somewhere around the 80th column.
This is also useful when using the little known ALT + <select text> to get a box select for copying to excel/notepad++ / comments
I usually line them up somewhere around the 80th column.
This is also useful when using the little known ALT + <select text> to get a box select for copying to excel/notepad++