Dylan,
Even if I knew how to make flat files from MySQL, I wouldn't tell you...and here's why:
I take particular interest in this article. While I tend to eschew MS as a whole (...yeah right, as my email comes from Hotmail--well FYI hotheads [some of whom I've heard from privately], I got this email address before MS bought them!!!), I would consider myself a relative expert in MSSQL, and actually enjoy the product. I have had great success using it in combination with Open Source Front Ends, and Open Source middle tier business app.s...(mainly Java, but some PHP, and some Python).
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.
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.
I can explain this to you if you like...but you can probably find the information you need on Microsoft.com or MSDN.
...My 2 cents.
Don't give 'em shit...give 'em the straight poop, and stand-up for what is right...at least technically...regardless of platform.
By the way...while it is always painful to see a curtain closing on your window of influence...just take it in stride, knowing that you are bound for far more important things.
Oh, and one more thing, now that the Open Source DBs are becoming more robust...I am definitely being swayed in their direction.
Cheers,
matthew
----Original Message Follows----
From: Dylan Beaudette <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED],lugod's technical discussion forum <[EMAIL PROTECTED]>
To: "lugod's technical discussion forum" <[EMAIL PROTECTED]>
Subject: Re: [vox-tech] Export MySQL DB to flat file
Date: Mon, 25 Oct 2004 13:56:04 -0700
MIME-Version: 1.0
Received: from www.livepenguin.com ([66.218.54.136]) by mc10-f29.hotmail.com with Microsoft SMTPSVC(5.0.2195.6824); Mon, 25 Oct 2004 13:53:08 -0700
Received: from ns1.livepenguin.com (localhost [127.0.0.1])by www.livepenguin.com (Postfix) with ESMTP id 26C3EB018D;Mon, 25 Oct 2004 13:53:06 -0700 (PDT)
Received: from tripoli.ucdavis.edu (tripoli.ucdavis.edu [169.237.104.169])by www.livepenguin.com (Postfix) with ESMTP id 7831790A87for <[EMAIL PROTECTED]>; Mon, 25 Oct 2004 13:53:02 -0700 (PDT)
Received: from basho.dept-lawr.ucdavis.edu (pes2141b.dept-lawr.ucdavis.edu[169.237.35.250])by tripoli.ucdavis.edu (8.12.10/8.12.9/it-defang-5.2.0) with ESMTP idi9PKqxEp024208for <[EMAIL PROTECTED]>; Mon, 25 Oct 2004 13:53:00 -0700 (PDT)
X-Message-Info: yilqo4+6kc6uK0eE/qfSVnmHyMtyMZMN
X-Original-To: [EMAIL PROTECTED]
Delivered-To: [EMAIL PROTECTED]
User-Agent: KMail/1.6.2
References: <[EMAIL PROTECTED]><[EMAIL PROTECTED]>
In-Reply-To: <[EMAIL PROTECTED]>
Message-Id: <[EMAIL PROTECTED]>
X-Scanned-By: MIMEDefang 2.41
X-BeenThere: [EMAIL PROTECTED]
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: lugod's technical discussion forum <vox-tech.lists.lugod.org>
List-Unsubscribe: <http://lists.lugod.org/mailman/listinfo/vox-tech>,<mailto:[EMAIL PROTECTED]>
List-Archive: <http://ns1.livepenguin.com/pipermail/vox-tech>
List-Post: <mailto:[EMAIL PROTECTED]>
List-Help: <mailto:[EMAIL PROTECTED]>
List-Subscribe: <http://lists.lugod.org/mailman/listinfo/vox-tech>,<mailto:[EMAIL PROTECTED]>
Errors-To: [EMAIL PROTECTED]
Return-Path: [EMAIL PROTECTED]
X-OriginalArrivalTime: 25 Oct 2004 20:53:08.0445 (UTC) FILETIME=[A1D9B8D0:01C4BAD4]
On Monday 25 October 2004 12:52 pm, Rod Roark wrote: > On Monday 25 October 2004 12:20 pm, Dylan Beaudette wrote: > ... > > > We had a beautiful system for managing about 500 volunteers written in > > PHP/MySQL and running on a linux machine, that was set to be moved to a > > MacOS X box for permenant use... Now it would seem that after some > > re-shuffling of administrative departments this is no longer the case, > > and they want the application re-written in ASP/MS-SQL... > > All that for 500 volunteers? I wonder how that will work > out in terms of development expense per volunteer. Sounds > like someone wants MS SQL on their resume. >
Actually, it sounds like a department that refuses to support, or even put up
with anything non-MS... even existing systems that need only be hosted.
ah well...
Dylan
PS: thanks David and Mark for the ideas! _______________________________________________ vox-tech mailing list [EMAIL PROTECTED] http://lists.lugod.org/mailman/listinfo/vox-tech
_______________________________________________ vox-tech mailing list [EMAIL PROTECTED] http://lists.lugod.org/mailman/listinfo/vox-tech
