June 5, 2006 at 11:36 pm
Dear All,
Is there a command that will generate a DB Schema file from an existing Database? I do not want the data. I just need to be able - using a simple command - to extract the DB schema.
Thanks,
Andreas Kantounas
June 6, 2006 at 12:18 am
I am not aware of any 'simple' command that will do it for you, but there are plenty of third party tools that can generate the schema from a database. If you have the Enterprise Architect version of Visio then you can also reverse-engineer a database. Other more expensive tools like ERWin will also do the same sort of reverse-engineering work!
June 6, 2006 at 2:42 am
By schema do you mean a diagram or the SQL code required to create the tables, views, stored procs, triggers, etc?
If the latter, then script your DB from enterprise manager. You could also use DTS to create a script for your DB but not generate insert statements.
If the former, goto Enterprise Manager and create a DB diagram.
If you are using SQL 2005 - obviously use Management Studio in place of EM - same ideas apply though....
June 6, 2006 at 2:52 am
Dear Ian,
What I am trying to achieve is to generate the SQL code for tables, views, SPs, triggeres, etc. I have already done so with EM but I am looking for something like the "dbschema" command of Informix.
Thanks,
Andreas Kantounas
June 6, 2006 at 4:25 am
Ahh... Have you checked the scripts repository of this site?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply