Re: Unix database syntactically similar to SQL Server?

[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
> could run a virtual Win2k Server instance on your Mac and use it for the
db
> part of the development.

VirtualPC lets you install *lots* of OS's as well, in fact there is very
little diference between the two.

--
Jay


~|
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
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

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

[John Paul Ashenfelter]

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
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Unix database syntactically similar to SQL Server?

[Joshua Miller]

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
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Unix database syntactically similar to SQL Server?

[Roberson, Jeff, Mr (Contractor) ACI]

If you use ANSI standard syntax it works on most with little changes...

If you program in Transact (MS Only) or SQL+ (ORACLE only) you will have
some issues.

I tend to use the LEFT OUTER JOIN  and INNER JOIN syntax and it works well
through mySQl, MSSQL, and ORACLE 9i

Jeff


-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
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Unix database syntactically similar to SQL Server?

[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 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
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Unix database syntactically similar to SQL Server?

[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 will burn you. Run-of-the-mill DML, no 
> biggie.

There's a broad middle ground between "run-of-the-mill DML" and queries with
linked servers; my point was simply that you can feasibly develop against
Sybase for MS SQL Server deployment, or vice versa. Not that it's ideal,
again, but you can use the vast majority of T-SQL commands (as opposed to
"run-of-the-mill" ANSI SQL) and get identical results since Sybase and MS
SQL Server are a lot closer than any other two enterprise database
platforms.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444

~|
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
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Unix database syntactically similar to SQL Server?

[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.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
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Unix database syntactically similar to SQL Server?

[John Paul Ashenfelter]

No doubt that it can work. I've seen plenty of projects where the SQL code
could have been written in Access instead of the db du jour :)

But as the standard development environment, general rule of thumb is same,
same, same. For a one-shot consulting gig, well that's not so big a deal.

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 will burn
you. Run-of-the-mill DML, no biggie.

So does VMWare for Linux run under MacOSX? Now *that* would be a solution :)

Regards,

John Paul Ashenfelter
CTO/Transitionpoint
[EMAIL PROTECTED]
- Original Message -
From: "Dave Watts" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL 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, 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 Solaris? (actually, you can do
> > that as long as you remember the COM components won't
> > work and filenames become case-sensitive).
>
> 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
> Solaris) deployment. I did this for an onsite consultation; I copied their
> existing Sybase database to SQL Server on my laptop, wrote several hundred
> stored procedures of middling to high complexity - one of which replaced a
> loop over several hundred queries with a single database interaction,
> reducing average execution time for that page from 15 seconds to less than
1
> second - and they all worked flawlessly on Sybase.
>
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> voice: (202) 797-5496
> fax: (202) 797-5444
>
> 
~|
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
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Unix database syntactically similar to SQL Server?

[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.

~|
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

Re: Unix database syntactically similar to SQL Server?

[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.

~|
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
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Unix database syntactically similar to SQL Server?

[Joshua Miller]

That's good to hear - I hope it works in reverse!

I'm downloading Sybase for OSX now - stupid DirecWAY only lets me get
100MB a day though, so I have to wait until tomorrow to finish the
download :(

Thanks for the input guys, looking forward to a 100% Mac development
environment :)

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: 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 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 Solaris? (actually, you can do 
> that as long as you remember the COM components won't 
> work and filenames become case-sensitive).

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
Solaris) deployment. I did this for an onsite consultation; I copied
their existing Sybase database to SQL Server on my laptop, wrote several
hundred stored procedures of middling to high complexity - one of which
replaced a loop over several hundred queries with a single database
interaction, reducing average execution time for that page from 15
seconds to less than 1 second - and they all worked flawlessly on
Sybase.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444


~|
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
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Unix database syntactically similar to SQL Server?

[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 Solaris? (actually, you can do 
> that as long as you remember the COM components won't 
> work and filenames become case-sensitive).

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
Solaris) deployment. I did this for an onsite consultation; I copied their
existing Sybase database to SQL Server on my laptop, wrote several hundred
stored procedures of middling to high complexity - one of which replaced a
loop over several hundred queries with a single database interaction,
reducing average execution time for that page from 15 seconds to less than 1
second - and they all worked flawlessly on Sybase.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444

~|
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
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Unix database syntactically similar to SQL Server?

[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

- complain to your vendor about the ISO-standard SQL functions that are 
not implemented
- write UDF's with the ISO-standard SQL function name for functions that 
are implemented but use a different name/syntax


> or maybe just move production to MySQL or Postgres.

That is not for the weak of heart if you come from MS SQL Server :-)

Jochem

~|
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

Re: Unix database syntactically similar to SQL Server?

[John Paul Ashenfelter]

Joshua,

The answer the question in your subject line is "Sybase". But the real
answer is dependent on what kind of SQL you use. If it's
SELECT/INSERT/UPDATE/DELETE with vanilla data types, you're fine. If you
stick to the ANSI standard, you're probably fine. And the functions are
probably named the same (or at least aliased).

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 Solaris? (actually, you can do that as long as you
remember the COM components won't work and filenames become case-sensitive).

Let's say you use MySQL 3.23.54 as the development db. I've got nothing
against it, but how are you going to write stored procs? If MSSQL is your
production server, you'd want to take advantage of the $$$ you're paying for
it, right? Then why would you throw out stored procs? You'll end up with
forked code that looks like this:


MySQL query

MSSQL query


or something and cause tons of headaches for you -- this is not going to
speed your development efforts!


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

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: Friday, January 10, 2003 4:36 PM
Subject: Unix database syntactically similar to SQL Server?


> 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
> don't have to alter code much when moving to the staging server.
>
> Sybase? Postgre? mySQL?
>
> Thanks,
>
> Joshua Miller
> Head Programmer / IT Manager
> Garrison Enterprises Inc.
> www.garrisonenterprises.net <http://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
> <mailto:[EMAIL PROTECTED]>
> [EMAIL PROTECTED]
> 
> *
>
>
> 
~|
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
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Unix database syntactically similar to SQL Server?

[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 developer version.

I took a 33 Meg SQL-Server db (about 30 tables) and ported it to  
Sybase_ASE.  The only problems were with a few T/SQL Scalar functions  
(Left, etc).

A neat thing is that Sybase_ASE for the Mac is Rendezvous enabled --  
you can automatically discover & connect to db's on the local network  
(wired or wireless) -- it just burps at you when it finds a db.

I think the developer version allows something like 25 concurrent  
connections.

HTH

Dick

On Friday, January 10, 2003, at 01:36 PM, Joshua Miller wrote:

> 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
> don't have to alter code much when moving to the staging server.
>
> Sybase? Postgre? mySQL?
>
> Thanks,
>
> 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]
> *** 
> *
> *
>
>
> 
~|
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
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Unix database syntactically similar to SQL Server?

[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) 797-5496
fax: (202) 797-5444

~|
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

Unix database syntactically similar to SQL Server?

[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
don't have to alter code much when moving to the staging server.
 
Sybase? Postgre? mySQL?
 
Thanks,
 
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]

*
 

~|
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
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4