Synchronizing a script folder

[jeffreydp]

Hi,

I've run into the following issue.

i have a live database source and a script folder target.
both Registered with the relevant Register overload.
I didn't specify the dbInfo parameter as the script folder contained the relevant xml file.

Comparison of both works perfectly.

However, when I try to synchronize with the script folder as the target, I keep getting authorization errors, I've tried with integrated security and with a specific username/password combination but to no avail.

I've checked around in the script folder but I haven't found a clue as to which username/password combination to use.

The same works in the SqlCompare tool, so there must be a way to do it, unfortunately I don't quite see how.

Is this possible with just the toolkit or is this also a tool only option?

[Brian Donahue]

Hi Jeffrey,

As far as I know, synchronizing to files comes down to basic file permissions on the filesystem, so if your user already has read/write access, it could be that some files have the read-only attribute set. This can happen if you copy files from CD or perhaps if you have files checked into or out of source control. You could open a command prompt, change directory to the scripts folder, and do attrib -R /S to clear the read-only attribute.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521

[jeffreydp]

Hi Brian,

My mistake, while I was using the correct Register (...) overload I was using the wrong BuildDifferences (...) overload.

Thanks.

[Brian Donahue]

Hi Jeffrey,

Thanks for getting back to us as to the cause of the problem.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521