Import/export data versus Snapshot Replication
-
Hi, guys!!
I'm having a existencial doubt
What the difference between a snapshot replication or a import DataBase??
What is the best and FAST way to do the job??
Thankx
Cláudia
Regards,Cláudia Rego
www.footballbesttips.com
-
It depends. How big is the DB and how fast the network.
In the past I built a replication architecture that had 800 miles between the sql servers with a 512KB network. I this case a backed up the db, zipped the backup, copied it to the other server, restored it and then configured replication.
Norman
-
In this moment DB has 300 MB.
the network has 128Kbps.
The servers are <10Km away.
What do you think??
Thanks
Cláudia
Regards,Cláudia Rego
www.footballbesttips.com
-
You have the same situation, but I forgot to mention one thing. It makes the set up very easy if the local database can be taken off-line while the backup and copy/restore to the remote sever occurs. That way you are sure that the two servers will have identical data when replication is configured.
If the local database can not be taken off-line, then this process becomes much more difficult. Snapshot may be the best option in this case, I'm just not sure how long it will take.
Norman
-
Hello!
I don't understand what you mean with "DB can be taken off-line"??
Thanks
Regards,Cláudia Rego
www.footballbesttips.com
-
That it is not available to users or the application.
-
Hello!
I hope not being annoying... but i still don't understand what is the fundamental diference between replication or DTS package that also copies the wanted data.
do i get more functionalities with DTS package or with replication?
When should i use DTS or when i should prefer replication?
Thankx,
Cláudia
HAPPY HALLOWEEN
Regards,Cláudia Rego
www.footballbesttips.com
-
What you have here purpose are two ways of the doing the same thing. The replication solution allows you to distribute the data to multiple sites in a quick and easy way. The DTS solution is more specific with it's connection, that is, you have the connection to the server built into the package. IT can get more complicated if you want to introduce a new server to which the data must be sent. Once the publication for snapshot rep is set up, you can add many subscriber easily.
Use Rep for simple distribution of data, use DTS if you need to transform or perform any data manipulation.
HTH....Graeme
-
It's what i think!!
But people here are a little obstinate in doing replication...
What strong arguments should i use?
Any docs, articles i can read?
thankx
Regards,Cláudia Rego
www.footballbesttips.com
-
It sounds like you are dealing with people who don't understand how replication works. My advice would be to have a look at some simple replication articles/books/BOL so that you have a good understanding. Try setting up a simple database with replication, on your local machine will be good enough. Then let your people see how straightforward it is.
You could then show them how easy it is to introduce another subscriber(server) into the system without any redesign of any package/publication.
The strongest arguement would be man hours in setting up and maintaining the solution.
Good Luck
G
-
Hello!
I have again with the same problem...
My colleague insists in DTS and i insist in replication.
In fact, the case is a tipical case for using replication!!
But my colleague insist in DTS...
The problem is that i tried replication transactional and DTS, and it seems that DTS have a best behaviour.
I don't understand why!!!
With replication, several times i get "general network error".
The DB has 300 MB and the network 128KB.
HELP.....
Regards,Cláudia Rego
www.footballbesttips.com
-
Hello!
I have again with the same problem...
My colleague insists in DTS and i insist in replication.
In fact, the case is a tipical case for using replication!!
But my colleague insist in DTS...
The problem is that i tried replication transactional and DTS, and it seems that DTS have a best behaviour.
I don't understand why!!!
With replication, several times i get "general network error".
The DB has 300 MB and the network 128KB.
HELP.....
Regards,Cláudia Rego
www.footballbesttips.com
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply