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.
New build posted on 12/10/2015
- Updating version would sometimes not work
- 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.
Thanks to all of those who have purchased SQL Script.It!
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
— John Hickey and Mary Wade
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
We’ve been working hard to get our first release out, and we’re almost there! John’s been cleaning up the interface and testing all the features, and Mary’s been optimizing the program’s performance. Most recently, Mary sped up publishing of the scripts tremendously; what used to take six seconds now takes less than a second!
What’s left to do? We’ve just completed the programming for managing Maintenance Plans. There is a little cleanup left to do, and a Help file to create. Then we need to test the install, and we’re ready to go! We’re expecting SQL Script.It! to be available within the next week!
A Scripting Tool for Application Developers