We have testserver and Production sevrer. We have DB named say sampleDB in
testserver,which needs to be synchronizeb (i.e data ,structures ,
views,SP,etc(all objects)) with production server.

thanks in advance.

You could use the "Copy SQL Server Objects Task" in DTS to synchronize /
refresh your database. You just need to pick the source and destination
databases. I usually set the following options:

Create Destination objects (tables, views, sp, constraints, etc) (Checked)
Drop destination objects (Checked)
Include dependant objects (Not Checked)
Include extended properties (Not Checked)

Copy Data (Checked)
Replace existing data (Checked)

Use Collation (Not checked)
Copy all objects (Checked - unless you want to specify specific tables, sp,
views for your migration)
Use default options (Not Checked)
I usually uncheck
Copy Database Users and Roles
Copy Object level permissions

hope this helps,
Anthony


--
Anthony J Biondo Jr. - MCP
Senior Web Developer
Keystone Mercy Health Plan - Philadelphia, PA
www.keystonemercy.com


"vignesh" <vignesh (AT) discussions (DOT) microsoft.com> wrote

If this is a one time sync then these steps will work. If it is going to
need to be consistently up to date you may want to look at log shipping or
replication.

Rand
This posting is provided "as is" with no warranties and confers no rights.