MUST is developed by an accomplished upsizing practitioner ; it is much more than a manufacturer’s ‘tick the box’ tool. Numerous features are available to fix the underlying issues that cause upsizing errors. Even troublesome unique indexes with multiple nulls are seamlessly converted to triggers. E
very row in the database is accounted for. Changes, fixes, errors and much, much more are logged, pinpointing any residual issue. The querydef conversion rate I achieved was well over 90%. There is a solution for embedded form references and a test harness for checking the upsized results. Queries that don’t upsize because, say, they reference linked spreadsheets are clearly identified. Optionally, SQL scripts are generated making the process reproducible. Ideal for our phased deployment of read only users first, with a daily overnight data refresh from Access to SQL Server during the transition.
...Read More
Gillian Mackenzie, DBA, BizzEnergy Limited (UK)