How can we help you today? How can we help you today?

Add static text to synchronization

Is there a way to add text from a file to the generated synchronization query?

For tracking purposes, in each of my non-development databases I have a table containing one row with the date of the last synchronization. It would be nice to have a text file with the update command which can be appended to the end of the generated query so I do not have to copy/paste to the end of each query.

Thanks!
--Brian
brian.merz
0

Comments

4 comments

Sort by
  • Chris Auckland
    Thanks for your post.

    Unfortunately there isn't a way to add your own custom SQL to the generated script.

    You might be able to set something up like a batch file to automatically search through the generated .sql file and add the extra line of SQL to the end of the script.
    Chris Auckland
    0
  • brian.merz
    Would it be possible to add this as a feature request for version 9?

    Being able to say include extra sql from a given file in the Synchronization Wizard would be be extremely helpful. Especially if the file path for the extra sql could then be saved in the project.

    Thanks,
    --Brian
    brian.merz
    0
  • David Atkinson
    We are seriously considering something along these lines, so I would say it is a very strong candidate for an upcoming release. Would you need this post-deployment script to be inserted before the end of the transaction or after the end?

    If anyone else has similar requirements, please feel free to post their requirements here.

    Kind regards,

    David Atkinson
    Product Manager
    Red Gate Software
    David Atkinson
    0
  • brian.merz
    For the way I would use the extra SQL (updating that date field), inside the transaction would be preferable.

    Please let me know if I can be of further assistance,
    --Brian
    brian.merz
    0

Add comment

Please sign in to leave a comment.