User defined script filename formatting

tludington

I have searched around and cannot find anything in the settings to allow me to define the format of the script filename. I am very surprised that the format of the script files is MDYYYY-HMM[AP]M.

I would prefer to set the filename to be YYYYMMDD-HHMM (with an option for 24 hour mode).

Also I would like the ability to specift the path of the script folder for each project.

Please let me know if this is something I have overlooked or if perhaps it is something that will be considered for future releases!

Todd

Michelle T

When you say 'script filename', do you mean the file name of the synchronization script that you get when you enable the 'save a copy of the synchronization script' check box in the synchronization wizard, or the filename of the script files that SQL Compare Pro saves when you save a data source to a script folder?

tludington

Synchronization script.

Michelle T

Ah, right. Sorry, you're correct there - we don't have a way of setting these things (the only folder setting is global rather than per-project and the filename is automatic). I've put a feature request in the database for you.

jalbert

I'd suggest using ISO 8601 basic format for the file's name, like "20080208T1837Z".

tludington

That would be acceptable to me however being able to define the format with variables in the Options would be even better. Some people may want to keep the existing format.

Simon C

The SQL Compare 8 beta has an updated synchronization wizard that allows you to specify the filename for the sync script. Please try it out and let us know what you think.

Simon C

mgjernes

Is there any further work on enabling user-configurable options for the default file name formats for the Data Compare scripts and snapshots? Something like the Auto name formatting options for SQL Backup would be great.

I use SQL compare to sync schemas between multiple dev, test and prod systems and I don't usually script all changes at once, so saved command lines may not be an option. It is a great tool, but changing the default snapshot and script name to a more useful format each time is a little irritating. dmYYYY just does not sort properly when searching by file name. The ISO format as suggested makes far more sense.

Thanks for a great set of products!

mgjernes

Thanks for changing the default script naming to the ISO date format in SQL Compare release 8.2.0.16! Much nicer!