Thursday, June 21, 2012

Re: Moving data from MS SQL to Google cloud SQL

Hi Patrick,

Since Cloud SQL only offers Web based interface, I would suggest using
existing tools for migration to local MySQL environment first, then
taking mysql dump, uploading the dump to Google Cloud Storage, and
then importing your dump to the Cloud SQL instance.

For more details, please see:
https://developers.google.com/cloud-sql/docs/import_export

You can also create your own migration tool by using google_sql.jar:
https://developers.google.com/cloud-sql/docs/external

Hope it helps,

-- Takashi

On Thu, Jun 21, 2012 at 7:06 AM, Pat <patrick.mcdonald@bairdwarner.com> wrote:
> What are the best ways to move a few tables from an MS SQL database to the
> google cloud SQL for use with app engine? The tables are mostly not that big
> (a few thousand records), and some will need to be updated somewhat often.



--
Takashi Matsuo | Developer Advocate | tmatsuo@google.com

No comments:

Post a Comment