Reverse Engineering an existing database 
Author Message
 Reverse Engineering an existing database


Quote:
> I heard somewhere that it is possible to reverse engineer a Sybase
> database using queries run against the sys* tables and the master database

> We need to move/recreate a number of databases but the target machine
> is much smaller than the source so dump/load is not an option due to a
> lack of disk space.

> There are a number of db-designs available but as nearly always happens
> the designs don't get updated when emergency changes are made to the
> production databases.

> So I would feel safer if I could reverse engineer the production
> databases and use the resulting sql to recreate copies on the target
> machine. I would tackle this one myself but Sybase is a relatively new
> departure for us and I would no doubt omit crucial elements.

> So my questions are
> 1. Is it possible to reverse engineer in this way
> 2. Does anybody if the necessary scripts exist
> 3. Is it possible to get a copy of these scripts

There is a program that comes with sybase 10.x called SQL Server Manager
(ssm.exe?) that will allow you to pull the database designs, etc.  For
11.x the program is Sybase Central (I don't know its program name).  Good
luck.


Mon, 24 Apr 2000 03:00:00 GMT
 Reverse Engineering an existing database

Quote:


> > I heard somewhere that it is possible to reverse engineer a Sybase
> > database using queries run against the sys* tables and the master database

> > We need to move/recreate a number of databases but the target machine
> > is much smaller than the source so dump/load is not an option due to a
> > lack of disk space.

> > There are a number of db-designs available but as nearly always happens
> > the designs don't get updated when emergency changes are made to the
> > production databases.

> > So I would feel safer if I could reverse engineer the production
> > databases and use the resulting sql to recreate copies on the target
> > machine. I would tackle this one myself but Sybase is a relatively new
> > departure for us and I would no doubt omit crucial elements.

> > So my questions are
> > 1. Is it possible to reverse engineer in this way
> > 2. Does anybody if the necessary scripts exist
> > 3. Is it possible to get a copy of these scripts

> There is a program that comes with sybase 10.x called SQL Server Manager
> (ssm.exe?) that will allow you to pull the database designs, etc.  For
> 11.x the program is Sybase Central (I don't know its program name).

If you feel like installing perl and sybperl, then the dbschema.pl
script (which is included in the sybperl distribution) does what you
want (ie it creates an isql script that can be used to rebuild a
database from scratch).

Michael
--
Michael Peppler       -||-  Data Migrations Inc.



Mon, 24 Apr 2000 03:00:00 GMT
 Reverse Engineering an existing database


Quote:
>I heard somewhere that it is possible to reverse engineer a Sybase
>database using queries run against the sys* tables and the master database

Yes it is - try looking at the tool named: DBArtisan from:

http://www.embarcadero.com/

it does the trick - and many more.

There is a 30 day evaluation ready for download.

--
Regards

Henrik H. Jensen, System Manager, R&D Department
CDM Gruppen A/S, Strandvejen 781, 2930 Klampenborg, Denmark



Mon, 24 Apr 2000 03:00:00 GMT
 Reverse Engineering an existing database

Quote:

> > So I would feel safer if I could reverse engineer the production
> > databases and use the resulting sql to recreate copies on the target
> > machine. I would tackle this one myself but Sybase is a relatively new
> > departure for us and I would no doubt omit crucial elements.

> > So my questions are
> > 1. Is it possible to reverse engineer in this way
> > 2. Does anybody if the necessary scripts exist
> > 3. Is it possible to get a copy of these scripts

> There is a program that comes with sybase 10.x called SQL Server Manager
> (ssm.exe?) that will allow you to pull the database designs, etc.  For
> 11.x the program is Sybase Central (I don't know its program name).  Good
> luck.

I've used a utility called REVSQL which works pretty good and its
free.   I don't remember the site it came from but try searching for
REVSQL or SQLTECH.


Mon, 24 Apr 2000 03:00:00 GMT
 Reverse Engineering an existing database



Quote:

>> > So I would feel safer if I could reverse engineer the production
>> > databases and use the resulting sql to recreate copies on the target
>> > machine. I would tackle this one myself but Sybase is a relatively new
>> > departure for us and I would no doubt omit crucial elements.

>> > So my questions are
>> > 1. Is it possible to reverse engineer in this way
>> > 2. Does anybody if the necessary scripts exist
>> > 3. Is it possible to get a copy of these scripts

>> There is a program that comes with sybase 10.x called SQL Server Manager
>> (ssm.exe?) that will allow you to pull the database designs, etc.  For
>> 11.x the program is Sybase Central (I don't know its program name).  Good
>> luck.

>I've used a utility called REVSQL which works pretty good and its
>free.   I don't remember the site it came from but try searching for
>REVSQL or SQLTECH.

The revsql package was written by Simon Walker and is available at:
www.sqlworkshop.com
--
... But we can hardly believe that the accidental circumstances of the
earth deserve to be taken so seriously. - Bertrand Russell


Tue, 25 Apr 2000 03:00:00 GMT
 Reverse Engineering an existing database

Quote:

> The revsql package was written by Simon Walker and is available at:
> www.sqlworkshop.com
> --
> ... But we can hardly believe that the accidental circumstances of the
> earth deserve to be taken so seriously. - Bertrand Russell

There is also a full-cycle database development tool called Erwin from
Logic Works that has been very popular in the relational db
design/re-design.

Hope this helps.

Michael Austin
Michael Austin, Inc.
An Independent Oracle Rdb DBA consultant



Thu, 27 Apr 2000 03:00:00 GMT
 
 [ 7 post ] 

 Relevant Pages 

1. Reverse engineering and existing Oracle Schema in Rational Rose

2. Reverse Engineering / Database Diagram?

3. script to reverse engineer ddl from database

4. Reverse engineering PG database

5. How to keep web database from getting reverse-engineered using url parameters

6. Reverse Engineering in Oracle Database

7. Reverse engineer database creation script

8. How to reverse engineer database w/Designer2000?

9. Reverse Engineering database objects

10. Reverse Engineering My Database

11. Reverse Engineering Database S/w


 
Powered by phpBB® Forum Software