How to update aun Diagram

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
gratouin
Posts: 3
Joined: Mon 21 Oct 2013 10:57

How to update aun Diagram

Post by gratouin » Mon 21 Oct 2013 11:04

Hello,

I would like to know how to update a diagram from a database ?
Is there a way to launch a comparison and to get the new elements (tables, view ...) in the diagram ? And, of course, without breaking the diagram (group and container).

The only way I found is to create a snapshot the day you start, to make a snapshot comparison and to update one by one by sliding the objects from left database menu.

Regards

Julien

alexa

Re: How to update aun Diagram

Post by alexa » Mon 21 Oct 2013 11:35

You can also select several objects at a time by holding Ctrl or Shift in Database Explorer and then drag'n'drop them onto a Database Diagram.

gratouin
Posts: 3
Joined: Mon 21 Oct 2013 10:57

Re: How to update aun Diagram

Post by gratouin » Mon 21 Oct 2013 11:37

Yes, that's right, thanks.

The problem here is to identify the new objects in the database (in comparison with the diagram).

alexa

Re: How to update aun Diagram

Post by alexa » Mon 21 Oct 2013 13:12

Unfortunately, you would need to identify the new objects on your own and then drag'n'drop them manually from Database Explorer onto the Database Diagram.

gratouin
Posts: 3
Joined: Mon 21 Oct 2013 10:57

Re: How to update aun Diagram

Post by gratouin » Mon 21 Oct 2013 13:26

Thank you very much for the answers :)

syedshah20
Posts: 1
Joined: Fri 19 Dec 2014 12:21

Re: How to update aun Diagram

Post by syedshah20 » Fri 19 Dec 2014 12:29

Is there a way to export data (using theE20-517 - test-king
data export feature) using a customerID as a filter.
Specifically I need to be able to export where customerID

alexa

Re: How to update aun Diagram

Post by alexa » Fri 19 Dec 2014 14:20

You can filter records in the data grid, right-click and select 'Export Data...' from the popup menu.

Please also see the following topics in the product's Help documentation:

- Custom AutoFilter Dialog Box
- Filter Editor Dialog Box
- How To: Export Data

Post Reply