[mdb-dev] mdb-schema for MsSql/sybase

[Carl K. <ca...@pe...>]

Has anyone made any attempts to add support for MsSql?

what I am really interested in is converting the RI into something that MySql
WorkBench or dbd4 from http://fabforce.com can read.  so far the only thing that
has worked for me is dbd4 to MsSql.

few comments:  oracle and MsSql have the same syntax for "add constraint", so 
this will work for both:

         switch (backend) {
           case 1:  /* oracle */
                 text = g_strconcat("alter table ", bound[1],
                         " add constraint ", bound[3], "_", bound[1],
                         " foreign key (", bound[0], ")"
                         " references ", bound[3], "(", bound[2], ")", NULL);
                 break;
         }

but... backend is 1 for oracle, 0 for everthing else due to this code:

     249     int backend = 0;  /* Backends: 1=oracle */

     254     if (strncmp(mdb->backend_name,"oracle",6) == 0) {
     255         backend = 1;

so I hacked in a case for sybase:
     256     } else if (strncmp(mdb->backend_name,"sybase",6) == 0) {
     257         backend = 2;

Now for the tricky part: the RI needs Primary Key's defined, and that curretnly 
isn't happening.

Anyone have some code to detect/generate Primary Key defs?


Carl K