Activity overview
Latest activity by Daniel Handley
Hi
This is on the wish list for the next command line tools, but the timetable for development has not yet been finalised.
Once we know how long we have to develop the tools we can work on what feature will be included.
Regards
Dan / comments
Hi
This is on the wish list for the next command line tools, but the timetable for development has not yet been finalised.
Once we know how long we have to develop the tools we can work on what fea...
Hi
We have found that there is a problem when using Windows 2000 and passing a url to the browser.
If you are using Windows 2000 please use the check for updates to see if there is a new version and then download the file from the web site rather than by via the update service.
We are trying to find a workaround and hope to have one soon.
Regards
Dan / comments
Hi
We have found that there is a problem when using Windows 2000 and passing a url to the browser.
If you are using Windows 2000 please use the check for updates to see if there is a new version an...
Hi Scott
Can you send us over the information to support@red-gate.com so we can try and replicate it here?
Regards
Dan / comments
Hi Scott
Can you send us over the information to support@red-gate.com so we can try and replicate it here?
Regards
Dan
Hi
Sorry I misunderstand. I thought you were saying that the backup takes about 3 seconds to complete, but the timestamp on the remote is different because the remote computer clock is not synced with SQL Server?
Please try my suggested method, but i will attempt to replicate you situation here.
Regards
Dan / comments
Hi
Sorry I misunderstand. I thought you were saying that the backup takes about 3 seconds to complete, but the timestamp on the remote is different because the remote computer clock is not synced w...
Hi
I think your right about this being related to backing up over the network. I have not been able to confirm this yet but i would assume that once the last part of the data file is written some verification, not file verification, is occurring and then the file is time stamped.
I would not recommend backing up directly to a network device, unless you have to. My preferred method would be to backup locally and then use the "copyto" option to get the file to the remote drive. Local files can be kept to a minimum by using the "erasefiles" and "erasefiles_atstart" options, and the remote files can be dealt with locally by using robocopy and delete.
This method should also increase the backup time (no network bottle neck), and increase the writing across the network (no backup bottleneck).
Regards
Dan / comments
Hi
I think your right about this being related to backing up over the network. I have not been able to confirm this yet but i would assume that once the last part of the data file is written some v...
When you want to add an encrypted password you will need to add the option
PASSWORD = 'password' / comments
When you want to add an encrypted password you will need to add the option
PASSWORD = 'password'
Hi
Thanks for the suggestion.
We are currently working on a new version of Data Compare and filtering in this way will be included.
Regards
Dan / comments
Hi
Thanks for the suggestion.
We are currently working on a new version of Data Compare and filtering in this way will be included.
Regards
Dan
Hi Dan
The latest release (3.2) fixed this problem for the GUI and command line. However it appears that the store procedure still has this limitation.
We are currently testing a new dll file that has the fix included. Can you email support@red-gate.com and we will send you the file and installation instructions.
Regards
Dan / comments
Hi Dan
The latest release (3.2) fixed this problem for the GUI and command line. However it appears that the store procedure still has this limitation.
We are currently testing a new dll file that ...
Here is some script that will help you.
Run it against each database and note the diffferances.
SELECT "table" = object_name(parent_obj),
"constraint" = name
FROM sysobjects
WHERE xtype IN ('F', 'C')
AND objectproperty(id, 'CnstIsNotTrusted') = 1
ORDER BY 1, 2
Thanks go to Craig who sent this in.
Regards
Dan / comments
Here is some script that will help you.
Run it against each database and note the diffferances.
SELECT "table" = object_name(parent_obj),
"constraint" = name
FROM sysobjects
WHERE xtype IN ('F', 'C...
Hi
As you have found out, in the GUI you can click on the arrow icons to filter changes on missing, additional, and different.
This functionality is currently unavailable in the command line options for SQL Compare.
Regards
Dan / comments
Hi
As you have found out, in the GUI you can click on the arrow icons to filter changes on missing, additional, and different.
This functionality is currently unavailable in the command line option...