134 results found
-
Refactoring of existing queries
Especially: renaming table aliases. Other suggestons:
adding aliases, adding or removing AS keywords, replacing aliases with table names or vice versa, removing 'redundant' aliases or table names.18 votesWe would like to let you know that we have released dbForge Studio for SQL Server, v3.8 Beta where the feature you reported is implemented.
http://www.devart.com/dbforge/sql/studio/download.html
Thank you for your help in improving dbForge Studio for SQL Server. -
36 votes
We would like to let you know that we have released dbForge Studio for SQL Server, v3.8 Beta where the feature you reported is implemented.
http://www.devart.com/dbforge/sql/studio/download.html
Thank you for your help in improving dbForge Studio for SQL Server. -
Data generator
Redgate does a data generator that is quite useful. It looks at the schema for the tables and generates randomized (according to rules that you can select) data to fill them. It is quite useful when you need to say generate 100,000 rows for testing.
28 votesData Generator is available in dbForge Studio for SQL Server, v4.5. Feel free to leave a feedback.
-
Backup / Restore database
Implement the ability to backup and restore databases just like in dbForge Studio for Oracle and dbForge Studio for MySQL.
23 votesWe would like to let you know that we have released dbForge Studio for SQL Server, v3.8 Beta where the feature you reported is implemented.
http://www.devart.com/dbforge/sql/studio/download.html
Thank you for your help in improving dbForge Studio for SQL Server. -
Support SourceGear Vault
Its website is at: http://sourcegear.com/
5 votes -
Ability to select between several color schemes for SQL document
Implement at least two color schemes dark and bright so when changing to the dark scheme, a user is to be able to quickly change the text color as well.
5 votesWe would like to let you know that we have released dbForge Studio for SQL Server, v3.8 Beta where the feature you reported is implemented.
http://www.devart.com/dbforge/sql/studio/download.html
Thank you for your help in improving dbForge Studio for SQL Server. -
Ability to generate insert/update stored-procedures for given table
I like to right click a table name and dbforge should produce a stored procedure for insert/update out of it, like
CREATE PROCEDURE tblTest1_IU @id Int, @[user] Int, @stamp DateTime2(6) AS BEGIN IF EXISTS ( SELECT * FROM dbo.tblTest1 WHERE id = @id) UPDATE dbo.tblTest1 SET [user] = @[user], stamp = @stamp WHERE id = @id ELSE INSERT INTO dbo.tblTest1 ( id, [user], stamp) VALUES ( @id, @[user], @stamp) END
41 votes -
Provide the ability to export data in MS Excel 2010 format.
more than 65000 recordes can be experted in csv format files, but they cannot cope with ' or " is text fields.
4 votesThis feature is implemented in the new version 4.0 of dbForge Studio for SQL Server http://www.devart.com/dbforge/sql/studio/download.html
-
Copy database from one server to another
SQL Server 2000 had an option that allowed you to copy a database from one server to another. This option copied schema and data all in one move. We used the option frequently to copy production databases from production to development servers. Your software can do this, but requires several steps.
1 voteWe would like to let you know that we have released dbForge Studio for SQL Server, v3.8 Beta where the feature you reported is implemented.
http://www.devart.com/dbforge/sql/studio/download.html
Thank you for your help in improving dbForge Studio for SQL Server. -
Export Database to SQL
Add an ability to export database schema and (optionally) data to an SQL script.
33 votesWe would like to let you know that we have released dbForge Studio for SQL Server, v3.8 Beta where the feature you reported is implemented.
http://www.devart.com/dbforge/sql/studio/download.html
Thank you for your help in improving dbForge Studio for SQL Server. -
Implement alternative ways to create new object
Why a new object can only be created from main nodes ("Tables", "Procedures"...). Uncomfortable when there are many items I have to scroll up to the top and only then I can create new object from popup.
2 votesThis feature is implemented in the new version 4.0 of dbForge Studio for SQL Server http://www.devart.com/dbforge/sql/studio/download.html
-
7 votes
There is the ‘Ignore Collations’ option added.
-
Profiling mode should use parameter
I can set parameter for my query. But if I use profiling mode, DBForge 5.0.337 ignore the parameters.
0 votesThe Final Release of dbForge Studio for SQL Server, v5.1, where this issue is fixed, is available for downloading https://www.devart.com/dbforge/sql/studio/download.html
Thank you for your help in improving dbForge Studio for SQL Server.
-
Problems with schema refresh
I use version 4.5.60 and do the following: I edit a table (remote connect to SQL2012Express) and add two new columns (one bit, one int) with NOT NULL and Default Value. I click "Script change" and I execute only the two ADD COLUMN statements. It works, I check it with "Retrieve data". I close all tabs and go to again to "Edit table". I get the old schema (without the new two columns). I close your application and start it again: all works fine!
0 votes
- Don't see your idea?