SQL Server 'replication'

prosit
prosit used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
ste5anSenior Developer

Commented:
Why not restoring the backup?

Author

Commented:
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'.
ste5anSenior Developer

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

There are of course some tools: RedGate, Visual Studio, Apex..
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Commented:
You have multiple option available in sql server itself. What is the size of database?

1. backup and restore.
2. Copy database files from source server and attach them to destination server.
3. copy database wizard.
4. Snapshot Replication.

Snapshot Replication or backup and restore is easiest method with no downtime.

Author

Commented:
I've been out sick,  I'll respond tomorrow when back in office.

Author

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

Author

Commented:
tnx

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial