RELEASE Notes: This section describes Changes and Enhancements made to ApexSQL Script Best viewed with 'WORD WRAP' unchecked -------------------------------------------------------------------------------------------------- RELEASE 2005.11.0200 DATE: May 1, 2008 DESCRIPTION: Medium Fix Release -------------------------------------------------------------------------------------------------- Enhancements: - New and Improved dependency parsing engine - Ability to script out database extended properties - Support for SQL Server 2000 Full Text Catalogs - Warning displayed when user is not a member of 'db_owner' Changes: - Default location for ApexSQL Script user files changed to \My Documents\ApexSQL\ApexSQLScript Fixes: - "Out of memory" exception when executing packages with large scripts - Incorrect ordering of DELETE statements in data scripts - Incorrect insert statements generated for sql variant fields - Incorrect update statements generated for image fields - Field selection disappears when data grid is refreshed - Duplicate file name extension for package names that are set using CLI - Incorrect regular expression processing for /inc and /exc switches in CLI - Wrong settings for default database name when generating scripts for several databases - CLI switches /inc and /exc incorrectly define project options - Wrong filtering for some objects in main grid -------------------------------------------------------------------------------------------------- RELEASE 2005.10.0196 DATE: September 20, 2007 DESCRIPTION: Medium Fix Release -------------------------------------------------------------------------------------------------- Changes: - "Check all" column it is replaced with column filter in project wizard - Wild cards are changed to regular expressions in CLI - Removed server pick list from main toolbar as it is redundant - Loading of the objects metadata in a background mode to improve initial loading performance - Added a button to explorer's toolbar for "load selected database" - Improved data scripting performance Fixes: - Problem with management of owner mapping for textual objects. Incorrect change and suppression owners - Bug with a filtration of SQL Server 2005 object types in a project wizard - Bug with change of the size of a project wizard on 120 dpi fonts - Problem with loading schemas for mapping in scripting wizard. Empty schemas grid in some cases - Bug with ordering Drop Statements Script of role membership - Bug with ordering services and routes in a structure script - Bug with ordering binding rules in a structure script - Some problems with overwrite project options in CLI - Problem with definition of dependent roles for other objects - Bug with ordering user types in a structure script. Incorrect definition of the user data types in relation to other objects - Bug with management of owner mapping for extended properties. Empty owner level for users extended properties - Bug with ordering DELETE statements in data mode - Bug with ordering INSERT statements in data mode - Bug with presence of an empty column in main grid dialogs -------------------------------------------------------------------------------------------------- RELEASE 2005.09.0195 DATE: July 10, 2007 DESCRIPTION: Medium Fix Release -------------------------------------------------------------------------------------------------- Changes: - Package project converted on .Net 2.0 - Script login creation on MS SQL 2005 - Option "Explicitly Parse Database for Proper Script Creation Order" default value on FALSE - Wild cards are changed on regular expressions in filters Fixes: - Problem with out of memory on generate packages - Bug with collection modified on reload large databases - Bug with script headers/footers to individual files - Some problems with ordering objects - Problem with defined depend objects - Problem with CPU resources occupying - Problem with owner mappings for some object types - Some problems with switches combine in CLI - Bug with generate large VB scripts - Bug with load app roles - Bug with script extended property on table primary key - Bug with script textual objects -------------------------------------------------------------------------------------------------- RELEASE 2005.08.0193 DATE: May 15, 2007 DESCRIPTION: Medium Feature Release -------------------------------------------------------------------------------------------------- Enhancements: - Added server explorer to main window - Ability to customize script headers - Ability to generate custom script footers - Ability to version generated scripts - Ability to treat Project Wizard's selection as exclude via Project Wizard's "Treat Object Selections as Exclude" option - Ability to treat main window's selection as exclude via Script Wizard's "Treat Object Selections as Exclude" option - Added "Script CREATE DATABASE" project level option - Added "Script Filegroups" project level option - Added "Explicitly Parse Database for Proper Script Creation Order" project level option - Added "Script Logins with Users" project level option - Added object filter for each object type to Project Wizard - Ability to customize database creation options - Added "Automatically Select Data table if Structure table has been selected" application level option - Ability to generate custom headers and footers for each object being scripted - Ability to manage grid columns - Added server picklist to main window - Ability to manage file extensions and custom type names in Options form - Ability to display grid's group by box - Support for CLR data types in data mode - Ability to script into Visual SourceSafe - Ability to script into SCC compliant systems - Ability to script objects from several databases at once - Multi column grouping for grids - Multi column sorting for grids - Implemented Script and Object Level Tags that can be used for script generation - Ability to include custom Pre- and Postprocessing scripts in generated scripts - Ability to specify project file in command line for GUI executable (like "ApexSQLScript.exe MyProject.axsc") - Added the following new CLI switches: Specific /i [ /includes ] : selection profile path (all objects if omitted) /ft:arg [ /filename_template ] : filename template /inc:arg [ /include ] : include specific objects in processing, objects can be specified via regular expressions TypeConstant:Expr ... TypeConstant:Expr ... /exc:arg [ /exclude ] : exclude specific objects from processing, objects can be specified via regular expressions TypeConstant:ObjectWildcard1:ObjectWildcar d2... TypeConstant:ObjectWildcard1:ObjectWildcar d2... /te [ /treat_list_as_exclude ] : treat selection profile/selection in a project file as exclude list Owner Options /owm [ /owner_manage ] : manage owners /owt:arg [ /owner_type ] : owner mapping type ("include" if omitted) exclude include change Arguments can not be combined. /owmp:arg [ /owner_map ] : owner map (example: "old;new dbo;test") Main Options /nth [ /no_transaction_handling ] : exclude transaction handling /nep [ /no_explicity_parse ] : no explicitly parse database for proper script creation order Script Processing /pre:arg [ /pre_script ] : preprocessing script file /pst:arg [ /post_script ] : postprocessing script file Structure General Options /sid [ /include_dependent ] : include dependent database objects /scdb [ /scr_create_db ] : script CREATE DATABASE /scf [ /scr_filegroups ] : script filegroups /scl [ /scr_logins ] : script logins with users /scn [ /no_scr_names ] : no script names /scc [ /scr_collations ] : script collation (table only) /nsca [ /no_scr_ansi_options ] : no script ANSI options /sct [ /scr_triggers ] : script triggers with parent table or view /scp [ /scr_permissions ] : script permissions /scd [ /scr_drops ] : script drops /nsce [ /no_scr_ex_properties ] : no script extended properties /nscu [ /no_scr_use_db ] : no script USE for database Create Database Options /dbd:arg [ /db_dir ] : database directory /dbld:arg [ /db_logdir ] : database log directory /dbc:arg [ /db_collation ] : database collation /dbrv:arg [ /db_recovery ] : database recovery mode ("simple" if omitted) simple full bulklogged Arguments can not be combined. /dbs:arg [ /db_size ] : database size (example: '1024 KB' Data General Options /ndio [ /no_data_identity_on ] : no set identity insert on /ddr [ /data_distinct ] : script distinct rows /ndd [ /no_data_delete ] : no add DELETE statements /drs:arg [ /data_rows ] : rows to script ("insert_all" if omitted) insert_all insert_update insert_new Arguments can not be combined. /dbr:arg [ /data_batch_rows ] : batch every N rows (no batches if omitted) /ndad [ /no_data_apply_date ] : no apply date format /ddf:arg [ /data_date_format ] : date format ("YYYYMMDD HH:NN:SS" if omitted) /ndtt [ /no_data_trim ] : no trim trailing spaces /ddac [ /data_disable_constraints ] : disable all triggers and constraints prior to loading data Script Format Options /nfc [ /no_format_comments ] : exclude comments /fof [ /format_obj_footer ] : include object footer /foh [ /format_obj_header ] : include object header /nfp [ /no_format_prints ] : exclude PRINT statements /fsf [ /format_scr_footer ] : include script footer /nfsh [ /no_format_scr_header ] : exclude script header /objf:arg [ /obj_footer ] : object footer template file /objh:arg [ /obj_header ] : object header template file /scrf:arg [ /script_footer ] : script footer template file /scrh:arg [ /script_header ] : script header template file Script Version Options /vmj:arg [ /version_major ] : major version number /vmr:arg [ /version_minor ] : minor version number /vbd:arg [ /version_build ] : build number Package Options /pkc [ /package_compression ] : use compression /pke:arg [ /package_error ] : package error handling ("ask" if omitted) abort ignore ask Arguments can not be combined. /pkaa:arg [ /package_author ] : package author /pkar:arg [ /package_copyright ] : package copyright /pkal:arg [ /package_legal ] : package legal /pkac:arg [ /package_comments ] : package comments Visual Source Safe Options /vss [ /source_safe ] : check in script to visual source safe /vssc:arg [ /vss_config ] : visual source safe config file path /vssu:arg [ /vss_user ] : visual source safe login (used with /vss_password option) /vssp:arg [ /vss_password ] : visual source safe password (used with /vss_user option) /vssj:arg [ /vss_project ] : visual source safe project path SourceGear Vault Options /vlt [ /vault ] : check in script to SorceGear Vault /vlts:arg [ /vault_server ] : SorceGear Vault server URL /vltr:arg [ /vault_repository ] : SorceGear Vault repository /vltu:arg [ /vault_user ] : SorceGear Vault login (used with /vault_password option) /vltp:arg [ /vault_password ] : SorceGear Vault password (used with /vault_user option) /vltj:arg [ /vault_project ] : SorceGear Vault project path Script Tags /sta:arg [ /tag_author ] : author tag /stc:arg [ /tag_company ] : company tag /stl:arg [ /tag_legal ] : legal tag /stw:arg [ /tag_workfile ] : workfile tag /str:arg [ /tag_revision ] : revision tag /stcl:arg [ /tag_log ] : change log tag /stc1:arg [ /tag_custom1 ] : custom1 tag /stc2:arg [ /tag_custom2 ] : custom2 tag /stc3:arg [ /tag_custom3 ] : custom3 tag Additional options: /cw:arg [ /console_width ] : specifies the width of console output /out:arg [ /out_to ] : redirects console output to specified file /af [ /argfile ] : argfile path Example of argfile: pubs home\sql2005 Changes: - Changed CLI switch name /ft [ /filter ] to /o [/object_types] and used bitwise set for object types - Changed CLI switch name /i [ /individual ] to /in [/individual] - CLI switch /database - several databases can be specified - Outlook bar made dockable - Parser is used no more when only data objects are being scripted Fixes: - Problem with doubling switches in CLI - Problem with scripting several databases in CLI - Bug with saving projects - Bug with scripting data in CLI (apply filter) - Problem with script formatting - Problem with editing project databases in wizard - Problem with ordering fields of table in data mode - Problem with hide/view filter row in grids - Bug with scripting each object to an individual file in CLI - Bug with connecting to inaccessible MSSQL instance - Bug with changing options in package - Problem with package template name - Problem with suppress owners/schemas for stored procedures -------------------------------------------------------------------------------------------------- RELEASE 2005.03.0178 DATE: 05/30/2006 DESCRIPTION: Minor Feature / Medium Fix Release -------------------------------------------------------------------------------------------------- Enhancements: - Added management encoding for output files - Added checking exists object before DROP - Split package on two modules for GUI(package_name.exe) and console(package_name.com) - Added new switch in console mode: /e [ /encoding ] : output file encoding - Added new page in scripting wizard (package options) - Added template options for package name and script name - Added data object filter toolbar Fixes: - Problem with structure object filter toolbar - Bugs with switch processing in package console - Bug with define database version - Bug with redirection large script in external editors - Bug with refresh database picklist on toolbar - Bug with processing changes in scripting wizard -------------------------------------------------------------------------------------------------- RELEASE 2005.02.0177 DATE: 05/16/2006 DESCRIPTION: Minor Feature / Medium Fix Release -------------------------------------------------------------------------------------------------- Enhancements: - Added simple Intellisense in WHERE clause editor - Added new switch in console mode: /i [ /individual ] : script each object to an individual file - Added new switch in console mode: /cd [ /create_dir ] : create directory for each object type - Added new switch in console mode: /fl [ /folder ] : output folder for script each object to an individual file - Added icon for row filter in grid - Added database picklist to toolbar - Extended function for edit max value in data mode - Change package "About dialog" (resize depending on options) Fixes: - Bug with script fulltext indexes - Bug with Reset button in scripting wizard - Bug with hide/show outlook bar - Bug with different languages in VB script - Bug with exclude owners in data script - Bug with qualify objects name - Bug with depend user or schema (not included in script then set option - include dependent objects) - Bug with script each object to an individual file - Issues with saving project from project wizard - Issues with scripting parent table or view with trigger - Application throws exception in field grid when data grid is collapsed -------------------------------------------------------------------------------------------------- RELEASE 2005.01.0176 DATE: 04/25/2006 DESCRIPTION: Major Feature Release -------------------------------------------------------------------------------------------------- Enhancements: - Project support - Project wizards for data/structure mode - List of recent projects - Support Owners Mapping for scripting - Extended properties support - Speed-up scripting structure - C# project output support - .NET executable output support - Support for MS SQL Server 2005 objects (Schemas, Synonyms, Assemblys, Fultext Catalogs, XmlSchemaCollection, PartitionFunction, PartitionSchema, DDLTrigger, Contract, Credentials, Event Notifications, Message Types, Queues, Routes, Services, Remote Service Binding) - Added new switch in console mode: /ot [ /output_type ] arg : output type [tsql|vb|csharp|net] - Options were split to project/GUI parts - There is no "Options Profile" anymore - replaced by the "Project" paradigm - There is no "Selection Profile" anymore - replaced by the "Project" paradigm - Switch "options_profile" was removed - Switch "selection_profile" was removed - Improved T-SQL script formatting Fixes: - Connection timeout expired -------------------------------------------------------------------------------------------------- RELEASE 3.93.163 DATE: 11/27/2005 DESCRIPTION: Feature / Major Fix Release -------------------------------------------------------------------------------------------------- Fixes: - Scripting datetime data type in data mode and apply date format. -------------------------------------------------------------------------------------------------- RELEASE 3.92.160 DATE: 10/30/2005 DESCRIPTION: Feature / Major Fix Release -------------------------------------------------------------------------------------------------- Enhancements: - Speed-up work with selection profiles. - Load data fields on demand (Speed-up load large database). - Optimize using memory of scripting data. Fixes: - Work with user definition type based on string types. -------------------------------------------------------------------------------------------------- RELEASE 3.91.159 DATE: 10/06/2005 DESCRIPTION: Feature / Major Fix Release -------------------------------------------------------------------------------------------------- Enhancements: - Migrate on Microsoft .NET Framework. - Remove switch /e in console mode. - Added application updater. - Split on two modules for GUI(ApexSQLScript.exe) and console(ApexSQLScript.com) Fixes: - PK/Identity field with a seed value of big Changes: - Remove Script Extended Properties option. -------------------------------------------------------------------------------------------------- RELEASE 3.9.158 DATE: 07/06/2005 DESCRIPTION: Feature / Major Fix Release -------------------------------------------------------------------------------------------------- Enhancements: - Added Script Extended Properties option. - "Max" grid column can be cleared by pressing key. Fixes: - In data script header filename "sqlscript.sql" is shown always. - If I open a project in Structure mode that was saved in Data mode before, the app selects correct db (mentioned in a project) and automatically switches me to Data mode. But after I switch back to Structure mode I still see objects from previous db in grid. This results in error message shown below in response to attempt to select any object there. After that the app shows one more error message. - When I try to script several tables in individual files the app generates incorrect scripts for each table - Quite often the app doubles object groups and entries for some objects in Structure Scripting Preview window - After I press Cancel in activation window the app hangs with 99% CPU usage. - When I specify project file without full path in command line, the app searches installation folder for that file first and only then the current one. - In the Data mode when I generate script through VBScript and try to exec, it the app always shows "Script successfully completed" message even if there was no success - e.g. target table didn't exist - The app doesn't clear database name (it shows a name of a db loaded before) in status bar after I reconnect to another server - Phrase "Doc will override it" is shown out of context when /f switch is specified in command line. - There are the following defects in console output when scripting data: number of scripted records is shown for last table only, "File was written..." message should be on new line. - When I try to open non-existent options profile in options form I receive error. - I can't close Individual Object Scripting Results window with Esc button. - In Data->Views mode I try to script data from view. I check that view and press Script button in response the app shows Preview window where I can see several tables besides the view (these tables were checked in Data->Tables mode before); Script Visible Objects option is ON. The app generates script for view's data only when I press OK in that window though. - The app shows messages in a non-std manner. I.e. it uses incorrect titles and/or icons in message boxes. - Use [Db name] option at the Database page doesn't work for the Structure mode - i.e when I script structures the app doesn't place USE statement in a script if the option is ON. - In both modes after I press Refresh dbs toolbutton, the app discards all selections changes and load them from the last stored selections profile. - There is a problem in the Themes submenu. - When some uncommon chars present in a server name, the app shows the following error ticket when I try to switch between modes, close the app, etc. - The app shows error ticket if there are no printers registered and Print grid button is pressed. - The app doesn't disable main grid during it scripts a db - I can check/uncheck objects freely at that time. - Add File comments option doesn't work properly (or unuseful). The app places the same set of comments when this option ON or OFF. - When the app processes db I can click Exit menu item! If I do this the app's GUI disappears, but the app doesn't terminate - I can see it in the Tasks list in Task manager. So to close the app completely I need to end it through Task manager. - If I press Stop button during the app processes a db, it still shows some partial script. - When I don't specify an output file with a full path in a command line the app generates script in the app installation folder - not in the current. - "data" and "strusture" filename prefixes are mixed in granular scripting mode. - When specifying inaccessible drive as saving options profile destination App generates error ticket. - Selected Options tab of Scripting Preview Form window is editable. - When specifying inaccessible drive as saving destination for Script App generates error ticket. - Menus "Tools\Import Selections Profile...", Tools\Save Selections Profile... call no dialog. - Saving Selections Profile with read-only file generates error ticket. - Negative number can be specified as Object Order value. This generates error when scripting. - With granular scripting and VBS output enabled App shows no files in the Scripting Results window -------------------------------------------------------------------------------------------------- RELEASE 3.8.153 DATE: 04/04/2005 DESCRIPTION: Major Feature / Fix Release -------------------------------------------------------------------------------------------------- Enhancements: - Introduced "Project" support in windowed and command line mode. Project contains server connection values, selected database name, list of objects selected to script and scripting options. Project can be: 1. saved to file in windowed mode when database is selected with "Save Project" command. 2. opened directly from connection dialog or with "Import Project" command. 3. used in batch mode instead of connection values, scripting options and object selections - Scripting perfomance is improved greatly both in structure and data modes. - Added scripting support for encrypted objects on "Activated" version only. - Added option “Script selected objects that are visible only”. The option is enabled by default. - Added Script Preview Dialog. The dialog shows objects to be scripted and options åù be used. This allows to preview object list and to address “surprise” syncs issue - Added Save, Import buttons to options dialog - 'Reset Defaults' button in Options dialog changed to separate 'Reset' and 'Defaults' butons - Added Check/Uncheck All and Check/Uncheck Visible context menu commands for object grid. - Reworked batch mode switches and implementation: Help Options: /? [ /help ] : print this message Project Options: /pf [ /ProjectFile ] arg : project file. Omitted means: obtain connection and scripting options from command line Connection Options: /s [ /server ] arg : server name. Ommitted means: "(local)" or project specified value. The switch can't be used with 'ProjectFile' switch /d [ /database ] arg : database name. Omitted means: use database specified in project. The switch can't be used with 'ProjectFile' switch /u [ /user ] arg : user name. Omitted means: the trusted connection or project specified value. The switch can't be used with '/ProjectFile' switch /p [ /password ] arg : password. used with '/user' switch. The switch can't be used with '/ProjectFile' switch /e [ /trusted ] [On|Off] : trusted connection Omitted means: use trusted connection. The switch can't be used with '/ProjectFile' switch Scripting Options: /m [ /mode ] [structure|data] : scripting mode. Omitted means: 'structure' /f [ /force ] : override existing file of same name. Omitted means: don't override /ss [ /structure_selection_profile ] arg : Selection profile file Omitted means: all objects or project specified value. The switch can't be used with '/ProjectFile' switch /ds [ /data_selection_profile ] arg : Data profile file Omitted means: all objects or project specified value. The switch can't be used with '/ProjectFile' switch /o [ /script_file ] arg : script file path. Omitted means: sqlscript.sql file in the current directory /f [ /force ] : override existing file/directory of same name. Omitted means: don't override Other Options: /op [ /options_profile ] arg : Script options profile file. File contains scripting options saved at options dialog in windowed mode. Omitted means: default profile settings or project specified value. The switch can't be used with '/ProjectFile' switch /t [ /test ] : test mode. Don't run the scripting process. Parse switches and display application settings only /v [ /verbose ] : verbose output mode. Omitted means: verbose disabled Samples: ApexSQLScript.exe /pf:myproject.xml /f ApexSQLScript.exe /s:CS /d:pubs /op:profile.xml /ss:profile_structure.xml ApexSQLScript.exe /mode:data /server:CS /database:pubs /script_file:create3.sql /options_profile:profile.xml /data_selection_profile:profile_data.xml - Added support for writing to stdout\stderr. Sample syntax: ApexSQLScript.exe /pf:myproject.xml /f >out.txt 2>>err.txt Fixes: - No one toolbutton at the Outlook bar has a hint - Added handling/reporting on objects which names matches system objects names. Such objects will not appear in object lists. - The app generate error when processing MSSQL7 dbs. - Script incorrectly processes ANSI_PADDING option for tables. - In some cases when I click Check Fields menu item in the columns grid, the app shows a whole bunch of error tickets. - When I close the internal editor by pressing Esc button the app shows an error ticket and terminates if relatively many lines were copied to Windows clipboard from the editor before. - Object Filter toolbar and object filter in a popup menu don't operate synchronously. Changes: - “Check all/Uncheck all” affect all objects whether visible or not - Buttons at Options dialog moved to right instead of bottom. - Error messages in console mode are saved to a single file -------------------------------------------------------------------------------------------------- RELEASE 3.7.150 DATE: 01/20/2005 DESCRIPTION: Medium Feature / Major Fix Release -------------------------------------------------------------------------------------------------- Enhancements: - New option "Individual object scripting". The option can be set in "Options" dialog "Output" tab. - Command line added. Options: /mode=structure|data - omitted means "structure" /server= /database= /trusted: - omitted means the trusted connection /user= /password= /options_profile= - omitted means registry settings /script_file= - omitted means sqlscript.sql or sqlscript.vbs in the app directory /structure_selection_profile= - omitted means all objects /data_selection_profile= - omitted means all objects /h or /help - show this help SAMPLES: start /w ApexSQLScript.exe /server=CS /database=pubs /options_profile=profile.xml /structure_selection_profile=profile_structure.xml start /w ApexSQLScript.exe /mode=data /server=CS /database=pubs /script_file=create3.sql /options_profile=profile.xml /data_selection_profile=profile_data.xml - New option "vbs output" added. The option can be set in "Options" dialog "Output" tab. - Saving/loading object selection to XML. - Added "Save Options" menu/toolbar item. Fixes: - Object selection wasn’t saved. - I use Data mode. I press Tables button first and then I press Views button on Object filter panel. If I haven’t views in database I see empty objects area and non-empty columns area. Script doesn’t clear columns list in this case. - There are no icons for Fields, Identity, Triggers, Where columns in the main grid in the Data mode. - Script command line mode doesn't operate properly. I try to use the simplest syntax (with /srv and /db switches only), but the app doesn't script a db - When the app processes db I can press Reconnect to servers button - it isn't disabled! If I do this I see an error message. - If error handling is ON Script scripts sp_grantdbaccess and sp_revokedbaccess calls inside a transaction - Script incorrectly processes defaults. When I select a default in the main grid and press Process button it doesn't script CREATE statement. - Script doesn't process correctly dbs in compatibility mode 70. I switch pubs db in compatibility mode 70 and try to script it through Script, in response I receive the following error. - Script incorrectly processes rules. When I select a rule in the main grid and press Process button it doesn't script CREATE statement. - Script scripts sp_addrole, sp_addapprole, sp_droprole, sp_dropapprole calls inside a transaction when corresponding option is ON. - When I select an empty db to script (i.e. without any users' objects) I see the following error ticket. - Option to output script in QA doesn't work. I.e. when I choose to output script in QA in the app options Script still outputs it into the internal editor. - Option "Exclude system dbs" is unuseful (or doesn't work). - The app doesn't script permissions for all objects except tables. - I have "Error Handling" option ON, but Script doesn't places transaction handling for scripted data. - I can't save an options profile from the app - there is no an appropriate toolbutton/menu item in the app. Changes: - Reworked Options form.