Major feature of this upcoming release is the Unicode support. There will be two versions of SqlDbx available: Ansi and Unicode. Two versions will be basically the same with some minor differences.
We decided to have two different versions because it seems easier to maintain and update the code and not everybody needs Unicode to begin with. Unicode version handles everything in Unicode. Some peaces of SqlDbx were pretty easy to convert to Unicode and some were not. Editor, UI controls and Results Grid required some minor changes. Most problems were related to the way different Database Servers implement Unicode support in different versions. Sql Server and DB2 were the easiest to convert. They have API similar to ODBC which is Unicode "aware". The most
time consuming was Sybase support. Documentation is sparse and not very clear in some areas.
Seems that everything is working pretty well now.
Mar 24, 2008
Feb 3, 2008
SqlDbx Version 3.16 is out
Adding column (block) mode support to Script Editor was not as simple as I anticipated, but it's done and I think it stacks up pretty good against other editors which support block mode.
Last couple of weeks talked to some of our users and it's interesting how some of the features and options they ask for are already implemented, but they never found out about them. One of these features is an ability to save and restore workspace state between restarts. This can be turned on in Options on General Tab, just check "Enable Session State". Also you can save / load it at any time. Look under File->Save Session State and File->Load Session State. Another example is scripting of objects from Object View pane. By default object definition goes to active Script window. This can be changed in Options->Scripting.
Next release will be mostly small fixes and performance improvements in some areas like generating thousands of inserts, export to Excel.
Last couple of weeks talked to some of our users and it's interesting how some of the features and options they ask for are already implemented, but they never found out about them. One of these features is an ability to save and restore workspace state between restarts. This can be turned on in Options on General Tab, just check "Enable Session State". Also you can save / load it at any time. Look under File->Save Session State and File->Load Session State. Another example is scripting of objects from Object View pane. By default object definition goes to active Script window. This can be changed in Options->Scripting.
Next release will be mostly small fixes and performance improvements in some areas like generating thousands of inserts, export to Excel.
Jan 13, 2008
Version 3.15 released
What I realized recently after talking to some of our customers that they do not know about some of the useful features we have implemented. So I decided to start describing some of them.
One of the feature which is pretty useful is ability to generate SELECT, INSERT, DELETE, UPDATE SQL statements directly from Results Grid. This functionality is available if you right click in Results Grid and select "Generate" menu item. You also can select multiple areas in Result Grid by holding Ctrl key.
Recently released version 3.15 has two new nice features. Both of them are on Script Editor pop up menu. In Script Editor click on database object name then right click and select menu item "Script Object to new Window". Object definition should open in new window, or you can select "Sync Object View" and if object found in Object view it will be made visible.
Now I started working on version 3.16. Main changes in 3.16 will be around Script Editor. Editor will support column selection / copy /paste mode.
One of the feature which is pretty useful is ability to generate SELECT, INSERT, DELETE, UPDATE SQL statements directly from Results Grid. This functionality is available if you right click in Results Grid and select "Generate" menu item. You also can select multiple areas in Result Grid by holding Ctrl key.
Recently released version 3.15 has two new nice features. Both of them are on Script Editor pop up menu. In Script Editor click on database object name then right click and select menu item "Script Object to new Window". Object definition should open in new window, or you can select "Sync Object View" and if object found in Object view it will be made visible.
Now I started working on version 3.16. Main changes in 3.16 will be around Script Editor. Editor will support column selection / copy /paste mode.
Subscribe to:
Posts (Atom)