[odb-users] Easiest transition from SQLite

[Andrew Cunningham]

Hi Boris,

Thanks for the feedback. I experimented and , as you suggested I would find
the case, I was able to get a MySQL/ODB test going pretty easily.

SQL Server Express 2014 was a nightmare because of apparent conflicts with
previous SQL Server editions installed on my machine. After hours of
messing around ( nothing to do with ODB) to just add a system "Data Source"
that used SQL Server Express 2014 I was forced to give up.

Andrew



On Tue, Feb 23, 2016 at 6:39 AM, Boris Kolpackov <boris at codesynthesis.com>
wrote:

> Hi Andrew,
>
> Andrew Cunningham <andrew at a-cunningham.com> writes:
>
> > I want to experiment with moving my ODB/SQLite to MySQL, Postgres, MSSQL,
> > Oracle....
> > The database would be hosted on the same machine as the client process.
> >
> > So typically what is the easiest/simplest server database to experiment
> > with and set up?
>
> Any client-server database will be a lot more cumbersome to use in this
> setup than SQLite. Especially on Windows. Just a warning ;-).
>
> Also, while I have no experience with it whatsoever, MySQL has something
> called an embedded server. Maybe it's worth exploring...
>
> Next is MySQL vs PostgreSQL: my suggestion, is, unless you have a very
> good reason, to go with Postgres.
>
> Finally, SQL Server and Oracle will probably be even more difficult to
> setup, especially if you want to support multiple platforms.
>
> Boris
>