RE: compare tables from two systems

2005-10-06 Thread Tim Hayes
t database to update it and put it back in synch. Tim Hayes -Original Message- From: Rhino [mailto:[EMAIL PROTECTED] Sent: 05 October 2005 23:25 To: Claire Lee; mysql@lists.mysql.com Subject: Re: compare tables from two systems - Original Message - From: "Claire Lee" &l

RE: good database design

2005-09-22 Thread Tim Hayes
y you should start worrying abt the DB Tuning and harware requirements. sujay -Original Message- From: Ian Sales (DBA) [mailto:[EMAIL PROTECTED] Sent: Thursday, September 22, 2005 2:17 PM To: [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Subject: Re: good database design Tim Hayes wrote: >I

RE: good database design

2005-09-22 Thread Tim Hayes
customers happy. Tim Hayes MYdbPAL - www.it-map.com -Original Message- From: Martijn Tonies [mailto:[EMAIL PROTECTED] Sent: 22 September 2005 09:02 To: mysql@lists.mysql.com Subject: Re: good database design > I need links about good database design information for high loaded

RE: Changed Number

2005-04-06 Thread Tim Hayes
Ken Looks like you used a medium int field on the mysql table - if you import a figure that is too big for the medium int to handle - on overflow it places a value of 8388607 into the colum. You need to change to an integer column. Regards Tim hayes -Original Message- From: [EMAIL

RE: Need Help with 813-MDB File

2005-03-30 Thread Tim Hayes
David Please also have a look at MYdbPAL for MySQL. Freeware again - this will sort out any schema conversions you might need - auto corrections. Plus you can model the schema. MDB conversion is shown in the tutorials. Tim Hayes -Original Message- From: David Blomstrom [mailto:[EMAIL

RE: Need help coverting MDB > SQL

2005-03-26 Thread Tim Hayes
Try MydbPAL at www.it-map.com. Its a FREE product that will do a complete .mdb (access) to My SQL translation - schema and data. There is a learning curver but you can follow the tutorial which takes you thru an mdb conversion Tim Hayes -Original Message- From: Rhino [mailto:[EMAIL

BIGINT UNSIGNED issue?

2005-02-23 Thread Tim Hayes
misunderstanding something? Tim Hayes -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: How to Version Control a database

2005-02-20 Thread Tim Hayes
Try using MYdbPAL from www.it-map.com . The product has complete schema version control, alowing you to track changes and compare sche,as for diffrences. Its FREE to MySQL users. Tim -Original Message- From: Will Merrell [mailto:[EMAIL PROTECTED] Sent: 20 February 2005 14:00 To: Mysql M

RE: Pulling a database schema out of a unknown MySQL database?

2005-02-02 Thread Tim Hayes
Dan Please try MYdbPAL for MySQL - www.it-map.com. It is FREE, and you can reverse-engineer the schema; view, model, forward engineer etc. Tim Hayes -Original Message- From: Dan Stromberg [mailto:[EMAIL PROTECTED] Sent: 02 February 2005 12:31 To: mysql@lists.mysql.com Cc: [EMAIL

RE: Data and strucuture importing from MSAccess to MySQL

2005-01-29 Thread Tim Hayes
/solutions/archives/002944.asp Tim Hayes -Original Message- From: Paun [mailto:[EMAIL PROTECTED] Sent: 29 January 2005 04:44 To: mysql@lists.mysql.com Subject: Data and strucuture importing from MSAccess to MySQL Which way is easier to import data and structure of database from

RE: Using Visio to diagram MySQL db, export SQL

2004-09-28 Thread Tim Hayes
ari MYdbAL which you can download at www.it-map.com is completely FREE and includes data modeling, DDL generation or whatever you need to create your MYSQL database. Tim -Original Message- From: Ari Davidow [mailto:[EMAIL PROTECTED] Sent: 28 September 2004 12:59 To: [EMAIL PROTECTED] Sub

RE: Data fields from one database to another

2004-09-28 Thread Tim Hayes
record. Stuart --- Tim Hayes <[EMAIL PROTECTED]> wrote: > Try using MYdbPAL - its a new free program that will > do the job plus lots of > other goodies. > > www.it-map.com > > Tim Hayes > > -Original Message- > From: Stuart Felenstein [mailto:[EMAIL PROTEC

RE: Data fields from one database to another

2004-09-28 Thread Tim Hayes
Try using MYdbPAL - its a new free program that will do the job plus lots of other goodies. www.it-map.com Tim Hayes -Original Message- From: Stuart Felenstein [mailto:[EMAIL PROTECTED] Sent: 28 September 2004 08:23 To: [EMAIL PROTECTED] Subject: Data fields from one database to another

Re: Table Name Case Sensitivity

2004-02-23 Thread Tim Hayes
OK There is still the possibility of an in-compatability between the 2 platforms. However - in both Linux and Windows (MySQL 4.0.17) the variable is not recognized / updateable using the set command! I get - Unknown system variable 'lower_case_table_names' Tim Hayes - Origin

Table Name Case Sensitivity

2004-02-23 Thread Tim Hayes
umn Names have to be unique in both environments. Q. Is there some sort of practical advantage for having case sensitive table names in Linux, or is this a design "shortcoming"? Postgress rejects duplicate table names. Thanks Tim Hayes