Were having some real difficulties with MySQL across platforms (especially re-installing etc. and looks like we’re not alone in that!), so we’re looking into the possibility of migrating to Sybase.
I’ve no doubt that Sybase will be fine after the migration - and I know I can get our data into it simply by importing the loaded solution into a sybase connected Servoy but I have one concern.
We use SQLDump fropm MySQL to keep multiple developers Db’s in sync, does Sybase Central make that easy to do too?
Does it have the equivalent SQLDump facility or is there a different way to keep multiple copies of the databases in sync (without getting too sophisticated with sync auto-tools etc)?
Appreciate feedback from experienced Sybase users.
SQL Anywhere has a dump facility similar to SQLDump. You can access it via the Sybase Central GUI (unload database), or via the command line (dbunload). That said, Marcel makes a good suggestion…
I understand what you say about MySQL (and I am sorry but I have no answer).
But this is what I fail to understand:
We use SQLDump fropm MySQL to keep multiple developers Db’s in sync, does Sybase Central make that easy to do too?
Aren’t a centralized repository or SVN better equipped tools to do that?
Marcel - thanks for the feedback - currently we use an SVN for the code aspects of the solution but we’ve had challenges attempting to set-up a shared SQL Db centrally (we dont have a shared server that’s fast enough currently) but it’s worked out pretty well using a SQLDump process - when 1 developer changes the structure of the dev Db he dumps it and others grab it as necessary and ExecuteSQL to sync up. Usually only once or twice a week.
Can you suggest a better route for this Marcel (we’re using Project Locker and Subversive for SVN)?
Well, for database versioning and refactoring you might want to take a look at Liquibase.
Especially the commandline version of it (there is no mature enough GUI yet).
YES, Liquibase rocks!
This is not a simple diff tool, but actual Database refactoring, that’s the whole idea.
The command line is very mature and there’s even an option to use web services to deploy your refactored schema on a production server.
I’m currently contemplating using it as a regular tool in our production process. And I’m dreaming of an integrate version of that in Servoy