Problem solve Get help with specific problems with your technologies, process and projects.

Best method to copy a database with all of its properties without data

I have been tasked with automating the creation of an MS SQL Server 7.0 database, ideally from within an application written in Clarion. Our (business accounts) application uses a separate database for each company, named "PMnnn" where nnn is any three digit number. The application has a "template" database called "PM," which is never written to - it is only used to define the properties of the database and its associated tables. What method(s) would do you suggest I use to copy the "PM" database, all of its properties, and its associated tables (without data)? Do I need to use SQL-DMO, for example?

I find backing up a database and restoring it to a new database with a different name the easiest method of creating exact duplicates of existing databases.


For More Information

Dig Deeper on Microsoft SQL Server Installation

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.