The move to convert your database from Microsoft Access to SQL Server to benefit better performance, stability, and security is generally what most developers would recommend in a large scale database application. This operation is called “Upsizing” and once it is done, clear distinctions and variances in performance and security aspects will be noticed.
Access and SQL Server both share certain similarities, but for the most part they vary from each other. Both differ in their method of storing data and indexing, data types, and in their capacity. Microsoft supplies an Upsizing Wizard to help you migrate to SQL Server. The wizard will examine your current data and structures and systematically convert them to SQL Server format however it is very limited and often issues are encountered in complex databases and will require professional assistance.
During conversion of database and database object from Access to SQL Server format it should be noted, however, that there are unsupported properties in both systems that would signal the alarm for some serious problems. In this regard, it is best to always examine and correct latent issues capable of erupting before, during, and after the process of conversion. It is vitally important is to carefully review the database result to verify that records, tables, and relationships were properly converted.
Creativ provided solutions that not only produced a great website that matched our needs, but also took care of all the marketing of the new site. This has led to increased sales which is a great result. Creativ gave freely of their time, and also had the patience to explain the process as we went along.
I would have no hesitation in recommending Creativ to other companies for their web development and marketing needs.
The Harbord Kindergarten Website was created by Scott Donald of Creativ Digital. We were impressed by Scott’s professionalism and easy going attitude to designing our website and our many requests and changes to it. As this was our first foray into website design/setup we were very happy with the outcome. The website is easy to update and maintain which was a major factor in choosing Creativ Digital.
After being with another Web-Designer for 5 years I met Scott who suggested improvements to my website. Creativ Digital created very pleasant and functional site for me. I received great service and friendly advice at each stage of the process. The new website looks great and is easy to update. I would recommend Creativ Digital.