[AccessD] Access 2007 Upsizing Wizard Missing

John,

To be sure, you're undertaking a significant bit of work in your transition
to Maria, now that you've included sprocs and views (actually, the views
ought to be simple, but the sprocs may need some work, due to slight syntax
differences).

As for compression, Maria does it differently but your FE should not
experience differences nor require changes, methinks.

Anyway, you've got cojones, so go for it (in parallel) until you're
satisfied with the transition.

Best of luck, and break a leg.


On Wed, Feb 19, 2014 at 11:13 AM, John W Colby <jwcolby at gmail.com> wrote:

> Well... we shall see.  I have a custom written major application which
> talks to SQL Server.  It uses BCP to export data out of SQL Server to
> files, and then uses BCP to import files back in to SQL Server.  So I will
> have to replace that with whatever the MySQL equivalent is.  I have to
> export databases containing hundreds of millions of records (and hundreds
> of gigabytes)  into matching tables in MySQL.  I have to build indexes.   I
> have to research whether MySQL has compression, which I am using on my data
> to get it all to fit into memory.  I have to build views matching the views
> I use in SQL Server.  I have stored procedures that perform tasks for me.
>
> It sounds like a major undertaking to me.  If I succeed then I will have a
> major tool in my belt.
>