Copy Database without Data
Posted: 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
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