Activity overview
Latest activity by jhoerr
Ah, ok -- and that's the piece that can be supplied via the /scriptsfolderxml argument, correct? This is making sense now. We follow a pretty traditional trunk/feature branch pattern and release from tags, so being able to dynamically provide that repository URL is helpful. / comments
Ah, ok -- and that's the piece that can be supplied via the /scriptsfolderxml argument, correct? This is making sense now. We follow a pretty traditional trunk/feature branch pattern and release ...
David Atkinson wrote:
If you generate a script where the source database is a source controlled database...
Ok, I think this piece is key. Do you draw a distinction here between a scripts folder that was generated from a source controlled database, and pointing to the URL of the repository itself?
I see the extended property in my local source-controlled DB -- thanks for that tip. What does SQL Compare do with that 'SQLSourceControl Scripts Location' value? / comments
David Atkinson wrote:
If you generate a script where the source database is a source controlled database...
Ok, I think this piece is key. Do you draw a distinction here between a scripts fol...
David - I've performed many DB migrations with Sql Compare, yet the DB 'extended property' has never been set and that's apparently necessary for migrations scripts to work properly. How does this get initially set?
Also, the solutions suggested here for enabling command-line support for the migration scripts are very clever but seem to require a considerable amount of hoop-jumping. Are these the best way to approach the problem, or do you know of any tutorials or blog posts that demonstrate how this kind of thing can/should be done? / comments
David - I've performed many DB migrations with Sql Compare, yet the DB 'extended property' has never been set and that's apparently necessary for migrations scripts to work properly. How does thi...
matt_hosking wrote:
...unless you use source control as the source for the database, migration scripts are ignored...
Can someone else confirm this? And if it's true, can someone explain why it's necessary? It's not at all clear to me why this would be the case, considering that everything in the scripts folder has already come from source control.
freecell1 wrote:
The target db shows svn revision 5018 in its extended properties
What is the exact form of this extended property? I think I perhaps need to prepopulate it on the production database so that I can start performing migrations.
Thanks! / comments
matt_hosking wrote:
...unless you use source control as the source for the database, migration scripts are ignored...
Can someone else confirm this? And if it's true, can someone explain why ...
Thanks, chrisk5 -- I enabled Verbose logging as per the KB article but it doesn't appear that the PRINT statements get logged. / comments
Thanks, chrisk5 -- I enabled Verbose logging as per the KB article but it doesn't appear that the PRINT statements get logged.
Hi David -- thanks for responding, and sorry for the late reply. I didn't have my profile configured to notify me of responses to my question. [image]
You're right that it would be nice to know which command line parameters have been selected...
I think there's been a misunderstanding -- I'm not interested in logging which command line parameters have been selected. I'd like the logs to include the step-wise 'PRINT' statement output of the sync script so that when the script throws an error, I can quickly determine at what point in the execution the error occurred. If, as chrisk5 suggests, this can be enabled through the UI, then it seems that it should be configurable via the command line. / comments
Hi David -- thanks for responding, and sorry for the late reply. I didn't have my profile configured to notify me of responses to my question.
You're right that it would be nice to know which co...
I've started the SQL Compare UI, but I don't see anything pertaining to logging via Tools -> Application Options or File -> New Project. Should I be looking elsewhere? / comments
I've started the SQL Compare UI, but I don't see anything pertaining to logging via Tools -> Application Options or File -> New Project. Should I be looking elsewhere?
Verbose logging via command line
Hi,
I see that the sync script produced by the /ScriptFile switch includes a PRINT statement for each synchronization step. I'd like to know if its possible to have these statements included in th...