Activity overview
Latest activity by Andras B
AaronBertrand wrote:
Thanks Andras,
I was able to find the option shortly after posting. What screwed me up was that I had enabled filters to exclude these entities (among others) since first configuring SQL Compare. So when I turned partition scheme and function back on, I didn't expect to have to go turn them on somewhere else as well.
I think a handy usability item would be to disable turning filters on/off for objects that can't be displayed no matter what due to underlying settings.
Hi Aaron,
it is a very good point you made in this post, and we will look at this usability issue for future releases.
Many thanks,
Andras / comments
AaronBertrand wrote:
Thanks Andras,
I was able to find the option shortly after posting. What screwed me up was that I had enabled filters to exclude these entities (among others) since first co...
AaronBertrand wrote:
I am not able to get SQL Compare 8 to see partition schemes / functions.
I have one server where a database is identical except it has two partition schemes and functions. SELECT * FROM sys.partition_schemes yields results, yet an *unfiltered* compare does not show partition functions or partition schemes in the output (I scrolled meticulously through the "identical objects" panel but they were not there either, which I expected).
Is there anything special I have to do to get partition schemes and functions recognized by SQL Compare? The workaround is easy, I can just re-create the CREATE statements manually, but it would be great if the tool could do the manual work for me.
Dear Aaron,
by default SQL Compare hides filegroup and partitioning information, and this includes partition schemes and partition functions. If you would like this information to be compared and shown, you need to change the comparison option "Ignore Filegroups, partition schemes and partition functions". You can access this option by going to Edit project->Options tab. By default this option is set.
Kind regards,
Andras / comments
AaronBertrand wrote:
I am not able to get SQL Compare 8 to see partition schemes / functions.
I have one server where a database is identical except it has two partition schemes and functions. S...
brian.merz wrote:
I am running under 32 bit XP Pro with Service Pack 3. I have both .NET 1.1.4322 and 2.0.50727 installed.
I can reliably reproduce this with the following:
Open the Synchronization Wizard using the Management Studio 2005 radio selection Application Options.
Click Next.
Press and release ALT. The shortcut line should appear under B on the Back button.
Without any further use of ALT, now press B. At this point nothing happens for me. If I press B again then the wizard moves back one step.
Hope this helps!
Let me know if I can provide further assistance,
--Brian
Hi Brian,
many thanks for getting back to us. We have managed to reproduce this interesting behaviour. However, I believe the problem is not in the way we create our UI components, but this is the standard behaviour of .Net applications (or a bug in .Net 2).
Regards,
Andras / comments
brian.merz wrote:
I am running under 32 bit XP Pro with Service Pack 3. I have both .NET 1.1.4322 and 2.0.50727 installed.
I can reliably reproduce this with the following:
Open the Synchronizati...
softlion wrote:
Hi,
I receive an error when I switch to the mapping tab or when I synchronize 2 databases db1 (2008 express local) and db2 (2005 sp3 / ssh forwarded to localhost).
When switching to this tab there is "preparing mapping" operations for db1 which goes ok, then it tries the same on db2 and failed with a yellow triangle and a small message "Erreur irrécupérable de connexion interne".
When clicking "Compare" the process always freezes on the same step (Registering databases/db2-Reading object text) and I have no other choice but kill the process in task manager.
It is bizarre because it works nicely between db1 and db3 (also 2005 sp2 / ssh forwarded). I installed SP3-CU2 on db2 without any effect.
It feels like a connection issue. Are you able to connect to db2 from Management Studio?
Regards,
Andras / comments
softlion wrote:
Hi,
I receive an error when I switch to the mapping tab or when I synchronize 2 databases db1 (2008 express local) and db2 (2005 sp3 / ssh forwarded to localhost).
When switching ...
brian.merz wrote:
By accident I discovered the keyboard shortcuts placed in the various dialog boxes. Specifically, I was looking through the generated synchronization file and pressed E which launched Management Studio.
One thing I've noticed is that if I press ALT and then the underscored letter for the shortcut I want, I have to press the letter twice to activate the shortcut. ALT + <letter> activates the shortcut immediately.
Is it possible to adjust ALT and then letter to activate on the first letter press to be consistent with other Windows programs?
Thanks!
--Brian
Hi Brian,
we were struggling to reproduce the problem you are reporting. I'm wondering if you could give more details (operating system, 64/32 bit, .Net framework, etc). We looked at various platforms, and for us the shortcut keys behave the same way as shortcut keys in other Windows application.
Regards,
Andras / comments
brian.merz wrote:
By accident I discovered the keyboard shortcuts placed in the various dialog boxes. Specifically, I was looking through the generated synchronization file and pressed E which la...
Thanks for getting back to me. The problem is that there is a bug in SQL Server 2000 concerning multi statement functions, and SET ANSI_NULLS for such functions is ignored by SQL Server. You can try this by creating such a function, and querying the system tables on 2000
select objectpropertyex(object_id('theNameOfMyMultiStatementTableFunction'), 'ExecIsAnsiNullsOn' )
This will be returning nulls [image]
There is an option for ignoring Quoted identifiers and ANSI_NULL statements in SQL Compare as a temporary workaround.
Regards,
Andras / comments
Thanks for getting back to me. The problem is that there is a bug in SQL Server 2000 concerning multi statement functions, and SET ANSI_NULLS for such functions is ignored by SQL Server. You can tr...
rbennet8 wrote:
Is it possible to add an option to compare the case sensitive differences? I see the collation option, but not one for case sensitive.
Go to the Project options (or Edit project->Options) and select the Behaviour->Treat items as case sensitive setting.
Regards,
Andras / comments
rbennet8 wrote:
Is it possible to add an option to compare the case sensitive differences? I see the collation option, but not one for case sensitive.
Go to the Project options (or Edit project...
Thank you for he detailed feedback. While we are looking into these items, here is a partial answer to some of you questions/concerns.
The highlight color is a bug, and it will be fixed for the final release.
Old filter rules should be accessible. I'm wondering if you have cleaned up the registry though, as that would invalidate some of the filters.
False positives. Are you referring to the differences in the SQL script panel or the top level object grid. The grid is identifying semantic differences only, while in the bottom panel we show the creation scrips for the selected object, and differences here are textual (not semantic). For example the extended properties for user/schema for the same schema object are not semantic differences, but the syntax for the sp_addextendedproperty will show a difference.
The SQL button. We have hidden this on purpose, but it is there, you need use the context menu on the differences panel.
The Line differences shows an individual line in the differences panel, but instead of showing it side by side, it puts the two lines on top of each other. When a selected line has no differences, its contents do not help. However, when a line with differences is selected (you can click on such a line, or use the Previous Next buttons to jump to such a line), it will make it easier to find in-line differences, such as an extra NULL, or differences in only a few characters.
Thanks for your feedback,
Regards,
Andras / comments
Thank you for he detailed feedback. While we are looking into these items, here is a partial answer to some of you questions/concerns.
The highlight color is a bug, and it will be fixed for the fin...
PDinCA wrote:
Both instances (one is SS2000, the other SS2008 RTM) are set for connections: ANSI NULL DEFAULT ON. Both Databases have ANSI NULL ON. ALTER UDF Script has explicit SET ANSI_NULLS ON and just to be paranoid I ran the script on both (test) databases and refreshed SQL Compare RC1.
WHY does it persist in showing me that the only "difference" between the 2 is that is has the first 2 lines in the SS2000 script as:
SET ANSI_NULLS OFF
GO
Huh?
What am I missing?
This is the only difference for 20 of my UDFs, but I have 200 others that are identical and they have the same SET ANSI_NULLS ON in their scripts.
Maybe this turns out to not be a SQL Compare issue but I'm at a loss as to know where else to look...
Thanks for your "indulgence".
Do you have SQL Compare 6 installed? Does it behave the same way? Also, when you script the object from Management Studio, does it display the correct ANSI_NULLS setting? Could you also send me in a private message oen of these functions please? Or whether it is a multistatement, inline, or scalar function.
Regards,
Andras / comments
PDinCA wrote:
Both instances (one is SS2000, the other SS2008 RTM) are set for connections: ANSI NULL DEFAULT ON. Both Databases have ANSI NULL ON. ALTER UDF Script has explicit SET ANSI_NULLS ...
Sequel2005 wrote:
I'm trying to compare two similar databases but they have different table owners. When I map the two table owners together it acts like it doesn't work, when I get the results it shows that all of my objects are different and don't exist in the other database, so something didn't take effect with the owner mapping. Is there something I'm missing? It worked in 6.2. I would appreciate any assistance. Thanks.
It is interesting, we could not yet find a reason to explain this, and we could not reproduce this. Could you send me as much of the following to me as possible (Andras.Belokosztolszki at red-gate dot com)
* The log file (in the system many (right click on the blue envelope in the top left corner of the application Minumum Log Level->Verbose), then do the comparison, then in the system menu Locate log files, and send me the log (it is human readable, you can check what is inside)
* the versions (2000, 2005, etc) compatibility modes, database collation of your databases
* if you use any non-default SQL Compare options
* If possible the two sql compare snapshots (File -> Create Snapshot) for your two databases (this will create a snapshot of the schema only)
* possibly a screenshot of your mappings and the main screen.
We will try to get back concerning this as soon as possible.
Regards,
Andras / comments
Sequel2005 wrote:
I'm trying to compare two similar databases but they have different table owners. When I map the two table owners together it acts like it doesn't work, when I get the results ...