Skip to main content

Re-engineering with SSMS



Dear Friends,
Last week I was doing Database Re-Engineering of our few Legacy Applications.

Actually Re-engineering is a set of activities that are carried out to re-structure a Legacy System to a new system with better functionalities and conform to the hardware and software quality constraint.

I tested 3 Tools for Data-Modeling for this process.

(1) Toad Data Modeler 4.1
(2) Microsoft Visio and
(3) SSMS 2008 .


Data Modeling is a process used to define and analyze data requirements needed to support the business processes within the scope of corresponding information systems in organizations.
All are the good software for Data-modeling but I liked all time favorite SQL Server Management Studio Relationship Diagrams simple-easy, free and having good options..


A little formatting in SSMS database diagrams editor
As more tables will be added, these may not be arranged for easy viewing. To change the arrangement of the diagrams you can right click in the database diagram editor or use the Database Diagrams menu of SSMS as shown below.

1. Add text to diagrams
To make the diagrams more readable you can add text. To add text in your diagram, right click anywhere in the diagram and choose "New Text Annotation". A text box will appear, you can write text and to format the text, right click inside the text box and select the formatting options.
2. Select all objects in diagram editor
When you right click and bring up the menu you have the option to select all added tables and any text that is present in the database diagram editor. The same task can be achieved by using Cntrl+A or by dragging a clicked mouse.
3. Show and hide Relationship Labels for database diagrams in SSMS
Relations are shown among tables through bars/pipes by default. However if it is required to also display the name of the relationship key among tables in a text form, then choose "Show Relationship Labels". It will display names of all present relationships among the tables.
4. To arrange the tables in diagram editor
Right click anywhere in the diagram editor and select "Arrange Tables". All tables will get aligned through this option.
5. Zoom in or out
By right clicking anywhere in the diagram editor, you can get the Zoom option. To analyze the diagrams in any position, you can make use of the zoom option.
6. Keep track of page breaks
SQL Server database diagrams would rapidly consume multiplie pages. So it is better to keep track of page boundaries through page breaks. Enable the page break view by right clicking anywhere in the diagram editor and choose this option. Similarly you can turn off the page break view by again clicking on same menu option.

7. Recalculate page breaks
With the addition of more tables your database diagram may span many pages. Before printing the diagram it may be appropriate to recalculate page breaks, so that printing may be performed optimally. Use this option to assist with setting up your diagram for printing.
8. Copy Diagram to Clipboard
For further customization, editing or just for backup, it may be required to save the diagram to some other file format. For such purposes use the menu item to copy and paste the diagram outside the diagram editor. Along with this menu option you can copy any number of selected tables from one diagram editor and paste it to other diagram. To do this you have to use Cntrl+C for copy, because the copy option is not provided by using your mouse and then you can paste it into another diagram.





Right Click on Diagrams :-
1. Table View : We can View Standard and Custom wise of Structure.
2. Add Related Tables : - We can add Hierarchical Levels using this option.
3. Auto-Arrange : This option will automatically arrange the Diagram as per system flow. This will easy to understood our System..

ATTENTION :- Carefully and keep concentrate on two options in diagram Delete Table from Database and Remove from Diagram.. 1st option will remove from Table with Data… and 2n will Remove from Diagram only….



Two Times I have been suffered from Trouble one on Development Server and One on Production Server…. But I recovered Table in 1 hour….he he…




Comments

  1. I like the helpful information you provide in your articles.
    I will bookmark your weblog and check again here regularly.

    I am quite sure I will learn many new stuff right here!
    Best of luck for the next!

    Here is my web site; google plus android

    ReplyDelete
  2. My brother recommended I might like this web site. He was totally right.
    This post actually made my day. You can not imagine simply how much time I had slent for this
    info! Thanks!

    Visit my website; myorganicsleep's duvet cover

    ReplyDelete
  3. Hi, I read your blog like every week. Your humoristic style is
    witty, keep doing what you're doing!

    My webpage: Op Lung Htc Desire 610

    ReplyDelete
    Replies
    1. Thank you So much for your nice comment ...

      Delete
  4. Good one Suman, keep writing

    ReplyDelete
  5. Greetings, I think your website could be having browser compatibility problems.
    When I take a look at your website in Safari, it looks fine however when opening
    in I.E., it has some overlapping issues. I merely wanted to give you a quick
    heads up! Other than that, fantastic blog!

    ReplyDelete

Post a comment

Plz dont forget to like Facebook Page..
https://www.facebook.com/pages/Sql-DBAcoin/523110684456757

Popular posts from this blog

mongoDB error : aborting after fassert() failure

What to do when facing errors on mongoDB “aborting after fassert() failure”

I like errors, in mongoDB this is the first error I faced and luckily many times. This error i faced during restoring name-space on local and restarting db system. I am still searching the exact root cause of this issue but i am able to resolve the current problem through below steps.

Remove all relevant namespace files from data-file route path..Now repair mongo instance using mongod process.mongod --repair ////////// execute command from bin folder path Then start server using mongd process, if started server successfully then ..mongod  ////////// execute command from bin folder path Restore last backups as normal process.Now check database by connecting mongo shell. Thanks for reading, 
Please comment your experience if you faced and also share knowledge if you have better steps to resolve...


https://www.facebook.com/pages/Sql-DBAcoin/523110684456757

SQL71562: external references are not supported when creating a package from this platform

Last week I got this error from one of developer who was trying to deploy his project from Testing server to SQL Azure QA server. He was using “Deploy Database to SQL Azure” option from SSMS Tool-Task option.

After connecting to SQL Azure portal when operation started to deployment below errors occurs.

Validation of the schema model for data package failed. Error SQL71562: Error validating element xx.xxx.xx:function .dbo.xxx has an unresolved refrence to object xx.dbo.xxxx external refrences are not supported when creating a package from this platform.



Reason: The reason of the this error was; some functions of project was dependent on master database and only single database was being deploy to SQL Azure. DACFx must block Export when object definitions (views, procedures, etc.) contain external references, as Azure SQL Database does not allow cross-database external references So, this error was coming.

Solution : I suggested him to create those function to locally on local database what…

How to add an article in Transactional Replication

If we have a set-up of Transactional Replication for Data Distribution running and wanting to add new object to replication on other server we can follow below process.
To add an article In Transaction replication with PUSH Subscription