which software?

Question

Post reply

which software?

shanghaigirl-1125377

Ten Centuries

Points: 1231
More actions
April 14, 2010 at 2:06 pm

#139669

we are looking for some software to sync production and development environment data on daily basis, to be efficient, it syncs only new days' data and runs on schedule. I came across Redgate and Idera comparison tools. Can you suggest which one is better? what are the differences between the 2? Thanks.

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Henrico Bekker One Orange Chip Points: 27652 More actions · Answer 1

MS SQL has built in functionality to do this...

log ship, replication......

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

free_mascot One Orange Chip Points: 27169 More actions · Answer 2

Instead of any third party tool... Yes replication is surely better option. Schedule the job to distribute the data nightly from Publisher to subscriber. Also the advantage is you can have mulitple subscriber i.e. you can push data to multiple development servers.

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

chandrakant_gaurav Right there with Babe Points: 799 More actions · Answer 3

I will also vote for replication only, but of the two tools, redgate is better and hasslefree.

shanghaigirl-1125377 Ten Centuries Points: 1231 More actions · Answer 4

shanghaigirl-1125377

Ten Centuries

Points: 1231

April 15, 2010 at 10:57 am

#1152298

thanks.

Jeff Moden SSC Guru Points: 1004339 More actions · Answer 5

If you're looking for a "perfect" copy of production to put into development and have a decent SAN, then you could use a "SAN Snapshot" (has nothing to do with SQL Server) or "San Clone" which will accomplish the task on a tera-byte database in just a couple of minutes and has no ill effects on production during the process.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Dhananjay-440114 Ten Centuries Points: 1365 More actions · Answer 6

What is size and volume of database that needs to be replicated.

shanghaigirl-1125377 Ten Centuries Points: 1231 More actions · Answer 7

we are a small shop, and I am the only dba. Management prefers software because in the case I am on vacation, somebody else can handle the sync.

Dhananjay-440114 Ten Centuries Points: 1365 More actions · Answer 8

Hi,

Why don't you try in-built log-shipping of SQL server or even replication... Believe me its very easy to setup and manage.... Any one can manage it whenever u will be on leave....

Regards

shanghaigirl-1125377 Ten Centuries Points: 1231 More actions · Answer 9

Yep, agree replication is neat, and set it up is easier than go through people comfort zone.;-)