Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Export Database Model to SQL

Software Development


Reply
 
Thread Tools Search this Thread
  #1  
Old 30-11-2010
Member
 
Join Date: Aug 2010
Posts: 72
Export Database Model to SQL
  

I am employee in one of the database management company and working on SQL and for some ease, I want to export database model diagram which is developed in Visio to SQL. I don?t like to work with in Visio only, so if anyone having any idea about this then let me know how can is this possible. Is there any special software required for this? And I want to tell you that am using operating system Windows Server 2003?

Reply With Quote
  #2  
Old 30-11-2010
Member
 
Join Date: May 2009
Posts: 523
Re: Export Database Model to SQL

Yes it?s definitely possible to export database model diagram which you are developed in Visio to SQL for this you need to follow some steps that are:
  1. First right click on the database and then select all available Tasks and then go on Export data.
  2. Then you will see Import / Export assistant screen, and then click next.
  3. Now arrange the source database and click ones again on Next.
  4. Here configure the destination database and click next.
  5. You will get ?Use a query to specify a data transfer' on Specify Copy or Query Table then Click on Next button.
  6. Now enter Select from data properties on the "Enter the SQL statement and click on Next.
  7. You?ll get one more screen with option 'Select all tables and views sources'. On this you need to select the table dtproperties in the target.
  8. After all this things over, click on Next.
  9. Now click on 'Run immediately' on the next screen you will get ?Saving, schedule and replicate the lot? then click next.
  10. After doing all this steps click on finished.
Reply With Quote
  #3  
Old 30-11-2010
Member
 
Join Date: May 2009
Posts: 532
Re: Export Database Model to SQL

I think it’s possible and for this here I am giving you one software tool which is useful in export database model diagram which is developed in Visio to SQL that is DbVisualizer - there is a pro version and open version that should be sufficient. For this you need right JDBC - database driver of SQL Server, the tool shows tables and references orthogonal, in a circle, hierarchical etc. just by pressing one single button. You can use the free version for long time.
Reply With Quote
  #4  
Old 30-11-2010
Member
 
Join Date: May 2009
Posts: 533
Re: Export Database Model to SQL

As per my knowledge one DbVisualizer is available for this purpose. DbVisualizer is the common database tool for database administrators and developers. It is the ideal solution since the same tool can be used on all main operating systems accessing a wide range of databases.
Some feature of it as follows:
  • Database Browser: it has Tree based navigation through all database objects. Invoke management features and Browse object details.
  • Object Management of database: it gives Visual support to alter, create and modify characteristics for database objects such as tables. Edit and compile support for functions, triggers, procedures and packages. Specific support to the extensive database.
Reply With Quote
  #5  
Old 30-11-2010
Member
 
Join Date: May 2009
Posts: 620
Re: Export Database Model to SQL

As per my knowledge about SQL Server 2005 Express it has hidden tools in it that is Database Diagrams a database-design tool that lets you visually layout your database tables and their relationships. After saving that diagram, the tool produces all the database objects that you included. You can useful for creating new database objects and to change the representation of existing objects.There are also some software tools for this purpose like Ultra ISO and GraphViz.

Last edited by Steyn : 30-11-2010 at 12:57 PM.
Reply With Quote
  #6  
Old 01-12-2010
Member
 
Join Date: May 2009
Posts: 503
Re: Export Database Model to SQL

For this transaction you can use SQL Server 2008 itself. It requires installing SQL Server Management Studio Express. By right Clicking on Database Diagrams you can create new diagram. Select the existing tables and if you have specified the references in your tables properly. You will be able to see the complete diagram of selected tables. Also there is second way to do this by using software tool GraphViz. In this tables and columns can be excluded using usual language; foreign key relationships are conditional, using naming conventions.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Export Database Model to SQL"
Thread Thread Starter Forum Replies Last Post
CAR MAKE & MODEL database karv Software Development 2 07-10-2011 02:19 PM
Model db for easy accounting database Yanni Software Development 4 27-07-2011 08:23 PM
Import and export Utility in Oracle database Adriana_andros Software Development 3 25-01-2010 02:58 PM
Navicat New database import and export Zindin Software Development 2 04-04-2009 11:09 AM
How to Export the database in phpMyAdmin Nurhan Software Development 2 24-02-2009 01:53 PM


All times are GMT +5.5. The time now is 12:55 PM.