Re: Unix database syntactically similar to SQL Server?

2003-01-13 Thread James Smith
> > > 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 > cou

Emulators/VMWare for Mac (WAS: Re: Unix database syntactically similar to SQL Server?)

2003-01-13 Thread John Paul Ashenfelter
ROTECTED]> 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 Ma

RE: Unix database syntactically similar to SQL Server?

2003-01-13 Thread Joshua Miller
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

RE: Unix database syntactically similar to SQL Server?

2003-01-13 Thread Roberson, Jeff, Mr (Contractor) ACI
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

Re: Unix database syntactically similar to SQL Server?

2003-01-13 Thread John Paul Ashenfelter
> 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 y

RE: Unix database syntactically similar to SQL Server?

2003-01-11 Thread Dave Watts
> It all comes down to the complexity of the SQL -- > specifically how much server-specific stuff you need > to do. Obscure (or obsfucated) functions (e.g. MySQL > password hash function), crazy things like code pages > and collation orders, queries with linked servers, etc. > All that stuff w

Re: Unix database syntactically similar to SQL Server?

2003-01-10 Thread Dick Applebaum
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. Dick ~| Archives: http://www.hou

Re: Unix database syntactically similar to SQL Server?

2003-01-10 Thread John Paul Ashenfelter
IL PROTECTED]> Sent: Friday, January 10, 2003 5:24 PM Subject: RE: Unix database syntactically similar to SQL Server? > > But wow, do I think this is a bad idea. > > > > Databases are the core of many CF applications -- you > > should use the same database for development,

Re: Unix database syntactically similar to SQL Server?

2003-01-10 Thread Paul Hastings
> In an ideal world, I agree with you. However, I've actually been pretty > successful using MS SQL Server as a development platform for Sybase (on because sql server is/was son-of-sybase run amok. even access <--> sql server has some quirks. ~~

Re: Unix database syntactically similar to SQL Server?

2003-01-10 Thread Dick Applebaum
On Friday, January 10, 2003, at 03:07 PM, Joshua Miller wrote: > Thanks for the input guys, looking forward to a 100% Mac development > environment :) > > Um my goal is a 100% Mac Deployment environment %^D> but I am really happy to have what we have.

RE: Unix database syntactically similar to SQL Server?

2003-01-10 Thread Joshua Miller
From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Friday, January 10, 2003 5:25 PM To: CF-Talk Subject: RE: Unix database syntactically similar to SQL Server? > But wow, do I think this is a bad idea. > > Databases are the core of many CF applications -- you > should use the same da

RE: Unix database syntactically similar to SQL Server?

2003-01-10 Thread Dave Watts
> But wow, do I think this is a bad idea. > > Databases are the core of many CF applications -- you > should use the same database for development, staging, > and production. Would you develop in CF4.5 and deploy > to CFMX (or CF5 for that matter)? Would you develop on > Windows and deploy to So

Re: Unix database syntactically similar to SQL Server?

2003-01-10 Thread Jochem van Dieten
John Paul Ashenfelter wrote: > > That said, focus on ANSI-standard SQL and do the following: > check your datatypes for compliance in both > check the case-sensitivity in both (files and dbs) > check the functions you use are in both dbs, or write a script to replace > common substitutions

Re: Unix database syntactically similar to SQL Server?

2003-01-10 Thread John Paul Ashenfelter
common substitutions or maybe just move production to MySQL or Postgres. Regards, John Paul Ashenfelter CTO/Transitionpoint [EMAIL PROTECTED] - Original Message - From: "Joshua Miller" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Frid

Re: Unix database syntactically similar to SQL Server?

2003-01-10 Thread Dick Applebaum
Sybase_ASE shares common ancestry with SQL-Severe (Freudian typo). MS and Sybase worked together for a while to develop SQL-Server. Sybase uses T/SQL and it is very similar to MS T/SQL (and Sybase wants to hear about any differences so they can be made compatible). You can download a free dev

RE: Unix database syntactically similar to SQL Server?

2003-01-10 Thread Dave Watts
> Anyone know what the most syntactically similar RDBMS to > SQL Server is for Unix/Linux ? > ... > Sybase? Postgre? mySQL? Sybase would be the most syntactically similar. Both use Transact-SQL, and there are few differences. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202

Unix database syntactically similar to SQL Server?

2003-01-10 Thread Joshua Miller
Anyone know what the most syntactically similar RDBMS to SQL Server is for Unix/Linux ? I've setup my CFMXJ2EE / JRun scenario on my Mac, but my application uses a SQL Server database. I'd like to install something on the Mac that would be pretty similar for a development environment so that I do