I have a couple of SQL servers on different web hosts, and I'm looking for a way to periodically update one server using another. Here is what I am looking for:
- As automated as possible - ideally, without any involvement in my part after its creation.
- Pops several databases into them completely (including any schema changes) from one server to another.
- Freely authorizes changes on the source server without disrupting my process. For this reason, I do not want to use replication, as I will have to break it every time I update the source, and then recreate the publication and subscription
- One database is about 4 GB in size and contains binary data. I'm not sure if there is a way to export this to a script, but it would be a gigantic file if I did this.
Initially, I was thinking of writing something that requires a planned full backup of each database, the FTP servers back up from one server to another after they are completed, and then the new server picks it up and restores it. The only drawback that I see in this is that there is no way to find out that backups are running before starting to translate them - can these backups run synchronously? In addition, the updated server is our test server, so if there is a downtime associated with moving data, this is great.- , , ? , .
UPDATE:
, BAT , 7Zip, FTP OSQL, . .
!