data migration question

2004-09-23 Thread sean c peters
I have a table that i am modifying the schema of, and am having a particular problem with my data migration program. The old format has a column defined as: Range char(3) not null default '', which is either'' or contains a number (1 or 2 digits), and is sometimes followed by a direction

RE: Migration question

2004-02-10 Thread Brian L. Walter
experiment:) The query/view option was in reality a cheat to get things done and working. Regards Brian -Original Message- From: Daniel Kasak [mailto:[EMAIL PROTECTED] Sent: Sunday, February 08, 2004 3:27 PM To: Brian L. Walter; [EMAIL PROTECTED] Mysql. Com Subject: Re: Migration question

RE: Migration question

2004-02-08 Thread Brian L. Walter
Thanks for your reply. Let me try again. In access, you can create views. These are called 'queries' in Access. The current version of MySQL does not support views, as I understand it. Using DBManager, I import all my tables and data to MySQL from Access. One of the options during the import

Re: Migration question

2004-02-08 Thread Daniel Kasak
Brian L. Walter wrote: Thanks for your reply. Let me try again. In access, you can create views. These are called 'queries' in Access. The current version of MySQL does not support views, as I understand it. Using DBManager, I import all my tables and data to MySQL from Access. One of the

Migration question

2004-02-07 Thread Brian L. Walter
Greetings, I'm in the process of migrating from Access to MySQL. I've imported access queries into MySQL, and they do show up (using a third party db manager, they show up under tools). In Access, queries can be used like views. I.e. you can select from them. Now, the version of MySQL I'm

Re: Migration question

2004-02-07 Thread Daniel Kasak
Brian L. Walter wrote: Greetings, I'm in the process of migrating from Access to MySQL. I've imported access queries into MySQL, and they do show up (using a third party db manager, they show up under tools). In Access, queries can be used like views. I.e. you can select from them. Now, the

migration question

2001-03-12 Thread Jean-Francois Duckett
Hi, What would be the workaround for migration from linux redhat 6.2 with mysql 3.23 to windows 2000 with mysql. I have a database dump in mysql 3.23 for linux. Merci, Jean-Francois Duckett [EMAIL PROTECTED] 514.281.0905 - See the world, Set the price - www.thedailyauction.com