Search code examples
sqlmysqlsybasedata-migration

How to get mysql to accept sybase database..table notation

I'm porting a sybase application to mysql and of course there's tons of sql compatibility issues, but one that I don't see an easy way out of without changing every single sql is that in sybase you can refer to a table by db..table notation, but in mysql it requires db.table. I'm kinda on mysql's side on this one, but this is what it is. Is there a way to get mysql to accept that syntax?

Solution

  • I ended up doing something like this:

    global replace .. with " + Defs.DELIMETER + "
Then replace " + Defs.DELIMETER + ".  with ...  to take care of elipses
Then replace " + Defs.DELIMETER + "" + Defs.DELIMETER + "  with .... for those cases.

    That got most of them. So at least now it's easily changable.