MySQL Forums
Forum List  »  Microsoft SQL Server

Re: Migrazione dati
Posted by: Milosz Bodzek
Date: June 02, 2015 01:58AM

Hi Stefano!

Stefano Santin Wrote:
> Sry I try to tranlate
> Goodmorning

> my three question are:
> There is a way to export some data from MSSQL to
> MySQL with WORKBENCH or other, not the whole
> table?

Sure, you can use wbcopytables for that. Basic syntax is:

wbcopytables-bin --source=<source db> --target=<target db> --table-where <source schema> <source table> <target schema> <target table> <source pk columns> <target pk columns> *|<select expression> <where expression>

> Can I progam thei work every evening?

Yes, you can use cron job for that.

> Can I program a simply upload the DB file to the
> site or dump the backup online every evening?

Yep, also cron job will help you.

> I tell you that I haven't not yet buy the MySQL
> service couse I want to be sure that I can make
> everything before I buy, couse if I can't I must
> find another way..
> Thanks


Milosz Bodzek
MySQL Developer Tools

Options: ReplyQuote

Written By
June 01, 2015 09:42AM
June 01, 2015 09:54AM
Re: Migrazione dati
June 02, 2015 01:58AM
June 03, 2015 02:04AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.