InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 14:25:50 GMT20http://www.sqlservercentral.com/Forums/Topic732408-391-1.aspxThe cost comes in when we have to scale out and add more SQL boxes. Our application is designed in a way that we can add as many database servers as we want. The application will determine load on each of the SQL machines and direct the sql to the appropriate place. If we add say, 7 more SQL servers, that is a significant cost.Wed, 10 Jun 2009 11:13:18 GMTdjones-1062714http://www.sqlservercentral.com/Forums/Topic732408-391-1.aspxYou say you want to replace the 3 SQL Server boxes with MySQL for cost reasons. What cost is there in keeping the SQL Server boxes? Your licences for SQL should be paid for already. If you do move those reporting systems to MySQL, you may have to take a log of time to rewrite the queries. Do you have any MySQL admin skills there? If not how much will it cost to get someone in or train someone up?Wed, 10 Jun 2009 10:09:44 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic732408-391-1.aspxTruth be told, I wouldn't. I am unaware of any tools or products that would read a MS SQL Server t-log backup and restore it to a MySQL database. Depending on the latency required, you may need to use SSIS to transfer data from MS SQL Server to MySQL.Wed, 10 Jun 2009 09:46:31 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic732408-391-1.aspxMy reporting infrastructure is set up in a way that there is a main production server that all the real-time reports and transactions happen on. That server ships logs to 3 other servers with read only databases. Those servers are responsible for processing all the SQL for the reports in the application that are not required to be real-time. For cost reasons I would like to replace those 3 SQL Servers with MySQL servers. If any of you were presented with this challenge, how would you make it work? Our database size is about 60GB but estimated to grow to many times that over time. Our largest table at the moment is 123 million rows and grows at a rate of 4.6 million per month.DavidWed, 10 Jun 2009 09:40:15 GMTdjones-1062714