Hi Sretlaw,
There are two reasons for your experience:
1. Currently, blueshell Data Guy (bDg) always uses autoincrement on any type that supports autoincrement. I agree, that this can be misleading and we're considering to change this behaviour. But there's always an escape: Choose the common type Long that maps to SQL Server's int.
2. In order to provide easy transfer from one database to another (e.g. from Oracle to SQL Server), bDg maps types. That is the reason why your _varchar columns are displayed as _text and _int columns are displayed as Long. Don't worry - they are still SQL varchar and int respectively. It is on our to-do-list to display the native types while retaining the mapping capabilities.
Thanks for your input!
- Harry