SQL 2008 Express Database Auto Generation and Cross Chaining at 10Gb
$10-30 AUD
Completed
Posted over 10 years ago
$10-30 AUD
Paid on delivery
This MICRO Project requires the development of an MS SQL Server 2008+ EXPRESS Database solution that is required to automatically generate new databases using a MASTER Database (RDBMS) to Create and Manage CHILD Databases. It is important to not these databases will be receiving data in RealTime and may update more than once per minute. If you are NOT an MS SQL expert do not attempt this project. The Database RECOVERY Model needs to be SIMPLE – Not FULL for CHILD Databases to prevent logging.
Milestones:
1. Create Simple MASTER Database to manage CHILD Databases. Create a table that will be used to manage the naming and cross-chaining of CHILD databases using a single SELECT statement. Each database creation will require a time of creation stored. Once it is full it needs to be update with the total tables and rows that the FULL CHILD database contains.
2. Generation and Update Scripts - Generate scripts that will be used as Stored Procedures or Triggers to create new CHILD databases automatically as they approach their capacity of 10 GB. The same schema (table design) applies to each CHILD database table; 1 NvarChar(5), 1 Datetime, 4 Decimal (6,2) fields. This schema may change after the project is delivered.
3. Naming Conventions - The generated CHILD database name needs to be generated from an alphanumeric code value stored in the MASTER and suffixed with the database create date formatted as “_ddMMyyyy”.
4. Cross-Chain Select - The MASTER needs a sample Select Statement that interrogates and lists the data from the CHILD databases. It is proposed that at least 3 different CHILD database Tables would be generated from the MASTER, e.g. Table1, Table2, Table3
5. Dummy Data Population - The solution also needs a dummy data generator to simulate the process in minutes and not days. This would simply populate the CHILD database Tables with the same data until it is full and automatically create the new CHILD as the Trigger or Stored Procedure fires. The dates would be sequential with 1 second separation for ease of construction. The decimals can be random.
If you are a SQL Expert but have not done this type of auto generation process the following link may help.
[login to view URL]