How to copy database structure

[sdonaldson]

I am using MS-SQL Server 7.0 as the backend of an Accounts and Order Processing application.
The SQL Server has a "control" database called "PM" and a database for each "company" or data set called "PM01", "PM02", etc.
The "PM" database is never populated with data - it is only used to define the structure of each company's database.
At the moment a new company is setup by executing an SQL script outside of our application.
I need to be able to copy the entire structure of the "PM" database programatically. Our app is written in Clarion.
Do I need to use SQL-DMO ?

Thanks,
Shaun

 

[osjohnm]

Howzit Shaun

I'm not sure if this will work for you but you could maybe setup a DTS package that only fetches the structure. Then you can call the package whenever you need to from within the app. I have no idea how Clarion works so don't know whether it will work or not but I do know that ASPToday has an article on executing a DTS package from within an asp page.

Hope this is of some help

John