Comments
Sort by recent activity
I don't know about the table sync order but there is an option to disable the DML triggers before making the sync.
(In the case of DRI, the Disable foreign keys should be checked. There is also an option for dropping the primary keys, indexes and unique constraints which is often useful, especially when you are not using the Reseed identity columns option.). / comments
I don't know about the table sync order but there is an option to disable the DML triggers before making the sync.
(In the case of DRI, the Disable foreign keys should be checked. There is also an...
Hi, just a word to say that I've just removed SQL-Backup (and rebooted) but still no luck, SQL-DataCompare 6 keeps crashing. / comments
Hi, just a word to say that I've just removed SQL-Backup (and rebooted) but still no luck, SQL-DataCompare 6 keeps crashing.
Hi, the crash occurs after the display of the first dialog window of the wizard: it display it's dialog window then after 2 or 3 seconds, the crashing window appears. It looks like that SQL-Compare is trying to access a null record; if I enter the CLR Debugger, I have the following information:
An unhandled exception of type 'System.Data.SqlType.SqlNullValueException' occurred in System.Windows.Forms.dll
Additional information: Data is Null. This method or property cannot be called on Null values.
To my knowledge, there is no further usefull information from the Debugger. If I take a look at the error report (the one to be sent to Microsoft); I have the following content:
from the Error Report Contents; first window:
Error Signature:
EventType: clr20r3
P1: redgate.sqldatacompare.ui.exe
P2: 6.0.0.1124
P3: 4703485d
P4: system.windows.forms
P5: 2.0.0.0
P6: 461ef203
P7: 150c
P8: 12f
P9: desIn42ebwmodxjic4snf0cyehcagzn
If I click to view the contents of the error report:
Exception Information
Code: 0x0434f4d Flags: 0x000000007c812a5b
Record: 0x0000000000000000 Address: 0x000000007c812a5b
Module 1
RedGate.SQLDataC
Image Base: 0x11000000 Image Size: 0x00000000
..... / comments
Hi, the crash occurs after the display of the first dialog window of the wizard: it display it's dialog window then after 2 or 3 seconds, the crashing window appears. It looks like that SQL-Compar...
I must add to that that the wizard seems to be working correctly as I can click the buttons and follow the sequence of dialog windows and even perform the final synchronisation step correctly. / comments
I must add to that that the wizard seems to be working correctly as I can click the buttons and follow the sequence of dialog windows and even perform the final synchronisation step correctly.
Hi, the target machine is SP4 (8.00.2039, Desktop Engine, this is the local instance running on my machine (WinXP Pro SP2)) but the source is running SP3, 8.00.760, Enterprise Edition.
Does your solution relates to the version of the source, the target or to either one of them? / comments
Hi, the target machine is SP4 (8.00.2039, Desktop Engine, this is the local instance running on my machine (WinXP Pro SP2)) but the source is running SP3, 8.00.760, Enterprise Edition.
Does your so...
Yes, I had SQL Backup Pro (july 2006) installed on this machine and removed a few weeks ago and SQL Backup 5 installed recently but never used.
If I remember correctly, I've used SQL Backup Pro (the older version) to make some tests but not with this particular database; it was with another database running on the same instance.
I'd also used SQL Log Rescue but again not on this database, it was on another one but still both on the same (target) SQL-Server 2000.
I can try removing SQL Backup 5 (and/or SQL Log Rescue) if you think this might help correcting the problem. / comments
Yes, I had SQL Backup Pro (july 2006) installed on this machine and removed a few weeks ago and SQL Backup 5 installed recently but never used.
If I remember correctly, I've used SQL Backup Pro (th...
Yeah, I second that too.
We should have the option to specify on which conditions the intellisense should popup automatically. / comments
Yeah, I second that too.
We should have the option to specify on which conditions the intellisense should popup automatically.
Just in case you add an option for filtering out system objects, what about a keyboard shortcut that would display only system objects and another one for SCHEMA_INFORMATION only? / comments
Just in case you add an option for filtering out system objects, what about a keyboard shortcut that would display only system objects and another one for SCHEMA_INFORMATION only?
Even better: the system could learn and use the aliases already in use in the database! [image] / comments
Even better: the system could learn and use the aliases already in use in the database!
I, I've just installed SQL Refactor Beta and taking a look at it and I found strange that the split table feature is only for creating a 1-1 relation between the old table and the new table. Most often then not, when I want to split a table is for creating a 1-N relation; so I think it would be a great idea if we could have the option to add (or create) a new identity column in the secondary table to be used as its primary key and use the primary key of the first table as a foreign key in the secondary table.
Of course, this is in some way relation to the normalisation feature that have already be mentionned in this forum.
It would also be great if we could also have the possibility of directly adding new columns to the secondary table at the same occasion.
Finally, as I'm not a religious person about SQL, having the possibility of doing the reverse (joining tables and/or denormalising) would be fun. / comments
I, I've just installed SQL Refactor Beta and taking a look at it and I found strange that the split table feature is only for creating a 1-1 relation between the old table and the new table. Most ...