Feature requests

Answered

 Hi,

I tried to migrate to DG from MS SQL Server management studio and there are some things I would like to see or improve in your product:

  1. No indication of disabled (offline) databases
  2. No indication of disabled triggers
  3. Large SQL scripts are executed MUCH slower than on SSMS (I have 85K lines script file :)
  4. By default it would be good load dbo schema for the newly connected databases.
  5. Switch current schema or user dropdown shows databases even if I disabled them in database toolbox.

 

Thanks.

4 comments
Comment actions Permalink

@Albynos

  1. https://youtrack.jetbrains.com/issue/DBE-6811
  2. https://youtrack.jetbrains.com/issue/DBE-3444
  3. Could you describe the way you execute your script? By running SQL file from file context menu or selecting all in a file and then executing?
  4. What if you've got non-dbo default schema? Maybe it would be better to load default (current) schema for a specified user
  5. https://youtrack.jetbrains.com/issue/DBE-6812

 

 

0
Comment actions Permalink

@Vasily,

 

3. Copy from script file / paste to the console window, Ctrl+Enter

4. I'll check possible connection setting later and let you know.

 

Thank you for such quick support.

0
Comment actions Permalink

@Albynos
3. In case you've got script file you can attach it to project and run it:

Or invoke Run SQL Script action on a desired schema from database tree view:

All scripts will be run in batch mode. I'll speed up your script execution.

0

Please sign in to leave a comment.