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

Script Generation, Static Data not Implemented?

1) Create Schema Scripts option is hard to get to if you just want to create the scripts. It would be nice to be able to create a script folder from the menu in addition to the Project dialog.

2) I see the option for specifying the Static Data folder in Script Creation Options. I scripted and no data folder was created. There appears to be no UI to identify tables that should be treated as static data. Either this is not implemented or is not intuitive (there is no mention of the Static Data functionality anywhere I can find, other than the Edit Script Creation Options dialog). Or perhaps I'm just confused.

Version 8.0.0.556
ml42
0

Comments

2 comments

Sort by
  • David Atkinson
    Thanks for the feedback.

    1) This is a fair point. Could you describe a situation where you would want to just create the scripts? I suppose the option could be added to the File menu like it is in SQL Compare.

    2) The selections in Tables & Views are used to determine which tables should be treated as static data. Is there somewhere else this should be expressed/indicated?

    Thanks,

    David Atkinson
    Product Manager
    Red Gate Software
    David Atkinson
    0
  • RogerHart
    A newly created scripts folder doesn't contain data scripts. To update the target scripts folder with data from the source, perform the comparison, select the rows you want to include, and then synchronize.

    Data scripts are not currently created from the Project Configuration dialog box as, for many databases, this would take a long time, and be insufficiently specific. Not least because we can't really know in advance which tables contain static data.

    Instead, comparing and synchronizing an "empty" scripts folder allows for finer grained control over what data is stored in the scripts folder. You can filter the comparison using the Tables & Views tab, and by applying a WHERE clause, and then use the Results and Row Differences panes to select data at a row level.

    Of course, it's possible we could be doing a better job of articulating that.
    RogerHart
    0

Add comment

Please sign in to leave a comment.