Mysql To Sqlyog

[Hedgehog]

Hi guys,

I am fairly new to this application. Lastnight, I installed MySql and also Sqlyog. My goal is to Import the Access database objects to Sqlyog but I'm not having a success doing it.

It goes through the ODBC import wizard successfully and then I see database on Sqlyog but I get an error or I can't access the data.

Any input regarding this matter will held me alot.

Thanks,

Hedgehog

[peterlaursen]

Quote:

but I get an error or I can't access the data.

When do you people learn to tell WHAT error you get! 😀

But I think it is likely that you did not unlock/unhide the metadata tables as described here: http://www.webyog.com/whitepaper/Preparing…__Migration.pdf

… that is a special thing about Access that the metadata tables are hidden. SQLyog needs acces to those tables if metadata (indexes etc) shall be imported. But it is of course only a guess of mine, that that is it!

Also read this article of mine:

http://www.databasejournal.com/features/my…p/10897_3550146

If you still are not able to solve the problem then we will need some info about your settings (screenshots, XML-file etc.)

[Hedgehog]

peterlaursen wrote on Oct 12 2005, 05:16 PM:

When do you people learn to tell WHAT error you get!  😀

But I think it is likely that you did not unlock/unhide the metadata tables as described here: http://www.webyog.com/whitepaper/Preparing…__Migration.pdf

… that is a special thing about Access that the metadata tables are hidden.  SQLyog needs acces to those tables if metadata (indexes etc) shall be imported.  But it is of course only a guess of mine, that that is it!

I did this.

Quote:

Also read this article of mine:

http://www.databasejournal.com/features/my…p/10897_3550146

If you still are not able to solve the problem then we will need some info about your settings (screenshots, XML-file etc.)

[post=”7545″]<{POST_SNAPBACK}>[/post]

I'll try this today.

Thanks Peter.

[Author]

Posts