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!
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
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
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..
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.
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.
Premium Content
You need an Expert Office subscription to comment.Start Free Trial