Comments
4 comments
-
Glad you like the new features, we did spend a lot of time on the forums and reading survey feedback deciding what went into v6.
1. Nope, it is still there, it was a check-box but has been changed to a button. It is on the left of the AAAA font size control.
2. Yeah, looks like this feature is becoming a popular request, let us get SC6 out and then we may look into this.
3. Directories - yep that is coming for the final release and file extensions is still something that we are thinking about.
4. Well the final release will have the command line too. So you can always write a command line batch file and use a scheduled task to set it off.
Finally regarding SCC integration, of course it is a natural extension to being able to work with scripts so we will be doing this, I just cannot say when.
Hope this helps,
Jonathan -
With regard to number 4, would it be possible after the object selections are made and prior to performing the synchronization that you have an option to automatically create and save the batch script that would be saved? This would ensure that nothing is "fat fingered" incorrectly during the typing of the script.
-
We probably won't do this for the final release, but it is certainly an idea for the future.
Jonathan -
in terms of integrating with source control, even a crude ability to "run commandline command for each object's script file" as it is synchronised, would help alot. Then, any source contrl system with a commandline interface could be called, to check the file out, or we could write our own script or program to do it... just tell us the filename, and we'll do the rest! only running it on the objects that are different and being synchronised would ensure a minimum of calls to the SCC system, only checking out files that are actually going to change
Even batch file to be simply run before (to check all objects out), and after (to revert unchanged files) would be better than nothing
In terms of incorporating it into settings, you could specify the commands at a project level, or perhaps at the application level, and each project just has a flag as to whether SCC commands should be run or not.
Add comment
Please sign in to leave a comment.
Here are some initial requests/observations:
1. In Version 5, the compare results for tables grouped the different portions of the table into collapsible regions. The columns were in their own collapsible region, the triggers were together, the indexes were together, and so were the constraints. If there were differences in each of these regions, there was an icon that had an equal sign with a slash through it. This collapsible groouping seems to have disappeared inside of Version 6.
2. It would be nice if we can have sub-object level promotion. By this I mean the ability to synchronize individual portions of a table. Suppose we compare two tables, and there are column differences and index differences. I would like the ability to change the columns without changing the indexes, or vice versa. In SQLDataCompare, you give us the ability to select individual rows with a checkbox. I'm not asking for line by line insertion with regard to schema, but if you can do it at a sub-object level (all columns, all indexes, all constraints) that would be helpful.
3. Others have commented on having the ability to specify directory location and file extensions for specific object types when scripting objects. I won't elaborate on this since others have, but would just like to reiterate that this would be nice functionality to have.
4. The ability to create synchronization schedules would be a nifty little addition. We have some training databases that often get out of synch because we forget to migrate the schema changes to them. If we can predefine the settings (Ignore User Permissions, etc) and set them to be synchronized from our production schema on a weekly basis, that would be tremendously helpful.