June 21, 2013 at 5:07 am
I have a client who is currently using a Microsoft Access Database system to store data of which the system has the maximum capacity storage of up to 2 GB. The system is currently 1.4G and is estimated to reach 1.6 GB in about 6 month’s time. **I would like to know if whether does ms sql server 2012 have a UI (user Interface ) part that can be used to develop the Front-end/User Interface of the tool** **Does it have the ability to convert the current UI, developed in CLARION?** PLEASE ASSIST...
June 29, 2013 at 5:32 pm
SQL Server is an Enterprise class data platform and focus is heavily placed on data-tier operations therefore it has no front-end development tooling.
Access is sometimes thought of as SQL Server's little brother. Access is actually an application and a database rolled into one but it sounds like you have a Clarion application connecting to an Access database. Access does have an "Upsizing Wizard" which can help you create and migrate your Access database to a SQL Server database. My first question is, can the Clarion app be modified (easily) to connect to a SQL Server instead of to Access provided the data model were unchanged, save for maybe some minor data type differences?
If not, you could still use Access as middleware allowing your Clarion application to continue to connect to Access yet have your data stored in SQL Server. Microsoft has a growth-path that will let you offload the tables from Access to SQL Server via the use on "Linked Tables". If you migrate your tables to SQL Server and replace then with Linked tables in Access then Clarion will not need to change.
Regarding potentially replacing Clarion. If you're serious about rewriting something using best of class technology then a .net application would be the initial direction I would explore.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply