3.0.185 15-Apr-13
- The problem with the temporary table on schema synchronizing is fixed
(T66662, T69085, T69895, T69951)
- The problem with procedure's dependencies determination on schema comparison is
fixed (T67595)
- InvalidOperationException on executing a script is fixed (T69522)
- ArgumentException on saving command line arguments in the Data Comparison wizard
is fixed (R20898)
3.0.180 09-Apr-13
- Database Diagram is included in the Standard edition without any limitations now
- The problem with saving the Splitting options is fixed (T60064)
- InvalidOperationException on executing a script is fixed (R17828)
- NullReferenceException on debugging a procedure is fixed (T67893)
- NullReferenceException on closing the procedure editor after debugging is fixed
(R19529)
- The problem with changing options for code editor is fixed (T65707)
- Incorrect behaviour on synchronizing a function in Schema Comparer is fixed (T66941)
- NullReferenceException on trying to find a search pattern in a document is fixed
(R19287)
- InvalidOperationException on editing data in Data Editor is fixed (T67547)
- The problem with connection to TFS 11 is fixed (T61250)
- ArgumentOutOfRangeException on saving changes in the procedure editor is fixed (T66641,
T69375, T69490)
- The problem with the name of a temporary table is fixed (T66662, T69085)
- The problem with punctuation's visibility in code editor with black background being
set is fixed (T65696)
- NullReferenceException on executing a script is fixed (T65230)
- Syntax error on executing the current statement using the Execute Current Statement
command is fixed (T68993)
- Problems with mixed case named indexes are fixed (T66552, T68265)
- Wrong displaying of NULL values in comparison reports is fixed (T68678)
- NullReferenceException on choosing invalid file as a snapshot file is fixed (R18487)
- Syntax error on executing a script with @@ variables is fixed (T62139)
- The problem with using store procedures as Custom Query in data comparison is fixed
(T66152)
- NullReferenceException on switching to the Mapping page in the Data Comparison wizard
is fixed (T66404)
- The problem with saving a comment in the table editor is fixed (T65161, T66267)
- OverflowException on scrolling a database diagram is fixed (T66729)
- The error on choosing a snapshot in the Schema Comparison wizard is fixed (T66590,
T67465)
3.0.161 16-Jan-13
- NullReferenceException on comparing schemas of SQL Azure is fixed (T65593)
- Error on default schema mapping is fixed (R17170)
3.0.160 15-Jan-13
New Features
Ability to create primary fields that are not IDENTITY fields is added.
User reported bug fixes
- ArgumentException error on clicking Save As My Defaults in the synchronization wizard
is fixed (T64077)
- Problem with displaying options in the Data Import wizard is fixed (T63344)
- Saving of changes in object mapping to *.dcomp files is fixed (T63179, T63753)
- ArgumentException on describing view columns is fixed (T38076)
- Error on searching stored routines names of which contain the '_' symbol is fixed
(T62907)
- NullReferenceException on pressing Ctrl+Shift+Z on a diagram is fixed (T16602)
- NullReferenceException on calling 'Edit source object' on the schema comparison
page is fixed (R15128)
- The SqlTypeException on executing stored procedure with data entered out of the
permissible range is fixed (T64333)
- The error on working with Team Foundation Server is fixed (T61250)
- NullReferenceException on setting 'Computed' for columns on diagram is fixed (R16496)
- InvalidCastException on double-clicking a table in Database Explorer is fixed (T64179)
- NullReferenceException on double-clicking an element in Suggestions List is fixed
(T61512)
- Error on generating script for indexes is fixed (R13720)
- Error on setting alias name in upper case is fixed (R15105)
- NullReferenceException in Query Builder is fixed (T62199, T63974)
- Incorrect tables comparison when the 'Ignore Unique Key' option is on is fixed (R15118)
- NullReferenceException error on comparing schemas of backup copies is fixed (R15144)
- NullReferenceException on editing roles is fixed (R15126)
- InvalidCastException on editing views is fixed (T59437)
- Error connected with absence of a table on a diagram if this table is available
in the database is fixed (R16585)
- Error on generation of incorrect schema synchronization script when an account with
restricted rights is used is fixed (T63740)
- NullReferenceException on opening a *.dcomp file is fixed (T65066)
- NullReferenceException error on creating a SELECT query in Query Builder is fixed
(T63549)
- Error 8623 on schema comparison is fixed (T39594)
- The 'Cannot browse data in Master-Detail' error is fixed (T59563)
3.0.136 08-Nov-12
- SQL Server 2012 LocalDB is now supported (R14621)
- Schema comparison performance is improved (T39594)
- Synchronization of procedure with dependencies is fixed (R11464)
- ArgumentException on opening a file through the command line is fixed (T45824)
- ArgumentException on synchronizing databases in Schema Compare is fixed (T50581,
T59826, T60281)
- Application's hanging when comparing snapshots is fixed (T51789)
- TargetInvocationException in the Schema Comparison wizard is fixed (R13555)
- Incorrect creating of foreign keys is fixed (T59065)
- Incorrect trial on Windows 8 is fixed (T59119, T59496, T59563, T59698, T59827, T59847)
- ArgumentNullException on finding the next occurence in text is fixed (R13847)
- NullReferenceException on profiling a query is fixed (T59489)
- Old warnings that occured during comparison are removed now (T59484)
- Incorrect values on generating DELETE statements in Data Compare are fixed (T59583)
- NullReferenceException on searching a text in SQL document is fixed (T59700)
- Option "Disable Check Constraints" is saved in the Data Comparison document now
(R14047)
- NullReferenceException on applying the filter and removing it after refresh in the
Schema Comparison document are fixed (T59720)
- NullReferenceException on opening recent Schema Comparison document is fixed (T59751)
- TargetInvocationException on getting schemas with insufficient privileges in the
Schema Comparison wizard is fixed
- Incorrect behaviour on saving a procedure with errors in its text is fixed (T59939)
- Error on saving a valid procedure with table variable in its text is fixed (T60026)
- Incorrect error positions in object editors are fixed (T60129)
- NullReferenceException on saving Data Comparison document is fixed (T60313)
- Incorrect behaviour on saving stored procedure is fixed (R14530)
- Non-working command line on operating systems with only .NET Framework 4 installed
is fixed (T61027)
- ComponentNotRegisteredException on comparing data with a backup as a source or target
is fixed (T61163)
- Incorrect behaviour with specifying file groups in synchronization scripts is fixed
(T60183)
- Use ALTER will be used instead of DROP/CREATE for stored procedure in all editing
features (R13499)
- Incorrect saving of the length of a column in Column Editor is fixed (T60382)
- InvalidOperationException on refreshing nodes in Database Explorer with opened Database
Diagram document is fixed (T60588)
- Losing privileges on source objects after editing or synchronizing databases in
Schema Compare is fixed (T59672)
- InvalidOperationException on closing a connection with invalid transaction is fixed
(R14818)
3.0.117 18-Sep-12
- ArgumentException in Pivot Table with spatial data types is fixed (R13561)
- Incorrect feedback URL in main menu is fixed (R13578)
- NullReferenceException on creating DDL trigger in the object editor is fixed (R13560)
- Incorrect behaviour with table functions in Query Builder is fixed (R13570)
- InvalidOperationException on opening the mapping page in Data Export wizard is fixed
(R13552)
- NullReferenceException on opening Data Viewer window in Data Editor is fixed (R13608)
3.0.114 13-Sep-12 (first release of dbForge Studio for SQL Server)
Data Studio for SQL Server is now known as dbForge Studio for
SQL Server and incorporates such tools as SQL Complete, Data Studio,
Schema Compare, Data Compare and Query Builder for SQL Server.
Product Editions
dbForge Studio for SQL Server comes in 4 editions:
- Free Express edition with basic functionality for database development
- Standard edition extends the Express edition's functionality with
T-SQL Debugger, Query Profiler, advanced SQL Coding Assistance features, etc.
- Professional fully-featured edition that provides additional functionality
- Data edition includes all the functionality of the discontinued
Data Studio for SQL Server
Major New features
- Table Designer:
- Visual editors for table properties
- Editor for table creation script
- Rebuild tables when complex changes are introduced
- Preview changes before modifying a database object
- Database Diagram:
- Visual editing, easy manipulation and scaling
- Containers for grouping objects
- Printing large diagrams
- Virtual connections
- T-SQL Debugger integrated into the stored procedure editor allows
to start debugging from the Database Explorer tree
- Query Profiler for locating bottlenecks and optimizing query execution
time with advanced options unavailable in a standard tool
- Security Manager that incorporates visual editors for logins, users,
and roles; batch object editing, etc.
Other features
- Generate Script As in Database Explorer feature added
- Procedure, function, synonym and sequence editors added
2.0.47 18-Jul-12 (last release of dbForge Data Studio for SQL Server)
- Error while running Microsoft SQL Server Management Studio is fixed(T39149)
- Error "Object cannot be cast from DBNull to other types" on SQL server 2012 is fixed(T42098)
- Start page scrolling bug is fixed
- Problem with report generating is fixed(T41645)
- Error "Key cannot be null" is fixed(T41340)
- "Create synonym with default schema" bug is fixed
- Error "Incorrect syntax near..." during search object is fixed(T40345)
- Problem with creating report using .rdb file is fixed
- Error "Object cannot be cast from DBNull to other types" is fixed(T40064)
- Problem with messages in trial is fixed
2.0.35 27-Apr-12
- Some corrections in documentation are made (T34205)
- Incorrect warning message during synchronization is fixed (R9043)
- ArgumentException on importing data from MS Excel 2007 is fixed (T34901)
- Other small fixes in different features are made
2.0.17 05-Apr-12
Second release of dbForge Data Studio for SQL Server comprises a lot of experience
and a huge effort that was made to turn our product into the indispensable assistant
for application developers that use SQL Server.
SQL Intellisense
Taking into account our users needs and expectations we have integrated the functionality
of SQL Complete Express Edition into dbForge Data Studio for SQL Server. Owing to
that, the new release introduces users to the following enhancements:
- Context-sensitive code completion and object suggestions for SELECT, DML, DROP,
EXEC, SET, and USE statements
- Smart filtering of the suggestion list based on user input
- Parameter information for functions
- Quick object information available from SQL editor
- SQL formatting with rich options (limited to the set of statements mentioned above)
- A few other minor features
Query builder can now work with INSERT, UPDATE, and DELETE statements
Thanks to the Visual Query Builder users can create INSERT, UPDATE and DELETE statements.
Together with extending the types of edited queries, we have improve general usability
of the tool and fixed many bugs.
The updated query builder facilitates the process of creating queries and makes
it even more intuitive.
Automated data report delivery
This feature enables users to set an automatic data report generation and delivery
to a requester.
Reports' generation and delivery setup can be executed in the command line, providing
an opportunity to use Windows scheduler for regular reports generation (Setup of
report's generation and delivery can be executed in the command line, providing
an opportunity to use Windows scheduler for regular reports generation):
- A format for report generation can be chosen
- "Report delivery" method can be chosen: e-mail, ftp, shared folder
Data export to SQL statements
- Possibility to export data to INSERT, UPDATE, and MERGE statements
- Ability to export data from a table or data grid using a wizard
- Quick export from data grid without opening wizard
Data Compare
- New extended data reports
- Custom query result comparison ( the results of specific queries can be compared)
- "One-to-many" objects mapping when addressing columns that were separated as a table
in the target database
- Possibility to include objects into comparison by mask, which is useful when comparing
groups of tables
- Improved analysis of comparison results
- Improved data synchronization
Convenient work with result sets of several SELECT queries
If there is more than one SELECT statement in a document, query results will be
displayed on separate tabs in the Data window after execution.
SQL Server 2012 and SQL Azure Support
New release of Data Studio includes full support for new version of SQL Server and
functionality allowing users to work with Microsoft Cloud SQL services, knows as
SQL Azure.
Other improvements
User interface skins support is added
1.00.134 28-Apr-11
- ArgumentNullException on refreshing database list in Data Import Wizard is fixed
(T28123)
1.00.133 08-Apr-11
- Saving of columns aliases in Data Export template files fixed (T27551)
- Incorrect drawing of some UI elements on x64 systems fixed
1.00.129 09-Mar-11
- The problem with Data Editor on Microsoft Windows 2000 fixed (T26756)
1.00.128 16-Jan-11
- The problem with updating the Standard edition fixed (T26317)
1.00.127 12-Jan-11
- NullReferenceException on opening a large SQL file fixed (T25207)
- NullReferenceException on applying a custom filter in Data Editor fixed (T25168)
- NullReferenceException on editing a subquery in Query Builder fixed (T25205)
- Incorrect behaviour on pressing Ctrl+End to fetch all data in Data Editor fixed
(58046)
1.00.123 20-Dec-10
- Fixed the problem with empty column names in Data Editor on executing SELECT statements
(57826)
- Fixed UI defects in the Data Editor navigator (56597, 57124)
- Fixed NullReferenceException on opening a file with a database report in IDE without
any connection (57828)
- Fixed problem of layout removing on uninstall when the corresponding option is enabled
(57829)
- Now DML triggers are displayed with schema names in Database Explorer (57831)
- New logo is added in Data Report wizard (57832)
- Fixed incorrect behaviour on drag-and-droping synonyms on Query Builder (57825)
- Fixed NullReferenceException on switching the search mode in the Find Objects window
when no connections exists in Database Explorer (57843)
- Fixed NullReferenceException on executing changed SQL statement and showing data
in Data Editor (57845)
- Fixed automatic disabling of server-side operations if such operations are not valid
for SQL Server (57846)
1.00.117 16-Dec-10
First release of dbForge Data Studio for SQL Server
© 2010-2013 Devart. All rights reserved.