How can I migrate all objects alogwith all constraints,SP,Triggers etc from Development instance

Hi fellows,

I have to migrate all objects alogwith all constraints,SP,Triggers, indexes etc from Development instance to Production instance of a DB, all those things are created through wizard ie. Sql server 2000 Enterprise Manager. if i use DTS it only mirates data along with tables and views but constraints,SP,Triggers, indexes etc not yet copied.

can any body help me how can I solve this problem by copying all objects alogwith all constraints,SP,Triggers etc from Development instance to Production instance.

This is Sql server 2000 Cluster environment.

thanks in advance for any help

rahman

I would script all the objects out using Enterprise Manager and then run them all in the other environment.

-Jamie

|||

Dear Jamie

Thank you very much for your reply

would you like to give me a hence to write script for all the object's constraints (ie. Default,Check,Primary Key, Foreign Key etc) and indexes using Enterprise Manager.

I am new in SQL Server

Thanks in advance

|||

1. Right-click on an object.

2. Point at All tasks--> Generate SQL Script...

-Jamie

|||

Dear Jamie

Thanks for your reply.

I know this script only create table/view but not any constrains attached with it. As you know DTS also creates Table/views and imports the data too.

it'll not solve the problem, I m trying to write scripts for constraints getting info. from some views of Information_Schema.

|||

Thanks Jamie,

I didn't see the options available in Options Tab of All tasks--> Generate SQL Script

thank you very much

sql