Editor: This application introspect a database by using the ColdFusion tag cfdbinfo and creates the Transfer ORM Config file based on setting you specify on the environment.xml file and the UI.
You can set a few config settings depending on what best works for you:
•UUID Convention - This is meant for SQL server that does not have UUID data type but instead we use Char(35),so if you have this turned on every time a Char(35) is found will be interpreted as a UUID data type. •Generate PK - ask transfer to generate the PK value for you. •Collection Type - lets you choose wich collection type you want to use for the OneToMany relationships. •Relationship type to use - In transfer you can pick whether to use the ManyToOne or OneToMany relationships and this will vary depending on your needs. As of now you can only select this as a general setting meaning whatever you pick it will be used on all the Objects created. However both relationships will always be created, it'll just comment out the other one. So if you want to change for one or the other after the file is created all you need to do is uncomment those lines. •File name - By default I have the file named transferX.xml. The destination of the file you can change for each site in the environment.xml file mentioned below.
Enhancements and Fixes: I just added version 1.0.1 of Transfer Config this includes the following fixes and enhancements:
•Fixed: App would break if database in use contained a table with no primary key defined. •Enh: change app to be able to run in transferConfig subfolder (can be run directly under the root) •Enh: added ability to pick DSN directly from the view/form. The way this will work depends on your settings:
If you have the Admin password for CF you can added to the environment.xml.cfm file and the CF Admin API will be used to get a list of DSN's. oIf don’t have Admin privileges on the server, it will try to use the CF serviceFactory to get a list of the DSN’s.