SQL Server has bcp, which let's you dump tables with a fair degree of control over format -- I'd bet Sybase has something similar.
Or you could use DTS in MSSQL to do an export to Sybase. Both of those save writing queries :) Regards, John Paul Ashenfelter CTO/Transitionpoint [EMAIL PROTECTED] ----- Original Message ----- From: "Joshua Miller" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, January 13, 2003 11:32 AM Subject: RE: Emulators/VMWare for Mac (WAS: Re: Unix database syntacticall y similar to SQL Server?) > I got CFMXJ2EE/JRun4/Sybase_ASE up and running on my Mac ... Seems to > work pretty well, now if someone only made a utility that would allow me > to move data from SQL Server to Sybase without having to write queries. > > Yes, I AM lazy - thank you very much. > > Joshua Miller > Head Programmer / IT Manager > Garrison Enterprises Inc. > www.garrisonenterprises.net > [EMAIL PROTECTED] > (704) 569-9044 ext. 254 > > ************************************************************************ > ************* > Any views expressed in this message are those of the individual sender, > except where the sender states them to be the views of > Garrison Enterprises Inc. > > This e-mail is intended only for the individual or entity to which it is > addressed and contains information that is private and confidential. If > you are not the intended recipient you are hereby notified that any > dissemination, distribution or copying is strictly prohibited. If you > have received this e-mail in error please delete it immediately and > advise us by return e-mail to [EMAIL PROTECTED] > ************************************************************************ > ************* > > > -----Original Message----- > From: Roberson, Jeff, Mr (Contractor) ACI > [mailto:[EMAIL PROTECTED]] > Sent: Monday, January 13, 2003 11:20 AM > To: CF-Talk > Subject: RE: Emulators/VMWare for Mac (WAS: Re: Unix database > syntacticall y similar to SQL Server?) > > > You can also run virtualPC with windows for mac to get the SQL server > > http://store.apple.com/1-800-MY-APPLE/WebObjects/AppleStore.woa/98/wo/VF > 67Rc > 18Gpi42MkkyAbB0CAsg2i/2.4.0.3.27.10.11.5.13.0 > > But I agree you will need lots of ram > > -----Original Message----- > From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED]] > Sent: Monday, January 13, 2003 11:11 AM > To: CF-Talk > Subject: Emulators/VMWare for Mac (WAS: Re: Unix database syntactically > similar to SQL Server?) > > > Requirements for VMWare (for Linux) are remarkable low, but you need a > *lot* of memory, decent disk space, and solid processor. I run Linux and > Windows emulations under Windows 2000 with 512MB and PIII/500 -- but > like it better on the P4 1+ GHz and 1 GB RAM. > > Did a little research and not a solution (obviously) for Mac. Looks like > x86 architecture is part of the lowlevel emulation -- not that I know > anything about hardware emulation in software :) > > Regards, > > John Paul Ashenfelter > CTO/Transitionpoint > [EMAIL PROTECTED] > ----- Original Message ----- > From: "Joshua Miller" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Monday, January 13, 2003 10:54 AM > Subject: RE: Unix database syntactically similar to SQL Server? > > > > I wonder what kind of system specs would be required to run an > > emulator, MS SQL Server, CFMXJ2EE, JRun4 and Jedit on a Mac? > > > > Joshua Miller > > Head Programmer / IT Manager > > Garrison Enterprises Inc. > > www.garrisonenterprises.net [EMAIL PROTECTED] > > (704) 569-9044 ext. 254 > > > > ********************************************************************** > > ** > > ************* > > Any views expressed in this message are those of the individual > sender, > > except where the sender states them to be the views of > > Garrison Enterprises Inc. > > > > This e-mail is intended only for the individual or entity to which it > > is addressed and contains information that is private and > > confidential. If you are not the intended recipient you are hereby > > notified that any dissemination, distribution or copying is strictly > > prohibited. If you have received this e-mail in error please delete it > > > immediately and advise us by return e-mail to > > [EMAIL PROTECTED] > > > ************************************************************************ > > ************* > > > > > > -----Original Message----- > > From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED]] > > Sent: Monday, January 13, 2003 9:12 AM > > To: CF-Talk > > Subject: Re: Unix database syntactically similar to SQL Server? > > > > > > > On Friday, January 10, 2003, at 07:09 PM, John Paul Ashenfelter > > > wrote: > > > > > > > So does VMWare for Linux run under MacOSX? Now *that* would be a > > > > solution :) > > > > > > VirtualPC emulates a PC and runs on OS X. > > > > Right. But VMWare let's you install *lots* of OS's -- most *nix, most > > Win, even Solaris if you're a glutton for install punishment. With > > VMWare, you could run a virtual Win2k Server instance on your Mac and > > use it for the db part of the development. > > > > > > Dick > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4