Comments
Sort by recent activity
SQL Compare displays the metrics in the 3. Summary stage in the Synchronization wizard - unfortunately this is not exportable. / comments
SQL Compare displays the metrics in the 3. Summary stage in the Synchronization wizard - unfortunately this is not exportable.
I'm sorry but the tab is hard coded - the only way you could change it easily is to use a word processor to find/replace the tabs. / comments
I'm sorry but the tab is hard coded - the only way you could change it easily is to use a word processor to find/replace the tabs.
There is now a patch that has fixed this bug. This is released on the understanding that testing on this patch has been limited, and not been subjected to the usual rigorous testing regime.
Please email support@red-gate.com for assistance. / comments
There is now a patch that has fixed this bug. This is released on the understanding that testing on this patch has been limited, and not been subjected to the usual rigorous testing regime.
Please...
Your best approach would be to write a small application using the SQL Data Compare API, which would allow you to run the compare and return various email and status messages to order.
Have a look at the examples in this link: http://help.red-gate.com/help/SQLCompar ... frame.html / comments
Your best approach would be to write a small application using the SQL Data Compare API, which would allow you to run the compare and return various email and status messages to order.
Have a look ...
Thanks for pointing this out - we have entered this feature for assessment in our database. / comments
Thanks for pointing this out - we have entered this feature for assessment in our database.
In addition you have to edit your EXECUTE command line by adding the @exitcode and @sqlerrorcode as follows:
DECLARE @exitcode int
DECLARE @sqlerrorcode int
EXECUTE master..sqlbackup N'-SQL "BACKUP DATABASE [MyDb] TO DISK = ''\\RemoveServer\RemoteDirectory\MyDb.sqb''
WITH VERIFY, COMPRESSION = 2, INIT, @exitcode OUTPUT, @sqlerrorcode OUTPUT"'
IF (@exitcode >= 500) OR (@sqlerrorcode <> 0)
BEGIN
RAISERROR ('SQL Backup failed with exit code: %d SQL error code: %d', 16, 1, @exitcode, @sqlerrorcode)
END / comments
In addition you have to edit your EXECUTE command line by adding the @exitcode and @sqlerrorcode as follows:
DECLARE @exitcode int
DECLARE @sqlerrorcode int
EXECUTE master..sqlbackup N'-SQL "BACKUP...
It looks like there could be a bug here which is restricting full browsing under SQL Authentication, even though you have the registry setting 'AllowSQLBrowsing' set.
However there is a workaround (other than typing in the full path and file name). To browse for a file, use the Restore Wizard, Step 1 of 4 screen, select 'Browse for backup files to restore', then the 'Add Files' button. On the Browse drop down select 'Network shares', then enter the share and folder in the 'SQL Server' text box. Click 'Add Server to List'.
Now you can at least browse that folder for the file - but you are restricted to that folder only. / comments
It looks like there could be a bug here which is restricting full browsing under SQL Authentication, even though you have the registry setting 'AllowSQLBrowsing' set.
However there is a workaround ...
The error seems to be happening when you run the <synchronize/>
A fix might be to remove roles when doing the compare. When the synchronization is done now, the user will be created automatically if there is a difference in role membership. / comments
The error seems to be happening when you run the <synchronize/>
A fix might be to remove roles when doing the compare. When the synchronization is done now, the user will be created automatically ...
Peter
After writing you the message I looked again at the event text and saw:
• Object Name: MSSQLSERVER
I realized that I had granted query service rights to the wrong service. I changed this to give access on MSSQLSERVER to authenticated users and this seems to have done the trick.
sc sdset MSSQLSERVER [image] (A;;CCDCLCSWRPWPDTLOCRSDRCWDWO;;;BA)
(A;;CCDCLCSWRPWPDTLOCRSDRCWDWO;;;SY)
(A;;CCLCSWLOCRRC;;;IU)(A;;CCDCLCSWRPWPDTLOCRSDRCWDWO;;;AU)
S:(AU;FA;CCDCLCSWRPWPDTLOCRSDRCWDWO;;;WD)
It is probably not necessary to grant all these permissions to authenticated users but at least we have now identified the cause of the failures. / comments
Peter
After writing you the message I looked again at the event text and saw:
• Object Name: MSSQLSERVER
I realized that I had granted query service rights to the wrong service. I changed this...
I'm afraid that there isn't a SQL Doc API that you can use, but it is possible to call a sequence of SQLdoc sessions by using a batch file calling the SQL Doc command line for each project.
You have to set up each project file first using the GUI, setting a target directory for each project, with source databases, passwords etc. The batch file can then call a CHM publisher through a command line to write CHM files using each target directory as a source. Simple root level html code would have to be written to call the 'index.html' from each target directory so that a tree structure would be displayed - however that would only have to be created once
The help file in SQL Doc under 'Using the Command Line' explains the command line syntax. / comments
I'm afraid that there isn't a SQL Doc API that you can use, but it is possible to call a sequence of SQLdoc sessions by using a batch file calling the SQL Doc command line for each project.
You hav...