'peterlaursen' wrote:
To import from Access you will not need the 'myODBC' driver, but only the driver for Access/.mdb (that ships with Windows). SQLyog will not need a driver to connect to MySQL – but needs it in order to connect to Access. Actually in the wizard there is a direct option to import from Access and you will not even need to configure a DSN (but that is added after the article you refer was published),
Two more things you should know:
1) in the TRIAL you can import 2 tables per job and no more
2) As far as I remember the Northwind database has 'relationships'. To import those as Foreign Keys in SQLyog the security settings for teh access file must be modified. I will try to find the link about this for you
“Actually in the wizard there is a direct option to import from Access”,
Yeah, Peter, after posting the question, I did exactly that, and it worked. Now, I have two more questions.
A) MySQL may not be a solution for me… someone on mySQL ng just alerted me that I may not be able to bundle it in my software distribution…
😎 I'm not a MySQL guy, not sure why the following “mySQL favored” DDL statement generated by Webyog failed…
alter table `myDB`.`myTBL`
change `future` `future` bit(1) NULL ,
change `active` `active` bit(1) default '1' NOT NULL;
Thanks.
Don
