Q. When I tried converting a database using the upsizing Wizard it failed to convert all my data,
hope can you help me with this?
A. MUST automatically validates the date time fields and required fields listing and correcting any bad data,
this will remove any obstacles to converting your data.
Read more on this feature....
Q. After I have upsized my database, how can I move to a live system without repeating
all the upsizing steps and adding all my new design work into another SQL Server database?
A. MUST will automatically remove the database validation and constraints, drop the indexing,
empty the tables, then migrate the latest data, add back in the relationships and constraints and
put back the indexing for you.
Read more on this feature....
Q. How do I find out what the upsizing systems is doing as I want to be able to
make very subtle changes during the migration?
A. MUST not only directly upsizes into SQL Server, but can also generate
SQL Server script files to do the upsizing, you then get a script which creates
all your tables, constraints, indexing and can even import the data directly into SQL Server.
Read more on this feature....
Q. We have three Access databases, can we put them into one SQL Server database?
A. You can upsize as many databases as you like into a single SQL Server database,
but MUST also supports schemas which spit your database inside a single SQL Server database,
schemas can work like having several folders inside one database. The use of schemas becomes essential
in bigger applications. MUST can also split a single database up over multiple schemas.
One further point is security can be simply managed using schemas,
MUST will create your database roles and you have a simple interface for
planning the permissions on your schemas.
Read more on this feature....
Q. I have over 500 queries which I want to convert to views and stored procedures,
other tools only seem to convert a very small number of the queries, they fail for
any queries containing references to controls like Forms!Order!txtOrderId, what can I do ?
A. MUST+SQL not only converts on average over 86% of your queries, but it also
automatically identifies all screen controls, and creates a special parameter table
to replace them, in addition it modifies all the SQL to give a seamless
transition to getting the queries to work in SQL Server.
Read more on this feature....
Q. I have queries which have calculated fields referring to other
calculated fields is this going to be a problem?
A. Well SQL Server will not allow this, but MUST will automatically
re-write your SQL using a technique called nested SQL which will allow
your queries to continue working.
Read more on this feature....
Q. I have two Access tables with a relationship, I inherited this system and one side of the
relationship is a text 10 field, and the other a text 15 field. Will this be a problem?
A. SQL Server will not be happy with that, it will demand that you make both fields the same.
Thankfully MUST automatically detects and corrects this and allows you to select which size of field to use
before completing the upsizing.
Read more on this feature....
Q. I have a lot of queries which use my own special VBA function, why won’t they upsize?
A. They will with MUST+SQL, the product automatically identifies any custom VBA functions
and it generates a SQL Server function to replace your VBA function, you will need to
supply the body code for the functions after converting all your queries. The product also
comes with a built in VBA support library for Access functions which do not simply translate
into equivalent built in functions in SQL Server.
Read more on this feature....
Q. I want to add some auditing to my upsized database, can you do this for me?
A. MUST has an option to automatically add four fields to each table which track who and when records
were created and last edited. This is great for showing on your Access forms. For more demanding applications
MUST can also create a mirror of your key tables in an auditing database if you want to track all your
deletes and changes at a field level, the product automatically writes trigger code for keeping the auditing
database current with changes in your application.
Read more on this feature....
Also read ...
Q. Once I have upsized, can I ever take away an Access copy of the database design and data?
A. Although you can’t get everything back, MUST can reverse engineer a SQL Server
database design and pull the data back into Access. This can be useful when you still prototype
with Access and want to use one of your existing SQL Server designs as a starting point for an Access prototype.
Read more on this feature....
Q. I downloaded you trail version of the software and was very impressed, but why
did it not let me upsize the relationships?
A. Ah yes, we have to give you an incentive to buy our full product. The trial version has a
few limitations built in, but we guarantee you will be able to do this in the full version.
Don't just take our word for this, read our testimonials from customers.