I am currently in discussions with DBA and IT Security staff within my company, and am being told that the only way to securely link to our master database (MSSQL behind a firewall) to our web apps is to make a backup file, FTP the file to the web server, and run a script(s) to restore that imported backup file to a database hosted outside the firewall (and then import the data to MYSQL). I am having a hard time believing that this is the best solution. Ideally, I would like to have a two-way direct link between the master MSSQL server and a MySQL database that server web apps, and have those database sync. Can anyone point me toward such a solution, or is it true that we need to rely on FTP to cross the firewall?
Thanks!