Web Development

Ask something
Discussion Locked

How to gen. script to rebuild database

0 helpful
5 replies

by tony_leung99

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Please tell me how to generate script to rebuild database, including script to create table, index, trigger, authorities, etc.

Thanks.

5 replies

by gbworld

It really depends on the database. With SQL Server, you can easily use the Enterprise Manager to script the database. It is a matter of right clicking the database, choosing all tasks, and then choosing to script the database. You have three tabs ofoptions.

With other databases, it is often easier to use a third party tool, including some of the reverse engineering tools, like Visio Pro, ER/Win, et al.

I have not played with Oracle in quite some time, so there may be a tool for it, as well.

by pranav

Do you need this for a particualr Database? Example: Oracle 8i, Sql Server 2000, etc...

This discussion is closed to new replies.