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
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
Last Comment
prosit
Why not restoring the backup?
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..
There are of course some tools: RedGate, Visual Studio, Apex..
ASKER CERTIFIED SOLUTION
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.
ASKER
I've been out sick, I'll respond tomorrow when back in office.
ASKER
PS. IPhone standard browser can't reply to posts, had to open chrome. Lame
ASKER
tnx