Link to home
Start Free TrialLog in
Avatar of prosit
prositFlag for United States of America

asked on

SQL Server 'replication'

Hi,

I am looking for an easy (cheap) way of automatically copy tables, stored procedures and views (basically everything :) from one server to another.

I guess I could schedule a task to do it, but is there a different (better) way of doing it.

If not, then what are my best "commercial" tools to accomplish this?

Thanks
~j
Avatar of ste5an
ste5an
Flag of Germany image

Why not restoring the backup?
Avatar of prosit

ASKER

If that is the best way of doing it that's fine, I thought perhaps there were tools that could accomplish some sort of 'replication' more or less 'as it happens'.
Well, it depends on your reasons and what you exactly mean with 'replication'..

There are of course some tools: RedGate, Visual Studio, Apex..
ASKER CERTIFIED SOLUTION
Avatar of Deepak Chauhan
Deepak Chauhan
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of prosit

ASKER

I've been out sick,  I'll respond tomorrow when back in office.
Avatar of prosit

ASKER

PS.  IPhone standard browser can't reply to posts, had to open chrome.   Lame
Avatar of prosit

ASKER

tnx