Is it possible to have 2 links sql copies on 2 different servers as follows:
server A has a links copy and will host the main database that users submit their links to and gets updated/validated daily by the admin as new links come in.
server B also has a links copy but will get the actual data transferred to it from server A - either at the end of the day or the end of the week. The server B will just get the same data that server A has. The process of data transfer from server A to server B is either manual or automated.
1) If the data needs to be transferred manually by the admin, what would be the easiest way to transfer links database?
2) If it can be automated, what is the process?
Thanks
server A has a links copy and will host the main database that users submit their links to and gets updated/validated daily by the admin as new links come in.
server B also has a links copy but will get the actual data transferred to it from server A - either at the end of the day or the end of the week. The server B will just get the same data that server A has. The process of data transfer from server A to server B is either manual or automated.
1) If the data needs to be transferred manually by the admin, what would be the easiest way to transfer links database?
2) If it can be automated, what is the process?
Thanks