Page 1 of 1

Copy Database without Data

Posted: Fri 19 Jun 2009 06:14
by siik
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

Posted: Fri 19 Jun 2009 12:52
by Dimon
SDAC doesn't support a functionality to copy a database structure.

Posted: Fri 26 Jun 2009 13:31
by johncmolyneux
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.