The New Major Release of SQL Script.It! is now available
SQL Script.It! has been totally redesigned.
Check out the Clarion Live! Webinar where we demonstrated the new features and basic examples for adding SQL Script.It! to your Clarion Application.
SQL Script.It! has native support for Clarion, but can be called from any application via command line.
Coming soon.. instructional videos on just that topic!
Note: This is a total re-write of SQL Script.It! We recommend installing a totally new version of SQL Script.It! rather than just updating. To do that, either install into a different folder and create a new SQL Script.It! database or delete your current SQL Script.It! database from SQL Server before updating.
You can import your projects from their master database and pick up where you left off. For help on transitioning to the new SQL Script.It! contact us at email@example.com .
A major release of SQL Script.It! has been in the works for a while! We previewed the new features at the Clarion International Developer Conference in Orlando. Spoiler, the entire interface has been redesigned! Loaded with new features. Watch the whole demo here.
We’d like to take a real-life application or two and demonstrate live how to add the updating capabilities of SQL Script.It! to it. If you’re willing to share your screen during the webinar and let us show you how to add SQL Script.It! to it, send us an email at firstname.lastname@example.org and we’ll set it up!
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.
Importing a second time in the same session would go into a loop
When publishing, did not update “View” drop-down list of Versions
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.
Deleting a Project was not removing all of the children records
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.
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 email@example.com.
We’ve been working hard to get our first release of SQL Script.It! out the door, and we’ve finally done it! We were expecting to release several weeks ago, but we all know how that goes! What to expect:
This is a BETA release, so expect bugs! We’ve done lots of testing, but we’re sure we’ve missed a few things along the way. We appreciate your bug reports! Send them to firstname.lastname@example.org and we’ll get them fixed as soon as possible! Be sure to test out Script.It! on your test databases only!!
There is currently NO help file! We’re working on that, expect it soon.
Right now you can import scripts, edit them, keep version histories, and publish your views, triggers, procedures, and functions to an encrypted TPS file. There is a folder installed inside the SQL Script.It! install folder called Clarion that contains a DLL, LIB, and Template that you can use in your Clarion program to have it automatically update your SQL databases. This currently supports Clarion 10 only. We’ll be posting instructions on how to use this on our website by the end of the weekend. What we know doesn’t work:
The “Check For Updates” button is having some issues. You can just download from the website for now. We’ll send out messages like this one as we post updates.
The Analyze button will sometimes display just a blue screen. Simply resize the window slightly to fill the panel. We’re working on that!
We’re also working to make creating tabs not quite so “jumpy”.
Finally, a special thanks to the Clarion community for all of your support, help, and encouragement in helping us get this product from concept to market!
— John Hickey and Mary Wade