Avatar of prosit
prosit
Flag 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
Microsoft SQL Server

Avatar of undefined
Last Comment
prosit

8/22/2022 - Mon
ste5an

Why not restoring the backup?
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'.
ste5an

Well, it depends on your reasons and what you exactly mean with 'replication'..

There are of course some tools: RedGate, Visual Studio, Apex..
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
ASKER CERTIFIED SOLUTION
Deepak Chauhan

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
prosit

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

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

ASKER
tnx
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.