l i n u x - u s e r s - g r o u p - o f - d a v i s
Next Meeting:
July 7: Social gathering
Next Installfest:
Latest News:
Jun. 14: June LUGOD meeting cancelled
Page last updated:
2004 Oct 26 10:13

The following is an archive of a post made to our 'vox-tech mailing list' by one of its subscribers.

Report this post as spam:

(Enter your email address)
Re: [vox-tech] Export MySQL DB to flat file
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [vox-tech] Export MySQL DB to flat file

On Tue, 26 Oct 2004, matthew lange wrote:


> That said...these people are complete ignoramuses.  If they don't realize 
> that all they need is an ODBC driver for MySQL in order to access the DB 
> directly from MSSQL, (which is always more preferable than converting the 
> data to flat files), and that they can then populate their own MSSQL local 
> tables through querying what MS calls a 'linked server' (--formerly referred 
> to by MS as a 'remote server'),which is just a regular query to the MySQL 
> server--then they don't really know their own product very well, and you 
> want to be as far from them as possible.

Alternative explanation: The message they are sending to management is "M$
is interoperable with M$, and those free products are not interoperable,
so we have to break the data back down to the simplest possible form.  See
how hard it is to work with Free Software? You get what you pay for!"

> If I were you, I would, in front of the appropriate authority figure, 
> espouse the benefits of accessing the 'real' data, as it is stored on MySQL, 
> rather than capitulating to the ignorance of the hack (i.e. definitely not 
> "hacker"), who is staking his/her claim to your data, and relying on an 
> inferior method of data transfer through flat files.

For day-to-day work, there can be some glitches in this kind of
arrangement that require MySQL-specific familiarity... but you are right
that anyone should be able to fathom that this is a better way to
implement a data migration.

Jeff Newmiller                        The     .....       .....  Go Live...
DCN:<jdnewmil@dcn.davis.ca.us>        Basics: ##.#.       ##.#.  Live Go...
                                      Live:   OO#.. Dead: OO#..  Playing
Research Engineer (Solar/Batteries            O.O#.       #.O#.  with
/Software/Embedded Controllers)               .OO#.       .OO#.  rocks...1k

vox-tech mailing list

LUGOD Group on LinkedIn
Sign up for LUGOD event announcements
Your email address:
LUGOD Group on Facebook
'Like' LUGOD on Facebook:

Hosting provided by:
Sunset Systems
Sunset Systems offers preconfigured Linux systems, remote system administration and custom software development.

LUGOD: Linux Users' Group of Davis
PO Box 2082, Davis, CA 95617
Contact Us

LUGOD is a 501(c)7 non-profit organization
based in Davis, California
and serving the Sacramento area.
"Linux" is a trademark of Linus Torvalds.

Sponsored in part by:
O'Reilly and Associates
For numerous book donations.