schemazen | Script and create SQL Server | SQL Database library

What i would like to achieve is have two different SQL Server Databases, on two different servers running the same SQL Server Version( SQL Server 2008 R2 RTM - 10.50.1600.1 ) to be synched daily. Synched meaning just transferring the new data ( or even all the data ) from one of the two ("parent" database ) to the other ( "child" database ). We want the parent to force its shema as well all its data to its child.

Knowing that the two machines run on windows server 2012 R2 i have already tried to implement a solution ( although i am no expert when it comes to SQL Server ) using the following tools.

• PHP v7.2
• ExeOutputforPHP ( https://www.exeoutput.com/ )
• WinSCP ( For its build in ftp methods https://winscp.net )
• Schemazen ( https://github.com/sethreno/schemazen )

So what i would do would be this :

1. Read a configuration file using PHP ( server, user, pass, database, etc.. )
2. When PHP would not produce any errors i would trigger the schemazen script method.
3. When everything would go smooth i would trigger the winscp's ftp method to the remote Server

1. I would Locate the ftp directory and using the Schemazen create method i would import the data again by reading a configuration file.