REPLICATE DATABASE SAME AS PRODUCTION

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

REPLICATE DATABASE SAME AS PRODUCTION

Author

Topic

cshekar
Starting Member

49 Posts

Posted - 2001-12-04 : 16:53:55

I have the Two server one for production and another one for development.but I wanted set up the process that every day I have to update process development databases to Production databases.
Could you please help me related to that.
I wanted to updated production database on daily basiss,

chandra shekar

byrmol
Shed Building SQL Farmer

1591 Posts

Posted - 2001-12-04 : 17:31:11

chandra,

Is your database changing that much??

Have you heard of a software development life cycle!!!

I am guessing that you should be only updating schema, procs etc.. and not data.

If that is the case then replication is a waste of time and effort.
Any changes that you make to your development DB should be scripted and stored and then simple run that script against the production DB

DavidM
It gets windy at a thousand feet...."Tutorial D"

cshekar
Starting Member

49 Posts

Posted - 2001-12-05 : 16:24:13

Hi DavidM
Yes you are right I am doing just updated of development in to production everyday basis should I use proc to run or how to use schema,

chandra,

Is your database changing that much??

Have you heard of a software development life cycle!!!

I am guessing that you should be only updating schema, procs etc.. and not data.

If that is the case then replication is a waste of time and effort.
Any changes that you make to your development DB should be scripted and stored and then simple run that script against the production DB

DavidM
It gets windy at a thousand feet...."Tutorial D"

[/quote]

byrmol
Shed Building SQL Farmer

1591 Posts

Posted - 2001-12-05 : 16:55:04

Lets say that you are changing a table. If you are using the Enterprise Manager, you will find a button on the toolbar that will create a script of the changes you made. Simply keep a copy of all the script files generated and run them against the production database in the order that you created them.

DavidM
It gets windy at a thousand feet...."Tutorial D"

cshekar
Starting Member

49 Posts

Posted - 2001-12-06 : 09:48:49

Hi David,
I wanted to updated the the table on daily basis from development to production, also you said theire is button, on toolbar but
that no button on the toolbar that will generate sqlscript for me.

thanks
Chnadra

quote:

Lets say that you are changing a table. If you are using the Enterprise Manager, you will find a button on the toolbar that will create a script of the changes you made. Simply keep a copy of all the script files generated and run them against the production database in the order that you created them.

DavidM
It gets windy at a thousand feet...."Tutorial D"

chandra shekar

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources