Comments
Sort by recent activity
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...
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...
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...
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++
By flickering I mean that it attempts to show the tooltip, but if there is nothing to display it disappears. If you are moving the cursor up and down then you get a ton of this happening.
If I do the same over objects, the tooltips are populated and they remain (as expected)
ssms version:
Microsoft SQL Server Management Studio (expires in 119 days) 10.0.1300.13 ((SQL_PreRelease).080207-2350 )
Microsoft Analysis Services Client Tools 2007.0100.1300.013 ((SQL_PreRelease).080207-2350 )
Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 7.0.5730.11
Microsoft .NET Framework 2.0.50727.1433
Operating System 5.1.2600 / comments
By flickering I mean that it attempts to show the tooltip, but if there is nothing to display it disappears. If you are moving the cursor up and down then you get a ton of this happening.
If I do t...
True.
But I have lots of tables with similar prefixes = lots of scrolling or having to type more of the prefix including the "_" when the prompt shows / comments
True.
But I have lots of tables with similar prefixes = lots of scrolling or having to type more of the prefix including the "_" when the prompt shows