Project Set Up Instructions
-
Each Project you do needs to be stored as a Project in the embedded data base. Everything to do with Project records is accessed through the Project Menu at the top of the form. Open the Project Form by selecting Create New Project from the Menu.
-
Most of the information required by the Project Form is simple just fill in.
-
For the database connection string you can paste a string into the form or use the connectoin builder. You will need to have a login with permission to access Schema, meta data. When you Test the Connection after entering or building the connection string fix-SQL will try to determine if you have appropriate permissions to access meta data. If an issue is detected your set up will be valid however the system may not work until you configure the correct permissions. If your not sure how to do this follow this link.Grant View Definition
-
In the Exclusions list page you need to add any recurring non sql words which are to be ignored in processing. An example of this would be a connection string variable used in the signature of a Method that is used by a helper class. You have probably seen the old SqlHelper class which is a good example of this. The placement of these types of variables is unpredictable so we need to explicitly tag them as words to be ingored by processing otherwise they could be interpreted as variables. The most recent fix-SQL version is quite reliable at doing this for you however, you have the ability to do this manually.
-
-
When you've completed and saved the Form you are ready to work with the project. You can edit any value at all in the Project file by selecting Project Menu and Edit Project. You can also load an existing project with Load Project Menu.
Security
You need to have Sql Server VIEW DEFINITION permissions at the database or object level to access the database Schema. The database data isn't required at all for fixSQL processing so use a schema only copy of the database with appropriate permissions. You should never work on a production database.The application cannot access data at all and cannot make changes to meta data.
-
Queries can be run for testing within fixSQL. It's recommended to not use production databases with fixSQL
-
The next release in August 2020 is free for currently registered users and will include comprehensive processing for writing Stored Procedures and converting dynamic SQL to Stored Procedures.
-
Support for User Defined Types are used in parameters when they are registered in the database along with all schema's.
-
Table joins are automatically listed for Auto Complete selection and take account of any aliases used in the query. You see them when you type or complete the keyword JOIN. These joins will take account of all existing joins in the query to maintain the integrity of the query and newly referenced tables through the join are added to Auto Complete.
Register fix-SQL
Registration of fix-SQL is done through the Application. Go to the Project Menu and select 'Buy fixSQL'. Complete your payment through the secure portal. You will receive an email in a few minutes with an ActivationID number. Select 'Enter Activation ID' from the Help Menu. Enter the ID into the box and fixSQL will be registered. The license you purchase does not expire however it is bound to the PC it was installed onto.