268 results found

1. Schema/data comparison user interface

   Hi. I'm currently evaluating studio for sql server. OK, i'm primarily interested in schema and data comparison but evaluating the whole studio product. Here's a couple of things which i think would be useful additions/modifications to the UI of the product(s) (schema and data comparison).

   1. The "recent files" section. I think it would be better if there was a "favorites" section above "recent files" and the user was able to choose whether he wishes to have the "recent files", "favorites" or both sections shown. Also, comparison projects could have an editable title so in the "favorites" section, one could see the title instead of what appears now ("DB (Server1 vs Server2)").
   2. In the results of the schema comparison, tables are grouped depending on whether they are different or only in one of the two servers. I've used other comparison programs and i find the "two trees approach" more useful and clear than the one you are using. Imagine two trees in the screen. The left one shows the source server's items and the right one the destination. There is a top level in the tree containing the names of all items taking place in the comparison (tables, views, functions, procs, etc). Under there, all names (i.e. of the tables) are shown with different colors depending on whether they are the same, different or non-existant. Each table name could also be expandable so one could see its columns, indexes, keys, default values, etc. In front of the tree a checkbox should exist so one would be able to check it and make it a part of any sync script generated. Under the trees, a section exists like the one you have now, showing the left and right "create" scripts of the tables. If you have a visual image of a DB in your mind with all tables sorted alphabetically, it's easier to work with it like this than having all tables/views grouped by "only in source server, different, etc").
   3. Clicking on a "recently used" item (for data comparison only), the "edit comparison" window should appear in the "mapping" section, just in case someone wishes to select a different set of tables to be compared. When you have a local DB and a remote one with a slow connection, you wish to select the comparison items before starting the process which might take several minutes to complete.
   4. The "change sync direction" concept in the data comparison window is a little confusing. It would be much better if the whole window was changed in such a way as if the comparison was made from the beginning with the two servers swapped. Swap the values of the grid columns "only in source" and "only in target" and not the titles. The same with the tabs.

   Hi. I'm currently evaluating studio for sql server. OK, i'm primarily interested in schema and data comparison but evaluating the whole studio product. Here's a couple of things which i think would be useful additions/modifications to the UI of the product(s) (schema and data comparison).

   1. The "recent files" section. I think it would be better if there was a "favorites" section above "recent files" and the user was able to choose whether he wishes to have the "recent files", "favorites" or both sections shown. Also, comparison projects could have an editable title so in the "favorites" section, one could see… more
   0 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  Features  ·  Edit…  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

2. Provide a means to 'preview' the results of a sql query prior to actually executing it.

   When designing fairly complex queries that would result in the altering of several (potentially hundreds) of rows of data it would be nice to be able to see a 'preview' of what the results of running it might be. This would help greatly in refining the query as it is being written so that it really does end up producing the desired results.

   1 vote

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  Features  ·  Edit…  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

3. Comparing and synchronizing Views using a different schema-mapping doesn't work

   When comparing and synchronizing views while using a different schema-mapping:
   *) equal views are marked as different cause of the different schema in the view name and the different schema within the select -> please adapt the compare-logic to accept the correct displayed sqls as equal
   *) the generated sql for updating views doesn't work because they contain the right schema (target) in the view name, but the wrong schema (source) within the select -> please replace objects with the source schema within the select of the view with the target schema

   7 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  Features  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

4. Duplicate query

   I would like to see an option on tab context menu. Often I need to duplicate (clone) my query. So another useful option in context menu when clicking on Query Tab would be "Duplicate query" or something like that.

   0 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  Features  ·  Edit…  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

5. Interface / engine to work with SSIS / legacy DTS packages

   Abitlity to view/create/modify SSIS packages

   4 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  Features  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

6. Allow for the top filter row to be used on the DexExpress grid

   Allow for the top filter row to be used on the DexExpress grid like the used to view table data.

   6 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   1 comment  ·  Features  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   AdminDevart (_, Devart) responded

   Could you please describe this in more detail?

7. Query Builder Union Support

   hi guys

   a simple UNION like

   SELECT TOP 10 contactnumber FROM contacts c JOIN addresses a ON c.addressnumber = a.addressnumber
   UNION
   SELECT TOP 10 contactnumber FROM contacts c JOIN addresses a ON c.addressnumber = a.addressnumber

   will create an error "1 Not unique table/alias: 'c' Query.sql".

   It would be nice to see the querybuilder processing these kind of sql's.

   kind regards
   peter

   8 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  Features  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

8. One Database Diagram for All Sql Server

   Like "Enterprise Architect" do it, But it UI design very Bad ,no friendly.
   So, I Hope you can develop it.

   4 votes

   Vote Vote Vote

   Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   1 vote 2 votes 3 votes Remove votes

   You have left! (?) (thinking…)
   0 comments  ·  Features  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close