Copy Database without Data

siik · Post by **siik** » Fri 19 Jun 2009 06:14

Hi,

Ive been searching on this all day, but no-one seems to have an easy solution!

All i want to do is copy a database i have made manually to a new database with a new name and without all the data.

So if my original database is 'DBOrig' then i would like to make a new database on the same server called 'DBNew' which has exactly the same schema as 'DBOrig', but with no data in any of the tables.

This surely cannot be that hard.

Help Appreciated

Dimon · Post by **Dimon** » Fri 19 Jun 2009 12:52

SDAC doesn't support a functionality to copy a database structure.

johncmolyneux · Post by **johncmolyneux** » Fri 26 Jun 2009 13:31

Hi.

You're looking for a script for this really, rather than a component to do it. If you need some help with that, I'd be happy to help out. My email is my username at hotmail dot com.

Thanks,

John.