KeyFixer gives you the ability to automatically replace any key everywhere in any Microsoft SQL database.
Examples:
- Change the Customer number
- Change Item Number
- Change Vendor Number
- Change G/L Account Number
- Change Product Category
- Change Material Cost Account
Any key... everywhere... in any Microsoft SQL database
KeyFixer is easy to use:
- Decide on the key you need to change (Item_No for example)
- Decide if you want to change that exact key name, or key names like it (Parent_Item_No for example)
- Create a text file with old values and new values
- Run KeyFixer - it will update every table in your database with that key name from the old value to the new value
- Sit back and watch it run. Viola! You are finished!