SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
SQL Assistant 10.1 is now available!

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
SQL Assistant 10.1 is now available!
Author Message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6845

Post SQL Assistant 10.1 is now available! Reply with quote
Build 10.1.264 is now available for download. This is a very significant maintenance release with new major features and enhancements.

Here is a list of new features and changes:
1. Separation of MySQL and MariaDB interfaces. MariaDB is now a separate database interface supporting new connection options and new features specific to MariaDB.
2. Visual database and schema management is now implemented for Redshift, Greenplum, MariaDB. Significantly extended support for DB2 and MySQL visual schema management.
3. New SQL Preprocessor feature.
4. New SQL References for MySQL 8.0 and MariaDB 10.0.
5. DB Explorer now supports even greater number of schema object types and their features.
6. Enhanced support for PostgreSQL 11, stored procedures, new table options, etc…
7. A number of minor SQL Intellisense usability enhancements.
8. Multifaceted support for partitioned and external tables across all database interfaces.
9. Data Compare – new ways of saving data comparison results to CSV files, copying samples of different data.
10. Enhanced schema compare features for DB2, Redshift, PostgreSQL, Greenplum, MySQL, and MariaDB.
11. New .NET based plugins. Several examples are prepackaged with 10,1, including NS Lookup for IP addresses in data, and others.
12. Customizable data display formats can now be applied to copied and exported data.
13. The DDL Preview pane now enables using the Code Format command to reformat the displayed code for improved readability.
14. Enhancements in SQL Editor for more customizations including custom hot keys for code folding. And others.
15. Data export and data scripting can be scheduled now for unattended runs..
16. Code Generator now supports all types of database objects and can be used to automate repetitive operations for a greater set of tasks.
17. Visual management and monitoring of SQL Server Service Broker.
18. Lots of other minor changes and enhancements.
Wed Jan 30, 2019 10:22 am View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 1525
Country: Hungary

Post Question #1 Reply with quote
Does the preprocessor feature work with snippets? That would be awesome.

EDIT: See some examples >>>here<<<.


Last edited by gemisigo on Mon Feb 04, 2019 10:09 am; edited 1 time in total
Mon Feb 04, 2019 7:42 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6845

Post Reply with quote
I'm afraid I don't understand how that can be mixed together. Would you please submit some example as a separate topic?

In general, the preprocessor massages the text before everything else is done, replacing variables and certain types of expressions, or at least that's how I expect it to behave by definition.
Just in case, you can define both local variables in scripts directly using #define directives, and global reusable variables saved permanently. For the later you would need to open the preprocessor pane (you can find it the Command Selector) and add global vars there.
Mon Feb 04, 2019 9:28 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.