Creating an empty database that has the same fields as production

[egeerdink]

Like the title says, what is the best way to create an empty database that has all the same fields as our production database?

OE 10.1B03
Windows 2003 Server
3GB database

Thanks for the help.

Erik

 

[Cringer]

Easiest way I think it probably to create a df from production, then create a new database as a copy of the empty db that matches the block size then apply the df.

 

[Rob Fitzpatrick]

Correct. Although if you just want the same schema, matching the database block sizes isn't necessary.