EMS SQL Manager 2005 for SQL Server is a powerful tool for SQL Server administration and development. SQL Manager 2005 for SQL Server works with any SQL Server versions from 7 to 2005 and supports all of the latest features including assembiles, DDL triggers, synonyms, typed XML columns, and so on. It offers plenty of powerful tools for experienced users to satisfy all their needs. SQL Manager 2005 for SQL Server has a new state-of-the-art graphical user interface with well-described wizard system, so clear in use that even a newbie will not be confused with it.
EMS SQL Manager 2005 for SQL Server new features:
Latest SQL Server versions support
Full compatibility with any SQL Server version from 7 to 2005.
Full support of SQL Server 2005 permission system.
DDL Triggers, Synonyms and Aggregates support.
Typed XML columns.
Significantly improved user interface
New well-described Wizard System to perform complex tasks easily.
Fast accessing to most essential actions using Navigation bars in most of the windows.
New Windows Toolbar to switch between windows easily, like Windows Task Bar.
Office 11 and Windows XP visual schemes support.
Improved Database Explorer
Creating tabs for any tree node to access it in one-click!
Work with multiple selected objects at a time.
Much more convenient toolbar and context menu.
New powerful tools to perform SQL Server administrative tasks
Server and database properties windows.
DTS Packages management tool.
Visual Database Designer to handle database structure in a few clicks
Creating diagram of existing database using Reverse engineering tool.
Dividing diagram into different subject areas located on separate pages.
Navigating through diagram using preview navigation tool.
Creating/editing/dropping tables and table fields visually setting links between them.
Saving as image or printing database diagram.
Two diagram notations (IDEF1x and IE).
A lot of visual customization options.
New powerful data management tools
Plenty of useful tools such as data grouping, summarizing, fast searching and filtering.
Master-Detail View to work with two linked tables at the same time.
Table and Card Views to see data the way you like.
Ability to copy and paste selected records.
Advanced printing system.
Fully customizable interface.
Improved report management
New Create Report Wizard allows you to create simple report in a few clicks.
Managing reports the same way as if they were a database object: accessing reports directly through DB Explorer tree.
.topic 1220
What's New in EMS SQL Manager 2005 for SQL Server?
1. Editor Options. Key Mapping tab added which allows you to set the shortcuts for SQL editors.
2. XML Schema Collections support is implemented
3. Query Builder.
Query execution plan is now displayed as a graphical diagram.
Queries containing user-defined functiouns now supported.
4. Dependency Tree. The diagram can now be printed
5. SQL Editor.
Now it's possible to rename and move query tabs
Ability to execute statement under cursor added.
Query execution time is now displayed in hh:mm:ss format.
The timer in status bar area used to stay running on after aborting query execution.
6. SQL editors.
Now you can set a source code fragment as a comment with a single click.
Next Bookmark, Previous Bookmark context menu items added.
With 'Trim trailing spaces' option on, an attempt to use Code Complete used to clear all the line. Fixed now.
Dragging the field names from SQL Assistant works perfectly now.
7. Grant Manager. When opening Grant Manager window it was impossible to edit statement permissions without forced refresh. Fixed now.
8. HTML Report.
Now you can include user and role information into a report.
Ability to change header/footer of the report added.
9. Extract Database.
The option adding the 'create database' statement to the script appeared.
Server version is included into comments for the script now.
10. Environment Options. Now it's possible to set refreshing objects timeout. Refresh of the objects can be terminated after timeout expired if there is an active transaction that made any changes to metadata.
11. Open/save backup file dialogs now look more like standard ones in behaviour.
12. Import Data wizard.
With 'Use transactionsà' option disabled now in 'Commit changes manually' mode you will be prompted for an action on transaction.
Ability to resize wizard window added.
'Division by zero' error used to appear after importing data with the 'Commit changes manually' option switched on. Fixed now.
Having specified user-defined fields to import, the rest of them were filled with empty strings; so that default values defined for the fields were not applied. Fixed now.
13. Trigger Editor. When altering a trigger schema/owner's name wasn't added to the trigger name in the script generated, that in some cases raised errors. Fixed now.
14. Foreign key/check constraint editors. 'Not for replication' option added.
15. Visual Database Designer.
It was impossible to drop table via corresponding context menu item when just a field, not the table itself, was selected. Fixed now.
When dragging a table not from default schema (SQL Server 2005) from DB Explorer to the Query Builder working area an error used to appear and the table was not added. Fixed now.
16. Grid
The 'Paste Cell' menu item didn't work in Lite version. Fixed now.
In some rare cases the data of of bigint-typed fields were displayed improperly. Fixed now.
With 'Column auto-width' option enabled BLOB field columns used to become too wide. Fixed now.
17. SQL Script. Confirmation of abort script execution added.
18. Restore Database.
It was impossible to type in backup file name in corresponding window. Fixed now.
Prompt for registration the database used to appear even if restoration was unsuccessful. Fixed now.
19. Job Editor. Fixed the bug with a wrong script generation when you saved the job in which the created schedule was deleted.
20. DB Explorer
It was unable to open index or trigger via Recent Objects menu. Fixed now.
Popup menu used to stay on top when switching between applications. Fixed now.
After table duplication the indices and triggers of the new table were not displayed in DB Tree. Fixed now.
21. Export Data Wizard.
With 'Export empty tables' option disabled on attempt to export an empty table there raised an error containng no text. Fixed now.
In some cases, when exporting data to MS Excel format the 'Data format \ Styles' options used to work incorrectly. Fixed now.
When exporting data to MS Excel format the user-adjusted Boolean True format used to be ignored. Fixed now.
22. Detach Database. Having used 'Clear connections' function, the database was still displayed in DB Tree and further attempts to access its objects returned errors. Fixed now.
23. Many other other small improvements and bugfixes.
.topic 840
.topic 680
To make it easier for you to purchase our products, we have contracted with share-it! registration service. The share-it! order process is protected via a secure connection and makes on-line ordering by credit/debit card quick and safe. The following information about share-it! is provided for your convenience.
Share-it! is a global e-commerce provider for software and shareware sales via the Internet. Share-it! accepts payments in US Dollars, Euros, Pounds Sterling, Japanese Yen, Australian Dollars, Canadian Dollars or Swiss Franks by Credit Card (Visa, MasterCard/EuroCard, American Express, Diners Club), Bank/Wire Transfer, Check or Cash.
If you have ordered EMS software online and would like to review your order information, or if you have questions about ordering, payments, or shipping procedures, please visit our Customer Care Center, provided by share-it!
Please note that all of our products are delivered via ESD (Electronic Software Delivery) only. After purchase you will be able to immediately download the registration keys or passwords and download links for archives of full versions. Also you will receive a copy of registration keys or passwords by e-mail. Please make sure to enter a valid e-mail address in your order. If you have not received the keys within 2 hours, please, contact us at sales@sqlmanager.net.
SQL Manager 2005 for SQL Server
.topic 1200
Full version history is available at http://www.sqlmanager.net/products/mssql/manager/news.
Version 2.2.0.1 - February 7, 2006
1. SQL Editor. Query execution plan is now displayed as a graphical diagram.
Now when pasting records from the clipboard, you can set correspondences between clipboard columns and query columns.
Form view. Memo fields editor is extended (can be customized in Grid > Advanced tab of Environment Options dialog).
Blob View. 'Word Wrap' option for text added.
'Set to Empty String' and other similar operations do not result in posting records in the table any more.
4. SQL Script.
Progress in script execution is now displayed and execution process can be stopped.
Several windows can now be opened simultaneously.
SQL Script used to hang when a large (>10Mb) script was edited and Enable Parsing was on. Fixed now.
Now some additional Types of Statements can be parsed.
5. SQL Editor.
Query execution plan now works with SQL Server 2005.
Now there are no limitations for the size of edited scripts.
6. Field Editor. Default constraints now can be renamed.
7. DTS Packages. Now you can remove imported packages.
8. Table Data. Not all the records added with the following COMMIT in 'Use transactions in Data tab of object editors, SQL Editor and Query Builder' mode (Tools tab) were displayed. Fixed now.
9. Exract Database. The following bugs are fixed:
With 'Insert COMMIT after each block' option turned on, COMMIT was added but without corresponding BEGIN TRANSACTION.
Empty not-NULL image fields used to be displayed incorrectly.
dbo name was missing when generating INSERT INTO [dbo].[table_name].
10. Export as SQL Script. With 'Insert COMMIT after each block' option turned on, COMMIT was added but without corresponding BEGIN TRANSACTION. Fixed now.
11. Wrong dependency order was showed for Assemblies, Aggregates, Partition Functions and Partition Schemas: main object used to be diaplayed after the dependent one. Fixed.
12. Visual Database Designer. There were no changes seen in opened graphical diagram when the table name or any table field was edited.
13. Reorder Columns, Duplicate table, Extract Metadata. The tables with timestamp/rowversion field are processed properly now.
14. Switching program interface language took a long time if there were any databases connected. Fixed now.
15. Database Properties. If 'Auto file growth' option was off for a DB file, it couldn't be turned on. Fixed.
16. Attach Database. The following bugs are fixed:
It was unable to set login and password using SQL Authentication.
File name field did not contain the button to call 'Select File' dialog.
17. UDT Editor. 'For new columns only' options are processed properly now.
18. DB Explorer. following bugs are fixed:
It was unable to duplicate triggers and indices
After dropping a trigger or index it was still displayed in the DB Explorer tree.
19. Query Builder stores queries between sessions now.
20. 'Don't fill server lists in connection forms' option is added. It bans retrieving information about all SQL servers available on the local network because in some rare cases it might take a long time.
21. The border of SQL editor is now painted according to the current visual scheme.
22. Procedure Editor. If the FLOAT type was specified for procedure parameter and had value equal to 0, it used to be processed as NULL. Fixed now.
23. Restore Database > Select Backup Set. Sometimes due to the improper size of the dialog directory tree was not seen. Fixed.
24. The needed documentation page did not open for some forms when pressing F1. Fixed now.
25. Synonym Editor, Aggregate Editor. It was unable to create an object when <Default> scheme was selected because of wrong script generation. Fixed now.
26. Create Database wizard. If log and data files had the same names when creating a database the log file was not created. Fixed now.
27. Aggregate Editor.
If parameter doesn't contain '@' symbol it is added automatically now.
Turning 'Max Size' option on disables 'Size' field now.
28. Fixed the bug with the Code Completion dropdown list which could be partially covered with Windows Taskbar.
29. On continuous holding F5 button to refresh the objects in DB Explorer they used to double. Fixed now.
30. Table/Field Editor. Identity seed is now displayed properly for the values bigger than 65536.
31. Check Editor. 'Check existing data' option is not cleared anymore after compiling current check.
32. After renaming the object its name was not refreshed in DB Explorer context menu. Fixed now.
33. For some forms Refresh operation could not be made with F5 button. Fixed now.
34. Other small improvements and bugfixes.
Version 2.1.0.1 - November 16, 2005
1. Partition functions and partition schemes are now supported.
2. Added ability to work with linked servers.
3. German localization is implemented (Michael Albrecht).
4. Export Data/Import Data Wizard. In Templates drop-down menu "Save Current Settings as Default" and "Reset Saved Settings" options are added.
5. New editor options added: Trim trailing spaces, Drag and drop text, Group undo, Keep caret horizontal position.
6. Grid. Large queries were opening very slowly because the switch to Grid Mode Load All Rows was executed after the grid was filled. Fixed now.
7. Export Data Wizard. Added Finish button that launches Wizard at any moment.
8. Export as SQL Script and Extract Database gave values of datetime type in the formats predefined in Windows settings, which sometimes caused execution errors. Fixed now.
9. When creating CLR user-defined data type a correct script is generated now.
10. Unicode data are now displayed correctly for the system language for non-Unicode programs.
11. Object Editors. When pressing F5 in the subobjects lists Access Violation error occurred. Fixed now.
12. Window List. Added Close window action into context menu.
13. "Don't save query text" option available back in version 1.x of the program is now restored to SQL Editor.
14. Grid. Adding level bound by several fields caused "Invalid column name" error. Fixed now.
15. Save Settings. Multi-line keyboard templates were blank when imported from file. Fixed now.
16. Keyboard Templates. #Date tag gave the wrong date. Fixed now.
17. Printing now works correctly in Aggregates, DDL Triggers, and Synonyms editors.
18. Index Editor. Clicking the header of selected fields list returned the Access violation error if the list was empty. Fixed now.
19. SQL Script is now saved with any content of the editor.
20. Allow parameters in SQL (Tools tab of Environment Options dialog) for open Query Builder and SQL Editor windows can now be activated. Also, when running queries asynchronously the values of parameters were not taken. Fixed now.
Version 2.0.5.1 - October 26, 2005
1. When closing the program it gave a number of errors if no other programs were running. The bug is fixed.
2. Field default values are displayed correctly now when working with SQL Server 2005.
3. SQL Editor.
- Text search didn't work when called through editor context menu.
- Sometimes Limit bar was displayed for grid.
- Code Completion across databases didn't work by table alias with owner (schema) not specified.
- Code Completion by table aliases didn't work after 10-15 table lines down the text.
- When adding new tab and trying to delete a row, Access Violation error emerged.
The bugs are fixed.
4. Database Registration Info. Display Options weren't saved after closing/starting the program. Fixed now.
5. Now the size of stored procedure and UDF parameters is shown correctly.
6. SQL Script. Access Violation error arose when opening Code Completion if there were no connected databases. The bug is fixed.
7. DB Explorer. Now the parameter information of some stored procedures types is displayed correctly in SQL Assistant.
8. Grid. Filtering by value that had an apostrophe (') character wasn't functioning. Fixed now.
Version 2.0.0.1 - October 14, 2005
Latest SQL Server versions support
Full compatibility with any SQL Server version from 7 to 2005.
Full support of SQL Server 2005 permission system.
DDL Triggers, Synonyms and Aggregates support.
Typed XML columns.
Significantly improved user interface
New well-described Wizard System to perform complex tasks easily.
Fast accessing to most essential actions using Navigation bars in most of the windows.
New Windows Toolbar to switch between windows easily, like Windows Task Bar.
Office 11 and Windows XP visual schemes support.
Improved Database Explorer
Creating tabs for any tree node to access it in one-click!
Work with multiple selected objects at a time.
Much more convenient toolbar and context menu.
New powerful tools to perform SQL Server administrative tasks
Server and database properties windows.
DTS Packages management tool.
Visual Database Designer to handle database structure in a few clicks
Creating diagram of existing database using Reverse engineering tool.
Dividing diagram into different subject areas located on separate pages.
Navigating through diagram using preview navigation tool.
Creating/editing/dropping tables and table fields visually setting links between them.
Saving as image or printing database diagram.
Two diagram notations (IDEF1x and IE).
A lot of visual customization options.
New powerful data management tools
Plenty of useful tools such as data grouping, summarizing, fast searching and filtering.
Master-Detail View to work with two linked tables at the same time.
Table and Card Views to see data the way you like.
Ability to copy and paste selected records.
Advanced printing system.
Fully customizable interface.
Improved report management
New Create Report Wizard allows you to create simple report in a few clicks.
Managing reports the same way as if they were a database object: accessing reports directly through DB Explorer tree.
Version 1.8.5.1 - June 27, 2005
1. Support of SQL Server 2005.
2. When error arose in SQL Editor or Changing Metadata window the cursor is placed to the proper place.
3. Create Table. We have improved editing abilities in the fields' grid.
4. Editor Options. Implemented 'Convert Tab character to spaces' option.
5. SQL Editor. Implemented 'Don't save query text' option.
6. SQL Editor. Appeared ability to reset current execution point û added the corresponding item in context menu.
7. Table Editor. Confirmation request wasn't shown when deleting table subobjects even if the corresponding option was on.
8. Query Builder. WHERE part was parsed incorrectly if there were several IN operators û the list was duplicated.
9. Timeouts didn't work in SQL Script.
10. Sometimes when disconnecting from a database, its objects refreshed if viewing table subobjects was off.
11. Grid. Time value wasn't shown when trying to enter edit mode for datetime fields.
12. When trying to open a procedure with number (e.g. proc;1) arose an error saying that the procedure was not found in the database.
13. The program hanged when using keyboard templates if Windows clipboard had # (hash) symbol.
14. To-Do List. Fixed the bug with a second copy of an item appeared when editing it.
15. Table Editor, Dependency tab. Tables with foreign keys referring to the opened table weren't shown in the dependent objects list.
16. If Clustered checkbox was off when creating an index, the keyword NONCLUSTERED wasn't added to script, which led to creating clustered primary key even if this option was off.
17. Shortcuts for tabs didn't work. Now it is solved.
18. Solved the problem with not restoring the state of the main form's window when running the program.
19. It was impossible to edit fields having point (.) or 'on' word in their name.
20. Code Completion didn't work with table aliases which had dollar sign ($) in their name, e.g. "TableName$".
21. Editor Options. Decreased minimum possible value for Quick Code delay.
Version 1.8.0.1 - December 14, 2004
1. We have implemented the ability to autogenerate names for the table's subobjects on their creating. You can customize the name templates or disable this option on the Naming Rules tab of the Environment Options dialog.
2. Extract Metadata. Changed the sequence of some operator types to register possible dependencies between objects. Included support for identity and calculated fields. Added ability to generate IF EXISTS... DROP statements.
3. SQL Editor. Now it is possible to view the query results on the same tab with the query text.
4. There is the new ability to disable showing the Changing Metadata window using the corresponding option in Confirmations tab of Environment Options dialog.
5. Query Builder. Access Violation error emerged when adding a criterion and closing a form. The bug is fixed.
6. Table Data. The error 'DataD: Cannot perform this operation on a closed dataset' doesn't appear anymore.
7. On creating unique index you can now select whether to create an index or a constraint.
8. Grid. Added the ability to set format for the money fields in the Environment Options dialog on the Grid tab.
9. Table Data. Fixed the bug with not saving the Grid layout.
10. 'Make hidden Table Explorer visible on new table window' option is substituted for 'Hide Table Explorer'. A new button is added in the toolbar of Table editor to show/hide the explorer.
11. If the field was indexed, you couldn't change its type or NOT NULL constraint - the script error arose. The problem is solved.
12. Extract Metadata & Export As Insert. When extracting BLOB data the final bytes with 0x00 value were cut. Fixed now.
13. Export Data wizard. When the 'Current record only' option was selected the cursor jumped to the first record and the first record was exported. The problem is solved.
14. When running the program you couldn't shut down Windows. The bug is fixed.
15. Print Metadata. Fixed the bug with not filling out the Primary Key and Unique columns of table fields.
16. Now the Help \ 'Send bug report to' menu item is passed to our Support Ticket System.
17. The 'Class TSynEdit not found' error arose when trying to open the localization form. Fixed now.
Version 1.7.0.1 - September 09, 2004
1. We have implemented a new form for creating tables. Now it allows you to define all the table fields before table creation.
2. Import Wizard: We have added an ability of defining an error log file name.
3. Backup/Restore. While working with large databases, operation was canceled by timeout in 30 seconds. Problem is solved.
4. Code Completion.
Processor loading was raised after the window "code completion" had been opened in non-default localization. Fixed now.
It bounced back to the top of the list after you started typing. The problem is solved.
The view isn't canceled in case the space is entered or the cursor is moved after typing a letter or number.The bug is fixed.
The problem with re-opening code completion window after inserting the word is solved
5. Export As Insert: in float fields dot is used as a fractional part separator now.
6. The bug that caused only tree-choice of backup filename in case of using non-logical device is fixed now.
7. The wrong script was generated when Nou Null field with Unique limit and without default value had been added. Problem is solved.
8. After the field with unique non-constrained index had been changed, the wrong script was generated. The bug is fixed.
9. Available permissions were defined wrong for UDF. Problem is solved.
10. Edit login. The password can't be cleared. Fixed now.
11. Delete confirmation is requested now when deleting query pages.
12. Integer field changes (if field was not in edit mode) weren't correctly saved. Problem is solved.
13. The font size changes in Environment Options weren't spread at menu and toolbar. The bug is fixed.
14. The error "RecordIndex out of range" appearing when editing database file list is corrected now.
15. The Row Guid flag can't be changed for fields with type "uniqueidentifier". Fixed now.
16. Sometimes after upgrade to a new product version the language settings can be changed. Problem is solved.
17. Export to XML. If table field names contained spaces, the summary-file wouldn't open. The bug is fixed.
18. Changing metadata window: now the editor font is determined by the database properties instead of the previous default.
Version 1.6.0.1 - May 31, 2004
1. We have significantly improved the Export Dialog. Now you can add notes, hyperlinks, and charts based on exported data to Excel documents. You can also define graphical styles for column captions, data, footer, and header on export to RTF documents. An ability to define strip styles is also included.
2. We have significantly improved the Import Data Wizard to make most of new abilities of EMS QuickImport 2 component suite available in MS SQL Manager:
Import from XML format is available now.
An ability to import data from different Excel sheets is implemented.
An ability to import formulas from Excel is added.
3. We have implemented a new service - Backup Devices Manager. You can access this new service via the Services menu.
4. SQL Editor: Now you can use the Shift+Ctrl+Spacebar key combination to view function parameters after you entered a function name in your code. The Shift+Ctrl+P key combination can be used to insert names of the function parameters into your code.
5. Duplicate Table: With this version you can copy the table data along with the table structure.
6. We have added a new localization - Chinese (Simplified).
7. The Database Metadata Log now contains only records that are executed completely and not rolled back.
8. The Database SQL Editor Log now contains only statements that are executed successfully. You can disable this feature using the corresponding option on the SQL Editor tab of the Environment Options dialog.
9. Now the program correctly shows all the objects on the Dependencies tab.
10. If the table contained a calculated field with more than 4000-char length, then the 'List index is out of bounds' error appeared. We have fixed it.
11. Form View: NULL values of date fields were displayed as 30.12.1899.
.topic 810
Please read this page attentively if you have questions about EMS SQL Manager 2005 for SQL Server.
Table of contents
Product Questions
What is EMS SQL Manager for SQL Server?
What is the difference between Professional/Lite and Windows/Linux editions of EMS SQL Manager for SQL Server?
What do I need to start working with EMS SQL Manager for SQL Server?
What is the difference between the Export/Import functions in the SQL Manager for SQL Server tool and the Data Export/Import for SQL Server utilities?
What is the difference between the Query Builder module in the SQL Manager for SQL Server tool and the SQL Query for SQL Server utility?
What is the difference between the Extract Metadata function in SQL Manager for SQL Server and the DB Extract for SQL Server utility?
Common Questions
I can't modify DDL. Why?
How can I customize data formats in a grid?
When I create database objects, their names are always converted to lower case. How I can prevent it?
I am trying to create a report in Report Designer, but can't get access to the table data: 'Band data source' list is empty.
I have a table with ~ 1000 records only and a large number of fields. Opening this table on Data tab takes too much time.
I need to perform some changes in database objects of my test database and then make the same changes on master database. Are there any tools for this purpose in SQL Manager for SQL Server?
Export/Import Questions
I tried to export data from a table, but found that I can export only the first 1000 records. Can I export all the records from a table if it contains more than 1000 records?
I'm trying to export table, but LONGTEXT fields are not exported.
What is the difference between the "Extract Metadata" and "Export As Insert" functions?
How do I change the default directory where exported data will be saved?
Question list
Product Questions
Q: What is EMS SQL Manager for SQL Server?
A: EMS SQL Manager 2005 for SQL Server is a powerful tool for Microsoft« SQL Server administration and development. SQL Manager 2005 for SQL Server works with any SQL Serverversions from 7 to 2005 and supports all of the latest features including assembiles, DDL triggers, synonyms, typed XML columns, and so on. It offers plenty of powerful tools for experienced users to satisfy all their needs. SQL Manager 2005 for SQL Server has a new state-of-the-art graphical user interface with well-described wizard system, so clear in use that even a newbie will not be confused with it.
Q: What is the difference between Professional/Lite and Windows/Linux editions of EMS SQL Manager for SQL Server?
A: These editions of SQL Manager for SQL Server differ in price and features. To register SQL Manager for SQL Server see our Purchase Page, and to learn about the difference in features please go to our Feature Matrix Page.
Q: What do I need to start working with EMS SQL Manager for SQL Server?
A: First of all you must have a possibility to connect to some local or remote SQL Server to work with SQL Manager for SQL Server. Besides you need your computer to satisfy the system requirements of SQL Manager for SQL Server. SQL Manager for SQL Server runs on Windows 95/98/Me/NT4/2000/XP and Pentium 166, 32 Mb RAM is recommended.
Q: What is the difference between the Export/Import functions in the SQL Manager for SQL Server tool and the Data Export/Import for SQL Server utilities?
A: The Data Export/Import for SQL Server utilities includes some additional features, which are not available in SQL Manager such as:
export/import data from/to several tables at once;
export/import data from/to tables selected from different databases on one host;
command line utility to export/import data using the configuration file with all the export/import options.
Q: What is the difference between the Query Builder module in the SQL Manager for SQL Server tool and the SQL Query for SQL Server utility?
A: First of all, SQL Query works faster as it is a much lighter product. Besides it provides additional features for query building, e.g.:
"favorite" queries to find and execute often-used queries quickly;
keeping query history, which allows you to rollback to any edited query;
various interface improvements for more productive and easy work;
Q: What is the difference between the Extract Metadata function in SQL Manager for SQL Server and the DB Extract for SQL Server utility?
A: The DB Extract utility includes some additional features, which are not available in SQL Manager, such as:
extracting metadata from several databases on one host;
console application for executing extract in one-touch;
faster execution speed;
Scroll to top
Common Questions
Q: I can't modify DDL. Why?
A: The 'DDL' tabs of the Table Editor and UDF Editor are read-only. They display the SQL text of the operations you carry over the table on the tabs 'Fields', 'Indices', etc, or over the UDF. To modify this text you can copy it to the clipboard and modify it using SQL Script Editor.
Q: When I create database objects, their names are always converted to lower case. How I can prevent it??
A: You need to switch off the "Convert created object's names to lower case" option in Environment Options dialog.
Q: How can I customize data formats in a grid?
A: You can customize all display formats: integer, float, date, time and date/time in the Environment Options window.
Q: I am trying to create a report in Report Designer, but can't get access to the table data: 'Band data source' list is empty.
A: To get data source in a report you need to add a dialog form to the report (menu 'Edit' \ 'Add dialog form' of Report Designer), then place database and query components from the left designer panel on it and set connection and query properties. Then the query appears in data source lists.
Q: I have a table with ~ 1000 records only and a large number of fields. Opening this table on Data tab takes too much time.
A: Please select the option 'Initiate a row-by-row result set retrieval' on 'Grid' \ 'Advanced' tab of Environment Options dialog.
Q: I need to perform some changes in database objects of my test database and then make the same changes on master database. Are there any tools for this purpose in SQL Manager for SQL Server?
A: Database Registration Info dialog contains Log tab where you can enable logging metadata changes, which are performed on a database, and SQL statements, that are executed in SQL Editor.
Scroll to top
Export/Import Questions
Q: I tried to export data from a table, but found that I can export only the first 1000 records. Can I export all the records from a table if it contains more than 1000 records?
A: The Export Data function exports only records those are currently selected in the grid view. The selection is limited by 1000 by default, so you should increase this value to select all the records to be able to export them all. Also you can set the default limit value on the Grid tab of the Environment Options dialog.
Q: I'm trying to export table, but LONGTEXT fields are not exported.
A: Fields of types TEXT, LONGTEXT are not exported by default. You should select these fields manually on the Fields tab.
Q: What is the difference between the "Extract Metadata" and "Export As Insert" functions?
A: "Export As Insert" is intended to export table data that will be inserted into a database system other than PostgreSQL server. Use "Extract Metadata" to copy data to a table on PostgreSQL server.
Q: How do I change the default directory where exported data will be saved?
A: Follow the steps below to change directory.
1. Right click on database you need in DB Explorer and click on "Database Registration Info..." item in popup menu (you can also find out this item in main menu "Database"). The Database Properties form will be opened.
2. Click on the "Save Options" tab.
3. In the "Default Directory for Export Data" section you can choose the default directory for export file.
Scroll to top
If you still have any questions, contact us at Support Center.
.topic 60
Database Explorer (or DB Explorer) is the basic navigation window for working with databases and database objects. Its treelike structure with multiple tabs allows you to perform almost all operations upon the databases and their objects quickly and easily. The following list contains the most common features provided by the Database Explorer.
Managing database registration info
Connecting to a database
Performing basic operations upon database objects
Creating projects to work with selected objects only
Navigating database objects using multiple tabs
Selecting multiple objects
Easy access to recently opened objects
Viewing information about database objects
Configuring Database Explorer
To view or hide this window use the View | DB Explorer menu item or press F11.
.topic 90
Database Explorer allows you to perform the following operations related with registering databases from its popup menu:
Register database
Unregister database
Edit database registration info
.topic 100
Use Projects node in each database to work with the selected objects of this database only. You can place here any object from the database tree.
Creating project
To create a project:
Create a folder (and maybe some subfolders) by right-clicking the Projects node and selecting the New Folder menu item.
Specify the new object name in the dialog window.
To add an object to the project:
Drag the object(s) from the database tree and drop it to the project folder.
Note: You can also create separate tab for your project. See Creating new tab section.
Removing object from project
To remove an object from the project:
Right-click the object and select the Remove Object menu item.
Confirm removing in the dialog window
Note: This does not drop the object out of database, but only removes it from the project tree.
.topic 117
Use Recent Objects button on the Database Explorer toolbar to access the list of recently opened database objects (during the current work session). This list is common for all the databases. Next to the object name the database name is displayed. Select the object from this list to open it with the editor.
To change the number of objects, considered 'recent' select the Options | Environment Options menu item and set the Recent objects count option value on the Tools | DB Explorer page (see Environment Options for details).
.topic 790
This area helps you to work with the DB Explorer window, displaying the additional information about the selected object or group of objects.
If you select a server in the DB Explorer, the SQL Assistant displays the list of the registered databases, where those you are connected to, are displayed in bold. Double-clicking the database alias in the SQL Assistant connects you to the database or disconnects you from it.
If you select a database in the DB Explorer, the SQL Assistant displays the list of the database object groups and a number of objects for each group. Selecting an object group in the DB Explorer displays the list of objects in the SQL Assistant. Double-clicking the object name in the SQL Assistant makes the object available for editing in the proper editor window. Right-clicking the object or group of objects (selected with the Ctrl or Shift buttons) allows you to edit or drop the selected objects.
What is displayed in SQL Assistant when a table is selected in DB Explorer depends on the position of the Tables' Details switch. It can be called via the View Mode button | Tables' Details menu on the toolbar or via the popup menu of the SQL Assistant.
Selecting another objects in the DB Explorer displays its DDL definition or description in the SQL Assistant depending on position of the Other Objects' Details switch. It can be called via the View Mode button | Other Objects' Details menu on the toolbar or via the popup menu of the SQL Assistant.
.topic 5
SQL Manager 2005 for SQL Server provides all the tools you need to manage and navigate databases. Note that to start working with databases in SQL Manager 2005 for SQL Server you are to register them (see Register Database Wizard).
Create Database
To create a database
Select the Database | Create Database menu item.
Set the database name, connection and authorization options in the Create Database Wizard.
Set option Register After Creating to call the Register Database Wizard after the creation finishes.
Drop Database
To drop a database
Select the database to drop in the DB Explorer tree.
If you are not connected to any database on the server, double-click its alias to establish connection.
Select the Database | Drop Database menu item.
Confirm dropping in the dialog window.
Register Database
To register a single database in SQL Manager 2005 for SQL Server
Select the Database | Register Database menu item.
Set connection, authorization and other options in the Register Database Wizard.
To register multiple databases on one host
Select the Database | Register Host menu item.
Set connection and authorization options, and select the databases to register in the Register Host Wizard.
Unregister Database
To unregister a single database
Select the database to unregister in the DB Explorer tree.
Select the Database | Unregister Database menu item.
Confirm unregistering in the dialog window.
To unregister all databases on the host
Select the host to unregister or a database on this host in the DB Explorer tree.
Select the Database | Unregister Host menu item.
Confirm unregistering in the dialog window.
Connect to Database
To connect to a database
Select the database to connect to in the DB Explorer tree.
Double click its alias.
or
Select the Database | Connect to Database menu item.
Disconnect from Database
To disconnect from a database
Select the database to disconnect from or any of its objects in the DB Explorer.
Select the Database | Disconnect from Database menu item.
.topic 10
The Create Database Wizard guides you through the process of creating a new database. To open the wizard select the Database | Create Database... menu item or click the Create Database button on the toolbar.
Setting the name for a new database
Setting database connection properties
Defining database files
Defining transaction log files
Viewing the result SQL statement
.topic 750
The Register Host Wizard allows you to register several databases from one host. To open the wizard select the Database | Register Host... menu item, or press Shift+Ctrl+R. You can also use the Register Host button on the main toolbar.
Setting connection properties
Selecting databases
Setting registration options
.topic 57
The New Object Dialog allows you to select an object type for creating and run the appropriate wizard or dialog. To open the dialog select the Database | New Object... menu item.
Select a database, where the new object should be created, from the Database dropdown list. Pick an object type icon and click the OK button to invoke the corresponding wizard or dialog.
.topic 170
Relational databases store all their data in tables. A table is a data structure consisting of an unordered set of horizontal rows, each containing the same number of vertical columns. The intersection of an individual row and column is a field that contains a specific piece of information. Much of the power of relational databases comes from defining the relations among the tables.
Create table
To create a new table:
Select the Database | New Object menu item.
Select Table in the New Object window.
Edit table properties and fields on the appropriate tabs of the New Table window.
Hint: To create new table you can also right-click the Tables node of the explorer tree and select the New Table... item from the popup menu.
To create a new table with the same properties as one of the existing tables has:
Select the Database | Duplicate Object menu item.
Follow the instructions of the Duplicate Object Wizard.
The Duplicate Object window allows you to select the database to create the new table in and to edit the result SQL statement for creating the table.
Edit table
To edit the existing table (manage its fields, indices, data, etc):
Select the table for editing in the explorer tree (type the first letters of the table name for quick search).
Right-click and select the Edit Table <Table_Name> item in the popup menu or simply double-click the table.
Edit table subobjects and data on the appropriate tabs of the Table Editor.
To change the name of the table:
Select the table for editing in the explorer tree.
Right-click and select the Rename Table <Table_Name> item from the popup menu.
Edit table name in the dialog window.
Drop table
To drop a table:
Select the table for editing in the explorer tree.
Right-click and select the Drop Table <Table_Name> item from the popup menu.
Confirm dropping in the dialog window.
.topic 207
Table Editor is the basic SQL Manager 2005 for SQL Server tool for working with tables. It allows you to create, edit and drop table's fields, indexes, foreign keys, and other table subobjects, manage table data, and much more.
To open a table in the Table Editor, just double-click it in the Explorer Tree (see Edit Table for details).
Using navigation bar
Managing table fields
Changing fields order
Managing table foreign keys
Managing table checks
Managing table indexes
Managing table triggers
Browsing object dependencies
Viewing table data
Editing table description
Viewing DDL definition
.topic 120
Assembly is a managed application module containing class metadata and managed code as an object in SQL Server, against which CLR functions, stored procedures, triggers, user-defined aggregates, and user-defined types can be created in SQL Server.
Create assembly
To create a new assembly:
Select the Database | New Object... menu item.
Select Assembly in the New Object dialog.
Edit assembly definition within the Assembly Editor.
Hint: To create new assembly you can also right-click the Assemblies node of the explorer tree and select the New Assembly... item from the popup menu.
To create a new assembly with the same properties as one of the existing assemblies has:
Select the Database | Duplicate Object... menu item.
Follow the instructions of the Duplicate Object Wizard.
Edit assembly
To edit the existing assembly:
Select the assembly for editing in the explorer tree (type the first letters of the assembly name for quick search).
Right-click and select the Edit Assembly <Assembly_Name> item from the popup menu or simply double-click the assembly.
Edit assembly definition and data on the appropriate tabs of the Assembly Editor.
To change the name of the assembly:
Select the assembly to rename in the explorer tree.
Right-click and select the Rename Assembly <Assembly_Name> item from the popup menu.
Edit assembly name in the dialog window.
Drop assembly
To drop a assembly:
Select the assembly to drop in the explorer tree.
Right-click and select the Drop Assembly <Assembly_Name> item from the popup menu.
Confirm dropping in the dialog window.
.topic 930
SQL Manager 2005 for SQL Server provides two powerful tools for working with the SQL queries: SQL Editor for editing the query text directly and Visual Query Builder for building queries visually.
Creating a new Query
To create a new query in SQL Editor:
Select Tools | New SQL Editor menu item.
Click Add new query button on the toolbar.
Edit the query text on the Edit tab of the SQL Editor.
To create a new query in Query Builder:
Select Tools | New Query Builder menu item.
Build the query on the Builder tab of Visual Query Builder.
Editing Query
To open a query in SQL Editor:
Select Tools | Show SQL Editor menu item.
Use the number buttons at the bottom of the area to find one of the previously edited queries. The last edited query is displayed automatically on opening the editor.
To load a query from an *.sql file click Load from file button at the navigation bar.
To open a query in Query Builder:
Select Tools | Show Query Builder menu item.
The last edited query is displayed on the Builder tab.
To load a previously saved diagram click Load Diagram item at the navigation bar.
To load a query from an *.sql file, open the Editor tab and click Load from file button at the navigation bar.
Executing Query
To execute a query:
Create a new query or open the existing one.
Click Execute query button on the toolbar of SQL Editor or Visual Query Builder respectively.
View/edit the returned data on the Results tab.
Saving Query
To save a query:
Create a new query or open the existing one.
Click Save to file item at the navigation bar of SQL Editor or Save query item at the Editor tab of Visual Query Builder respectively to save the current query to *.sql file.
Click Save diagram item at the navigation bar of the Builder tab of Visual Query Builder to save the designed diagram.
Click Save All button on SQL Editor toolbar to save all the opened queries to one file.
.topic 265
SQL Editor is the basic SQL Manager 2005 for SQL Server tool for creating and executing queries. It allows you to create and edit SQL text for a query, prepare and execute queries and view the results of execution.
To open SQL Editor select Tools | Show SQL Editor / Tools | New SQL Editor menu item or press F12 / Shift + F12.
Using navigation bar
Viewing query plan
Working with editor area
Using object links
Using popup menu
Executing query and viewing results
.topic 287
Visual Query Builder is provided for building queries visually. It allows you to create and edit queries without knowledge of SQL, prepare and execute queries, and view the results of execution.
To open Visual Query Builder, select Tools | New Query Builder or Tools | Show Query Builder menu item.
Using navigation bar
Working with diagram area
Joining two database objects by fields
Setting the selection criteria
Setting output fields for selection
Setting the grouping criteria
Setting parameters of sorting
Working with editor area
Executing query and viewing results
.topic 940
Table data and query results are displayed on the Data or Results tab of Table Editor, SQL Editor, Visual Query Builder, etc.
The data can be displayed in three modes: Grid View, Form View and Print Data. See Data View to learn more about these modes.
The toolbars of these tabs as well as the popup menus (activated by right-click on the grid) provide the following functions for managing data:
Export Data
Exports data to various formats, including MS Excel, MS Access, RTF, HTML, PDF and more.
Export As SQL Script
Exports data to the SQL script as a number of INSERT statements.
Import Data
Imports data from MS Excel, MS Access, DBF, TXT, and CSV.
Edit BLOB
Allows you to view and edit the content of BLOB and TEXT fields.
.topic 590
SQL Manager 2005 for SQL Server provides you with powerful tools for viewing, editing and printing data from tables and queries. This topic shows how you can work with data in the simplest and the most direct way.
Grid View
Form View
Print Data
.topic 650
SQL Manager 2005 for SQL Server provides BLOB Viewer/Editor to view and edit BLOB fields content. The BLOB Viewer/Editor can be invoked from the data grid within Table Editor, SQL Editor, Visual Query Builder, etc.
Navigating within the BLOB Viewer/Editor
Viewing/Editing BLOB field as hexadecimal dump
Viewing/Editing BLOB field as plain text
Viewing/Editing BLOB field as rich text (RTF)
Viewing/Editing BLOB field as graphical image
Viewing/Editing BLOB field as HTML
Applying changed to data
.topic 620
Export Data Dialog allows you to export data from table, view, procedure or query result to any available format. You can save your settings as a template at any time for later use.
To call the wizard right-click the table (view, procedure, etc.) in DB Explorer, select Data Manipulatiton and corresponding operation then. Another way is to select Data tab of Table Editor/View Editor, then corresponding menu item of the Data Management bar (navigation bar) or simply use context menu of the Grid -> Data Manipulation.
Setting name and format for destination file
Selecting fields for export
Adjusting formats applied to exported data
Setting header and footer text for destination file
Setting options according to the selected format
Setting common export options
.topic 640
Import Data Wizard allows you to import data to a table from MS Excel, MS Access, DBF, TXT or CSV file.
Setting source file name and format
Selecting source object for import data from
Setting the correspondence between the source and target fields
Adjusting common data formats
Setting advanced field formats
Setting import mode and data write type
Customizing common import options
.topic 630
Export as SQL Script Wizard allows you to export data from a table or a query result to SQL script as a number of INSERT statements.
To export data as INSERT from a table or a query:
open the table in Table Editor or open and execute query in SQL Editor or Query Builder;
open Data or Result tab respectively;
click Export as SQL Script item on the navigation bar.
Setting destination file name for the script
Selecting field to export
Editing result create statement
Specifying export options
.topic 720
BULK INSERT (Transact-SQL) loads a data file into a database table or view in a user-specified format. This statement copies data from a file to a table, appending the records to already existing data in the table. The file must be accessible to the server and the filename must be specified from the point of view of the server.
The Bulk Insert Wizard guides you through the bulk insert process.
To insert data to a table:
open the table in the Table Editor;
click the Bulk insert item on the Data Management bar.
or
click right mouse button on a table name
select Data Manipulation
click the Bulk Insert... item
Selecting data file and name of the table or view
Specifying bulk insert options
Selecting data file format
.topic 260
SQL Manager 2005 for SQL Server provides a number of powerful tools for working with the databases.
The following tools are available:
Dependency Tree
Allows you to view all the object dependencies in a one diagram.
Visual Database Designer
Allows you to lay out your database schema visually.
SQL Monitor
Displays all the SQL statements executed while working in SQL Manager 2005 for SQL Server.
SQL Script Editor
Executes SQL scripts to the database.
Extract Database Wizard
Extracts the table metadata to the SQL script, which can be later executed on another machine to reserve the database structure.
Print Metadata
Creates powerful metadata reports in the WYSIWYG mode, ready for printing.
HTML Report
Creates powerful metadata reports in the HTML format.
Report Designer
Allows you to build and print database reports
.topic 960
Visual Database Designer is provided for designing your database visually. It allows you to create, edit and drop tables and table fields, set links between tables, and so on.
To open the designer select the Tools | Visual Database Designer menu item.
Using navigation bar
Navigating on diagram
Adding objects to diagram
Removing objects from diagram
New object creation
Creating relationships
Working with multiple pages
Reverse engineering
Printing diagram
Saving/Loading diagram
Setting diagram options
.topic 380
Using SQL Script Editor, you can view, edit and execute SQL scripts. To open SQL Script Editor select the Tools | SQL Script menu item.
In the script area you can view and edit the SQL script text. For your convenience syntax highlight and code completion is enabled.
Using navigation bar
Using popup menu
Using script explorer
Note: SQL Script Editor doesn't show SELECT query results. Please use SQL Editor for that purpose instead.
.topic 390
Using the Extract Database Wizard you can extract database objects and data to the SQL script, e.g. for backup purposes. To open this wizard, select the Tools | Extract Database menu item.
Use the Templates... button to save the wizard configuration for future use or to load the previously saved configuration for faster extract.
Selecting database to extract
Specify destination script file name
Selecting components to extract
Selecting database objects to extract their structure
Selecting database objects to extract their data
Customizing script options
.topic 400
Print Metadata allows you to print the metadata of any database object. To open it select Tools | Print Metadata menu item.
Select the type of the database objects to print using buttons at the navigation bar. Move the objects from the Available objects list to the Objects for printing list using arrow buttons, by double-clicking or dragging them (multiple objects can be selected using buttons Ctrl and Shift).
.topic 950
HTML Report wizard allows you to generate a detailed HTML report about the selected database metadata. To open HTML Report wizard select the Tools | HTML Report menu item.
Select source database and output directory
Select type of database objects to extract
Specify Cascading Style Sheet for the report
Set additional parameters
.topic 1210
The Report Designer allows you to create and edit reports. This tool can be opened after completion of Create Report Wizard to design a new report. To edit already existing project use the appropriate Report Viewer navigation bar item.
This module is provided by FastReport (http://www.fast-report.com) and has its own help system. Press F1 key in the Report Designer to call the FastReport help.
Please find below the instruction on how to create a simple report in the Report Designer:
Adding dialog form
Adding database component
Adding query component
Adding fields to the report
Viewing the report
Note: The Object Inspector that allows you to edit report object properties, can be opened by pressing the F11 key.
.topic 370
SQL Monitor allows you to view the SQL code of all the operations executed over databases and database objects in SQL Manager 2005 for SQL Server. The content of the window can't be edited, but can be copied to the clipboard, saved to a text file or printed.
To open the SQL Monitor window, select Tools | SQL Monitor menu item.
Using navigation bar
Using popup menu
.topic 970
SQL Manager 2005 for SQL Server provides Login Manager for adding, deleting users, and editing global user privileges, and Grant Manager for granting privileges on the selected databases, tables and fields.
'Global' user privileges define the user access rights to all the database tables on the server. Granting privileges on the selected databases, tables or fields allows user to perform the defined operation (select, update, insert) over all the tables of the selected database, over the selected tables or over the selected fields only.
Adding User
To add a new user:
Select the Tools | User Manager menu item.
Click Add User button in Login Manager
Edit user within User Editor.
Editing User Properties
To edit user properties:
Select the Tools | User Manager menu item.
Select a user to edit his privileges in Login Manager window.
Click Edit User button.
Edit user privileges within User Editor.
Managing User Grants
To define user grants for database objects:
Select the Tools | Grant Manager menu item.
Select the database host from the drop-down list on Grant Manager toolbar.
Edit database privileges within the Grant Manager.
Deleting User
To delete a user:
Select the Tools | User Manager item.
Select a user to delete in Login Manager window.
Click Delete User button.
Confirm deleting in the dialog window.
.topic 410
Login Manager is provided for administering users and their global privileges.
To open Login Manager select the Tools | Login Manager menu item.
Connecting to host
Using User Editor
.topic 420
Grant Manager allows you to set the user access grants for certain databases, tables, views, functions, sequences, schemas, tablespaces and languages.
To open Grant Manager select the Tools | Grant Manager menu item.
Managing database-specific privileges
Viewing granted objects only
.topic 480
SQL Manager 2005 for SQL Server provides graphical wizard interface for all native SQL Server services, which are intended for database and table maintenance. To make your work with the server easier SQL Manager 2005 for SQL Server also provides some graphical tools for working with the server as a whole.
The following services and server tools are available:
Attach Database
Detach Database
Backup Database
Restore Database
Backup devices
DTS Packages
Jobs
Job History
Alerts
Operators
.topic 510
SQL Manager 2005 for SQL Server provides attaching of an existing database that is made up of one or more files to the instance of MS SQL Server.
To open the Attach Database Wizard select the Services | Attach Database menu item.
.topic 540
SQL Manager 2005 for SQL Server provides detaching of a database from the instance of MS SQL Server.
.topic 440
Environment Options allow you to customize general SQL Manager 2005 for SQL Server options. To open the Environment Options window select the Options | Environment Options menu item.
Preferences
Confirmations
Windows
Tools
Timeouts
DB Explorer
Naming Rules
Object Editors
SQL Editor
SQL Monitor
SQL Script
Query Builder
Print Metadata
Data Export
Fonts
Grid
Data Options
Print Data
Color & Formats
Advanced
Column Options
Localization
.topic 980
Show splash screen on startup
Displays the splash screen on SQL Manager 2005 for SQL Server startup.
Save desktop on disconnect
Saves all the database windows and their positions on disconnecting from the database.
Disable multiple instances
Prohibits running multiple instances of SQL Manager 2005 for SQL Server.
Encrypted passwords
Encrypts passwords for connecting to databases in the Windows registry.
Show desktop panel (for MDI Environment style only)
Displays the Desktop Panel when no windows are open.
.topic 1020
Confirm saving of object
If this option is on, the program requires confirmation each time you want to save changes in database object.
Confirm dropping object
If this option is on, the program requires confirmation for dropping database object.
Confirm exit from SQL Manager 2005 for SQL Server
If this option is on, the program requires confirmation when you want to exit SQL Manager 2005 for SQL Server.
Confirm transaction commit
If this option is checked, the program requires confirmation of the transaction commit.
Confirm transaction rollback
If this option is checked, the program requires confirmation of the transaction rollback.
Confirm metadata changing
If this option is on, the program requires confirmation of metadata changing (See Changing Metadata window).
Table altering operations performed via recreation
This option defines SQL Manager 2005 for SQL Server behavior when it is needed to recreate able to perform requested changes with it.
Enabled - such operations will be available without warnings.
Enabled, show warning - the warning window will appear if chosen operation requires table recreation.
Disabled - deny this type of operations.
.topic 1030
Environment Style
This switch allows you to define the basic window environment - MDI (like MS Office) or Floating Windows (like Borland IDE).
Windows restrictions
This option allows you to set the number of editors (Table Editor, SQL Editor, etc.) that can be opened at a time.
Zoom options
This option is available only if Environment Style is 'Floating-windows environment'. It allows you to set the window maximization size: full screen, restricted by main form, restricted by main form and DB Explorer.
Bar style for child forms
Allows you to define the location of action buttons. They can be located at the Navigation bar at the left and/or on the Toolbar.
You can also Enable floating toolbars feature by clicking the appropriate option.
.topic 990
Show only connected databases in drop-down menu
Displays only connected databases in the dropdown menus of such tools as: QueryBuilder, SQL Script, etc.
Allow using parameters in query text
This feature allows you to specify different values within a query in a popup dialog just before the query execution. Use the colon (':') character before some identifier (e.g. :P1) to specify a parameter within a query.
Use transactions in Data tab of object editors, SQL Editor and Query Builder
If this option is on, the transaction is active until the Data tab is closed or the Commit button is pressed; all edited records are blocked until the transaction commit. If this option is off, then the transaction starts and immediately commits (autocommit) on saving each record, which is blocked only for a short time period.
Use shared connection for each data view within a database
Uncheck this option to use separate connection for each data view within a database. Note that this option is only available when Use transactions in Data tab of object editors, SQL Editor and Query Builder is unchecked.
Asynchronous query execution
Check this option to allow executing a query in background mode.
Don't fill server lists in connection forms
If this option is checked, server list will be filled up with the names of most recently used servers, which are stored locally in the Windows registry. Otherwise, SQL Manager 2005 for SQL Server will scan the network to fill in the server lists in connection forms. Otherwise,
.topic 1000
System font name
Defines the font name used by SQL Manager 2005 for SQL Server.
System font size
Defines the font size used by SQL Manager 2005 for SQL Server.
The box below displays the sample text using the selected font.
.topic 1010
General options
Striped Grids
Displays the odd grid rows in a different color, defined by the Stripy option.
Show editor immediately
Allows editing the cell value right after the cell is clicked.
Always show editor
Set this option to make the cell editors always active.
Enable auto-search in grid
Set this option to enable start typing and have the grid automatically navigate to the closest match.
Row multi-selection
With this option set, multiple rows can be selected.
Column auto-width
With this option set, column widths are changed in order to display all columns without using the horizontal scrollbar. If a column's content is still too large to display without the grid needing to resize, then the column's values are truncated and the hidden characters are replaced with an end ellipsis.
Cell auto-height
If the widths of the columns are insufficient to display the full content, then text clipping occurs. Set this option to prevent this. If this option is set, the cell content is displayed in multiple lines where necessary. You can set the number of lines to display using Cell max line count option.
Limit options in table editor
Select all records
Selects all the records from the table, no matter how many records there are in it.
Select only
Select only fixed number of records on opening Data tab.
Records
This edit box is available only if Select only option is selected. It defines the maximum number of records, selected from the table at a time.
Grid layout preference
Select Save and restore layout option to keep the original grid width. Select Autofit column widths option to shrink the grid columns so that the longest visible column value fits.
Root level options
These options are applied to the main view of the grid. See Grid View for details.
Detail level options
These options are applied to the detail view of the grid. See Grid View for details.
Show "Group by" box
Displays a box above the column captions allowing to group data in the grid.
Show indicator
Displays the row indicator.
Show navigator
Activates/deactivates the data navigator. This navigator is displayed at the bottom of a view.
Show "New item row"
Displays an empty row at the top of a view, which is a convenient way for adding data to the grid.
Hide tabs for single detail
This option is actual when only one view is present on detail level. When checked, it hides the view tab.
.topic 1040
The Localization page is provided for managing the SQL Manager 2005 for SQL Server localization files.
You can create your own *.lng files similar to those, available in the $(SQL Manager 2005 for SQL Server)\Languages folder, add them to the list of available languages on this tab and set the new language as a program interface language.
Default directory
The default directory for adding the new *.lng files.
Choose program language
Selects the program interface language.
Available languages
Lists all the languages available for localization and the corresponding *.lng files. Double-click a language in the list to edit its name or *.lng file.
Add defaults
Searches in the Default directory folder for the *.lng files and adds all them to the list.
Add
Opens the Language Editor dialog for adding a new language file.
Edit
Opens the Language Editor dialog for changing the name or the corresponding *.lng file of the language selected in the Available languages list box.
Delete
Removes the language selected in the Available languages list box.
.topic 450
Editor Options allow you to set the parameters of viewing and editing the SQL statements within SQL Manager 2005 for SQL Server. To open the Editor Options window select the Options | Editor Options menu item.
General
Display
Color
Quick Code
SQL Formatter
Key Mapping
.topic 770
This window allows you to customize the application interface style to your liking. To open this window select the Options | Visual Options menu item.
Use Scheme Name to select the interface scheme you like: Office XP style, Windows XP native style, etc. You can create your own interface schemes by customizing any visual options you like on the appropriate tabs (Bars and Menus, Trees and Lists, Edit Controls, Check Boxes, Buttons, etc.) and clicking the Save As button.
All the customizing you make is displayed on the Sample panel.
Bars and menus
Trees and lists
Edit controls
Check boxes
Buttons
Page controls
Group boxes
Splitters
Navigation bar
.topic 470
The Keyboard Templates window allows you to create new keyboard templates for quicker typing regularly met expressions and to edit the existing ones. To call this window select the Options | Keyboard Templates menu item from the popup menu.
You can deactivate the existing template by choosing it from the list at the left of the window and removing flag from its name. Also you can edit template name, using button Edit, delete a template, using button Delete and edit template expression in the right part of the window. For faster editing you can use buttons Cursor Position, Author, Time, Date.
To add a new template, click Add, set the template name and define the template expression. In the upper left corner of the window you can choose the case of the template expression.
.topic 820
Save Settings Wizard allows you to export SQL Manager 2005 for SQL Server settings wholly or partially to a single *.reg file, which you can apply to SQL Manager 2005 for SQL Server installed on another machine or use to backup previous settings. To open the wizard select the Options | Save Settings menu item.
Specifying destination file
Selecting settings
Selecting databases
Saving settings
.topic 1050
You can add external programs to SQL Manager 2005 for SQL Server to make it more effective.
Adding External Tool
To add an external program:
Select the Options | External Tools menu item.
Click Add... button in the External Tools dialog.
Click the button next to the Program box to select the program *.exe file, or set the program execution file manually in this box.
Set the program title, hot key, working directory and execution parameters if necessary in the proper boxes of the External Tool Info Editor.
Click OK in the External Tool Info Editor and External Tools dialogs.
This adds the icon and the title of the program you selected to the Tools | External Tools submenu. Now you can run this tool quickly without stopping work with MySQL Manager.
Removing External Tool
To remove an external program:
Select the Options | External Tools menu item.
Select the tool to remove from the Tools list in the External Tools dialog.
Click Delete button.
Click OK to confirm removing the tool and closing the dialog.
The selected tool is removed and is no longer accessible from the Tools | External Tools submenu.
.topic 460
The External Tools window allows you to add executable programs to the Tools | External Tools menu to access them quickly from SQL Manager 2005 for SQL Server. To call this window select the Options | External Tools menu item.
Tools
Lists all added external tools.
Add
Opens External Tool Info Editor for adding a new tool.
Edit
Opens External Tool Info Editor for editing title, .exe file, hot key, working directory or execution parameter of the tool, selected in the Tools list box.
Delete
Removes the selected tool from the list of SQL Manager 2005 for SQL Server external tools.
To change the order of tools in the list use the arrow buttons below the list box or press buttons Shift+Ctrl+Up / Shift+Ctrl+Down on the keyboard. You can also drag items in the list box to change their positions.
.topic 1180
The External Tool Info Editor window allows you to set the parameters of calling the external program from SQL Manager 2005 for SQL Server. This window is available on adding or editing the external tool (see Add External Tool and External Tools).
Title
Title displayed in the Tools | External Tools submenu for calling the tool.
Hot Key
Press a key or a key combination on the keyboard to set it as a hot key for the tool.
Program
Full path to the program *.exe file.
Working Dir
Program default directory.
Parameters
Parameters for executing the program.
.topic 1080
SQL Manager 2005 for SQL Server provides multi-language interface support. You can change the program language easily, edit existing localizations, and create your own localization files.
Changing Program Language
To select the program interface language:
Select the Options | Select Program Language menu item.
Select the interface language in the Select Program Language dialog.
Click OK to close the dialog.
Editing Program Localization
To edit the interface localization:
Open one of the program windows (e.g. Table Editor, SQL Editor) to edit the localization of its captions and hints.
Press Shift+Ctrl+L on the keyboard to open Localization Editor window.
Edit window captions and hints as you like.
Click Save button on the toolbar.
Note, that the Localization Editor window is available only if the selected language is different than default.
Creating New Localization
To create a new localization:
Create a new localization file similar to one of those situated in the $(MySQL Manager)\Languages folder.
Select the Options | Environment Options menu item.
Open the Environment Options | Localization dialog tab.
Click Add button on this tab.
Set the language name and the path to the new *.lng file in the dialog window.
The new language is added to the list of available languages. Now you can set it as a program interface language via the Select Program Language dialog or the Localization tab of the Environment Options.
.topic 1090
The Localization Editor window allows you to edit the captions and hints of any SQL Manager 2005 for SQL Server window, if the selected program language is different than default.
To call this window just press Shift+Ctrl+L in any SQL Manager 2005 for SQL Server window.
All the window text consists of the element names and the corresponding strings, divided by the '=' character. These strings are what you see in the program as menu items, window captions, button hints, etc. Edit them to change the program appearance. Don't edit anything that stands before the '=' character - this will not produce any effect.
For your convenience we have provided Find and Replace buttons on the toolbar, which call the Find Text Dialog or the Replace Text Dialog respectively. The Search Again button enables the repeated search for the text last searched.
When you are done with editing click Save button on the toolbar to apply the changes you have made.
.topic 477
The Select Language dialog allows you to select a language for SQL Manager 2005 for SQL Server localization.
To call this window select the Options | Select Program Language menu item.
The window displays the list of available languages, set in the Environment Options | Localization. Select the proper interface language and click OK.
.topic 610
The Find Text Dialog is provided for quick searching for the text in the editor window.
Text to Find
Enter a search string. To select from a list of previously entered search strings, click the down arrow next to the input box.
Case Sensitive
Differentiates uppercase from lowercase when performing a search.
Whole words only
Searches for words only. (With this option off, the search string might be found within longer words.)
Regular Expressions
Recognizes regular expressions in the search string.
Forward
Searches from the current position to the end of the file.
Backward
Searches from the current position to the beginning of the file.
Global
Searches the entire file, in the direction specified by the Direction setting.
Selected text
Searches only the selected text, in the direction specified by the Direction setting. You can use the mouse or block commands to select a block of text.
From cursor
The search starts at the cursor's current position, and then proceeds either forward to the end of the scope, or backward to the beginning of the scope depending on the Direction setting.
Entire scope
The search covers either the entire block of selected text or the entire file (no matter where the cursor is in the file), depending upon the Scope options.
.topic 1150
The Replace Text Dialog is provided for searching and replacing text in the editor window.
Text to Find
Enter a search string. To select from a list of previously entered search strings, click the down arrow next to the input box.
Text to Replace
Enter the replacement string. To select from a list of previously entered search strings, click the down arrow next to the input box. To replace the text with nothing, leave this input box blank.
Case Sensitive
Differentiates uppercase from lowercase when performing a search.
Whole words only
Searches for words only. (With this option off, the search string might be found within longer words.)
Regular Expressions
Recognizes regular expressions in the search string.
Prompt on replace
Prompts you before replacing each occurrence of the search string. When Prompt on replace is off, the search string is replaced automatically.
Forward
Searches from the current position to the end of the file.
Backward
Searches from the current position to the beginning of the file.
Global
Searches the entire file, in the direction specified by the Direction setting.
From cursor
The search starts at the cursor's current position, and then proceeds either forward to the end of the scope, or backward to the beginning of the scope depending on the Direction setting.
Entire scope
The search covers either the entire block of selected text or the entire file (no matter where the cursor is in the file), depending upon the Scope options.
Replace All
Click Replace All to replace every occurrence of the search string. If you check Prompt on replace, the confirmation dialog box appears on each occurrence of the search string.
.topic 600
The To-Do List window allows you to make up a list of tasks for the database. To call this window select the View | To-Do List menu item.
Click the Add Item button to add a task to the list. Fill in the fields of Add To-Do Item dialog window:
Text
Optional text describing the task.
Priority
The priority of the task: not negative integer.
User Name
User name this task is applied to.
Category
The task category. You can set optional text or choose one of the given categories here.
Click 'OK' to add the new task to the list.
Choose a task from the list and click the Edit Item button to edit it.
The Delete Item button deletes the Selected task from the list.
Click the Delete All button to clear the task list. Confirm it in the dialog window and all the tasks will be deleted.
Database Select Field
Select the database to apply the task list to. When switching between the databases you can view different task lists.
The task list is displayed in a form of a grid. Its columns (Action, Priority, User, Category) correspond to the task parameters. Clicking left mouse button at the column title allows you to enable sorting by the current parameter or change the sorting direction.
Clicking right mouse button in the window area activates popup menu, which allows you to add a task to the list, edit or drop current task, and clear the task list.
.topic 1160
The Customize Toolbars window allows you to select the buttons displayed on the MySQL Manager toolbars and change their positions.
To call this window, click the down-arrow button at the right-side of any toolbar, then click Add or Remove Buttons and select Customize.
Toolbars
Toolbars
The toolbars of the window from which the Customize was called. Click a box near the toolbar name to show or hide the toolbar.
New
Adds a new toolbar to the toolbar list and to the parent window.
Rename
Renames a user-created toolbar.
Delete
Deletes a user-created toolbar.
Commands
This tab allows you to view the list of all the commands available within toolbars of the parent window. Selecting categories in the Categories list box displays commands of the selected category (e.g. 'Database' or 'Tools') in the Commands list box. You can pick a command and drag it on any parent window toolbar to create a button for this command.
Options
Menus show recently used commands first
With this option on the parent window menus drop-down containing only several items available, which have been used recently. To display full menus unselect this option.
Show full menus after a short delay
This option is available only if Menus show recently used commands first is on. It displays full menus after a few seconds of showing only recent items.
Reset my usage data
Resets the lists of recently used commands in the toolbars and menus.
Large Icons
Displays larger icons on the parent window toolbars.
Show ToolTips on toolbars
Shows tips on navigating to the toolbar button.
Show shortcut keys in ToolTips
Shows shortcuts for faster activating the corresponding commands in the button tips.
Menu animations
Select how menus appear in the parent window.
.topic 1190
The Language Editor window allows you to set the name and the corresponding *.lng file for the localization language. It is available on adding or editing the language (see Environment Options | Localization).
Language Name
The name of the language displayed in the Select Program Language dialog and on the Environment Options | Localization tab.
Language File
The *.lng file containing the translated string resources. See $(MySQL Manager)/Languages folder to find already existing localization files.
