Red Gate forums :: View topic - Synchronizing a script folder
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Toolkit Previous Versions
SQL Toolkit Previous Versions forum

Synchronizing a script folder

Search in SQL Toolkit Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
jeffreydp



Joined: 11 Mar 2008
Posts: 5

PostPosted: Thu Mar 20, 2008 11:59 am    Post subject: Synchronizing a script folder Reply with quote

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?
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6582

PostPosted: Fri Mar 21, 2008 8:21 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
jeffreydp



Joined: 11 Mar 2008
Posts: 5

PostPosted: Tue Mar 25, 2008 9:53 am    Post subject: Reply with quote

Hi Brian,

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

Thanks.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6582

PostPosted: Tue Mar 25, 2008 10:31 am    Post subject: Reply with quote

Hi Jeffrey,

Thanks for getting back to us as to the cause of the problem.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group