How do I share information between a Dozen Databases Locally and Globally without Licenses
-
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
-
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
BobClarkSQL wrote:
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
So, do you have an option to use only one cenralized database? Also is the network reliable all the time (this question actually included in the previous) or do you have to prepare for network failures? Since you have testers, I take it that information from the test run must reliably saved.
The need to optimize rises from a bad design.My articles[^]
-
BobClarkSQL wrote:
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
So, do you have an option to use only one cenralized database? Also is the network reliable all the time (this question actually included in the previous) or do you have to prepare for network failures? Since you have testers, I take it that information from the test run must reliably saved.
The need to optimize rises from a bad design.My articles[^]
As long as it is free and each local machine can get its local results as well as all the other 11 platforms data and Query each other and it is fre and seamless to the end user it really doesn't matter. It does not have to be fast it just need to be reliable and accurate. Any strategy that can accomplish this for fre is acceptable as long as local and master results can be received from each local machine.
-
As long as it is free and each local machine can get its local results as well as all the other 11 platforms data and Query each other and it is fre and seamless to the end user it really doesn't matter. It does not have to be fast it just need to be reliable and accurate. Any strategy that can accomplish this for fre is acceptable as long as local and master results can be received from each local machine.
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[^]