A easy question about building SQL databases-please answer!

[dcpsoguy]

I would like to create a SQL database in Coldfusion( a programming language that connects to databases). Which program should I use to create an SQL database in Coldfusion?

 

[Locutus of Board]

Hmmm

Your question is slightly confusing.

You create a database via the SQL enterprise manager.

You set up a DSN for your coldfusion server to point to it.

(I have done this with other programs, not CF. The theory is the same.)

There must be some way in CF to setup any tables and stored procedures that may be needed.

 

[dcpsoguy]

That answers my question. Thanks so much!!!

How much does the SQL enterprise manager cost?

 

[Locutus of Board]

If you are speaking of M$ SQL server, check it out there. I dunno.

You may be able to get away cheaper, if CF supports MYSQL or other DB.

Whatever DB you choose to use, just make sure CF supports it.

 

[thEnEuRoMancER]

MySql is for free.

 

[dcpsoguy]

Is SQL the same as MYSQL??? If not, what are the main differences???

 

[cyclistca]

No MYSQL is a utility that allows you to set up and maintain an SQL database. As some else said it is free. Most other SQL software like Oracle or Microsoft is aimed at the corporate market and is price accordingly. If this is for personal use or a small database MYSQL should be fine.

SQL stands for structured query language. It the language that you use to input, modify, delete, and manipulate the data in your database.

For the most part SQL is standard across the variations. Most vendors do like to add their own little additional features just to piss off us SQL developers 🙂.

 

[thEnEuRoMancER]

SQL (structured query language) itself is a database standard. MS Sql and MySql are database products, implementing this standard.

 

[dcpsoguy]

Ok. Thanks Guys!

 

[jobert]

Both MySQL and Microsoft SQLServer are fairly complex.
(The SQL Enterprise Manager that Locutus mentioned is
one component (of MANY) in the Microsoft product.)

Unless you're doing some heavy duty real-time
data manipulation, you can connect to Access,
which is much more user-friendly.

You can also use Visual Basic to create
a SQL compliant database (although I'll
bet the purists here would frown on that.)