I am using a log-bin file on each of the Servers and Each Server is a Slave of the Previous Server with the Last One in the Chain is the the Sever for the Save Number 1. any Topology will be fine as long as all the data is the same in all the Servers at the end of the day.

I don't know if they have a tool for that. You could search on their site or manuals. However, if I remember correctly, master.info is plain text so you can easily check it's contents. The need to optimize rises from a bad design.My articles[^]

Sounds to me like a homework question. How do YOU expect to achieve this? BobClarkSQL wrote: Please provide examples or free utilities or code generators that can accomplish this Try google. Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP

I did exactly this and made the new database follow standards closer then it did in access however I wrote a conversion program without about 10,000 lines of code. I would think that you could use a utility like this but you might not get the end result that you are looking for. Humble Programmer

But in that case, the question is only in data modeling. Create a single database and the necessary tables. In those tables record the tester name (or whatever is the way you separate them). This way everyon can have own results as ell as they can use others results. For example, if you have a table Measurement, it could have columns like: - MeasurementID, int, primary key, not null - Tester, int, not null, reference to Tester table - MeasurementTime, datetime, not null - MeasurementType, varchar(100), not null - MeasurementResult, int, not null etc. So when fetching results from a single tester you would restrict the query to only single Tester. But if you want to use other tseters, just modify the WHERE-clause. And what comes to the database, you can use Sql Server 2008 Express Edition. Just not that Express edition has these limitations: - 1 CPU - 1 GB memory - 4 GB of data per database The need to optimize rises from a bad design.My articles[^]

I will try it.

The Customer Specified and Suggested this configuration. I do not have to do it that way as long as is completely free and NoLicenses are requires. The end user must have the ability to retrieve data from the LocalDatabase at any time. The Database must be updated locally after each use or run and must all be available globally to the other 11 local machines (tester) or a master or supervisor machine (Tester) MASTER1 which is updated with all the other 11 localMachines (Testers) as well as its own local data. All records must be updated after each Machine (Tester) Cycle or the Next time that the machine (tester) is turned on it needs to update accordingly. Backups will be done locally on each machine at some specified frequency defined by the customer. Each machine has its own Unique Results and 1 Master or allMust have the others information avalaible to them to Query. I have the Database Created in MS Access for the first machine Tester) but the Customer will not accept it because it Requires Office or Licensing to be installed on 12 PC Platforms. SQL Server Express 208 willnot allow you to import a Database from MS Access and Save it as a SQLServer Express 2008 Database. Hope you can help. Regards BC