January 22, 2003 at 5:42 pm
Hello,
I'm new to SqlServer (Oracle DBA background). I want to be able to copy all metadata definitions (tables,views,indices,etc) from one Sql Server DB to another. What I want to do is create an empty copy of the Production DB.
Is there a way to capture the metadata definitions on the target DB and apply them (maybe in the form of a T-SQL script) to destination DB.
Is there a function that will generate the T-Sql code for a given database ?
Please share your thoughts and thanks in advance.
January 22, 2003 at 6:41 pm
From the Enterprise Manager, selct the database desired, click on Tools, then Generate SQL Scripts. You will see from there.
January 23, 2003 at 11:31 am
quote:
From the Enterprise Manager, selct the database desired, click on Tools, then Generate SQL Scripts. You will see from there.
January 23, 2003 at 11:32 am
quote:
From the Enterprise Manager, selct the database desired, click on Tools, then Generate SQL Scripts. You will see from there.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply