Update 12/18/2015

NOTE ON UPDATES
Installing from within SQL Script.It! would cause an error, saying that it could not access c:\temp . The solution is to create a c:\temp folder. This release takes care of this issue, so future updates will not have this problem.

Fixes
Importing a second time in the same session would go into a loop
When publishing, did not update “View” drop-down list of Versions

New Things
Moved Tool Tip in Object list to the “Type” column (was too intrusive in the “Name” column)
Added “Schema” column to objects list
Exporting Text would export all objects. Now can select which objects to export. A message is shown when the export is completed (it’s very fast!) with an option to open the folder they were exported to.

A new drop-down “View” on the Scripting tab allows you to quickly look at past versions of your scripts

A new drop-down “Connection” allows you to quickly change connections to run a “View Query” against. Currently this is the only action the “Connection” setting has an effect on. Soon, “Update Database” and “Get From Database” will use this setting.

You can now select part of a script (say, selecting a “Select” statement from within a stored procedure) and then choose “View Query” to see the results of what you’ve selected.

Update posted for 12/10/2015

New build posted on 12/10/2015

Fixes:

  • Updating version would sometimes not work
  • Deleting a Project was not removing all of the children records

Enhancements:

  • Improved Import Preview to include last date modified
  • Added Drop-Down to Script panel, making easy access to past versions
  • New “Copy To Working Version” button makes recovery of a previous version easy
  • Created log of changes to working version
  • Added Delete button to Script List (previously could only exclude)
  • Added “Recent” tab that shows most recent scripts edited
  • Right-click on Objects list now gives option to export to text
  • Added new switch for Importing from database, “Import As Published”. This imports scripts from your database and marks them all as Published. Here are the rules:

The switch is on by default
When doing an import into a blank project
With switch on: Two Versions are created of the imported script, one is the Published version, one is the working version
With switch off: One Version is created, a Working Version is created from the Imported Script. (nothing is published)

When doing in import into an existing project
Only scripts that are new/changed are imported.
With switch on: Existing Working version is archived. Two Versions are created of the imported script, one is the Published version, one is the working version
With switch off: Existing Working version is set as a subversion. A Working Version is created from the Imported Script.

SQL Script.It! – Update Available!

Thanks to all of those who have purchased SQL Script.It!

We’ve put out a new release today with some fixes and features.  You can find a list at www.ohnosoft.com/index.php/changes .
Also on our website, we’ve started to build the Documentation section.  This is found under the Support menu at www.ohnosoft.com/index.php/documentation .  The first entry shows how to use the SSIUpdate.dll in your Clarion application.  This allows you to update your customer’s SQL database as needed.
Because “Check For Updates’ was not working in our initial release, you’ll have to manually download SQL Script.It! again using the link provided when you purchased the program.

Don’t Miss Out on CIDC 2015 Special Pricing!

As a reminder for those who haven’t purchased SQL Script.It!, there is a special coupon available until Friday December 4th!  Our suggested retail is $399, and currently offered for $169 as an introductory price.  Use the coupon CIDC2015 at checkout, and get SQL Script.It! for only $99!  This includes a full year money back guarantee, and your maintenance plan through December 31, 2016!
There’s more to come. We will keep you informed as SQL Script.It! grows and improves!  As always, if you have any questions, comments or issues please e-mail us at support@ohnosoft.com.
Thanks!
— John Hickey and Mary Wade