First time working with MySQL in a job I'm doing. Currently we're moving the database. It's a very simple database at this time so there are just tables, no built in queries etc. Since I'm much more familiar with MS SQL and the hosting company offers it... would it be worth it to change database types and convert from MySQL to MSSQL?

I'd love to hear your thoughts as I don't know much about the functionality of MYSQL vs MSSQL and I know there are Syntax differences I'll have to work with. The interface they have with the MYSQL is pretty crappy compared to MSSQL that I've used.

2/27/2006 1:51:23 PM

Yes.

MySQL is a craptastic (yet free) SQL based database. Its does what it needs to do for websites and so forth, but for any type of serious enterprise applications, its not what you want.

Stick with MSSQL.

[Edited on February 27, 2006 at 2:17 PM. Reason : my mind is numb]

2/27/2006 1:53:38 PM

i'm going to assume maugan didn't really read what you wrote or just got confused

he has it right though - if this is a large database using for an enterprise application then i'd go with mssql -otherwise i wouldn't both with the trouble if it's a small database

[Edited on February 27, 2006 at 1:57 PM. Reason : he just meant yes i think]

2/27/2006 1:56:47 PM

See if you can't find a program which can force the MySQL to be ANSI92 complaint. IIRC, I think that's what MySQL claims to be up to spec on ... check the FAQs. MSSQL should be able to import the dumps fairly easily from that point.

And I agree with ^,^^.

2/27/2006 3:54:39 PM

Turns out I HAVE to switch. Network Solutions doesn't offer a MySQL with a cold fusion server. *laughs*.

Thanks for the comments though. It isn't a hard queried database at the moment but the potential is.

What was explained to me the way to convert MySQL to MS SQL is using a .bak file from a backup of MySQL and then it's converted to MSSQL. Of course now I get to spend the next few days hunting down the problems that may occur.

fun.

2/27/2006 5:39:47 PM

network solutions? cold fusion??

what is this? 1996?

2/27/2006 5:50:10 PM

hahahahah^

2/27/2006 6:26:16 PM

Nah Network solutions purchased the company that also does their ecommerce portion of their business so since their current host was absolute crap it made sense to combine the sites.

Cold Fusion is a very awesome web technology that includes tons of features no other does. Flash forms, instant pdf creation, data validation with a simple variable setting. But of course it's not free like ASP or PHP... but it sure is easier to maintain and troubleshoot.

2/27/2006 10:02:28 PM

it's bad enough to use NS as a domain registrar. I can't imagine trusting those fucktards to ecommerce hosting. They have an awful reputation, namely abusing their power and violating customer privacy.

Cold Fusion is a bloated, slow, outdated dinosaur. I'm sure we can dig up several websites that have been forced to drop it for better platforms b/c it didn't scale. One that comes to mind right off is anandtech.com. If you think DBMS will the be bottleneck in this you are way off.

2/27/2006 10:24:20 PM

Quote :

"it's bad enough to use NS as a domain registrar. I can't imagine trusting those fucktards to ecommerce hosting. They have an awful reputation, namely abusing their power and violating customer privacy."

Links please? I'd love to see them.

cold fusion bloated? Dinosaur? hehe okay man not even gonna go there. You need to do a little more research.

2/27/2006 10:43:33 PM

coldfusion runs myspace, the third most visited site on the web EVER.

try and tell me that coldfusion isn't an enterprise level solution.

2/28/2006 12:36:58 AM

definantly know of some major local government apps running coldfusion

2/28/2006 12:37:57 AM

^^ myspace is almost unbearable to use because of how slow it runs and its connection time outs

I'm not saying that coldfusion is bad, but thats not a good example

2/28/2006 1:00:24 AM

Look I know Cold Fusion isn't the lightest server to use. But that's because of how it handles data and how it encorporates so MUCH into automatic code generation. As far as web development goes I've never found anything so quick to code and develop with a user friendly code style and administrator. Not to mention the verity search that you can populate.

ASP to me is crap. It's a pain in the ass to maintain and work with. PHP, though I used to hate it, is pretty rocking, though it still is a lot harder to troubleshoot.

Cold Fusion has built in error checking to give you a solid idea of what you screwed up. Lets say I add a letter to a query output by accident. ASP is like "It don't work". PHP does the same. Cold Fusion goes... "Yo dumbass you don't have a query named that. There error is on line ####".

It also lets you see query response times, URL data, form field data that's been submitted, etc etc etc. And of course you can specify only certain IP's can see that.

Now don't get me wrong... ASP and PHP both can do things Cold Fusion can't... but I've never run into them.

2/28/2006 8:01:20 AM

php is no harder to debug than any other language, you just have to setup the development server right.

2/28/2006 8:33:39 AM

Quote :

"Links please? I'd love to see them."

http://www.google.com/search?q=%22network+solutions%22+despised
http://www.google.com/search?q=%22network+solutions%22+%22worst+reputation%22
http://www.google.com/search?q=nsi+gave+out+default+passwords
http://www.google.com/search?q=nsi+sucks

2/28/2006 8:55:29 AM

Whatever implementation you decide to use ... please thoroughly document whatever you are doing for the next guy/gal down the road

2/28/2006 11:11:42 AM

^he shouldnt if he wants job security

2/28/2006 11:56:05 AM

I <3 PL/SQL Developer.

</thread redirection>

2/28/2006 4:43:26 PM

Wolf... any CURRENT bad links? The latest one I saw in the first few of each was 2003.

2/28/2006 4:59:43 PM

HAhahahaAHaHa

Coldfusion is so heinous its rediculous. I am in complete agreement with Wolftrap on this.

And using myspace.com as a good example of anything other than the downward spiral of our civilization isn't a good idea. The site is so slow, so unreliable, and so horribly hackable, it's comical.

From a professional background, I've only ever had to do two kinds of code conversions. Perl/C/CGI -> ASP/PHP and Coldfusion -> ASP/PHP. People run from Coldfusion as fast as possible once they realize what a fucking expensive dog it is.

2/28/2006 5:20:54 PM

Uh no. Actually more people are flocking TO cold fusion because of cheaper maintanance costs. Sure companies like Google or Yahoo can't because of the number of hits would kill most Cold Fusion servers.

ASP maintanance is HUGE, so is PHP and the code times for both is 4-5 times that of Cold Fusion EVEN if you module your queries.

Hey lets try a VERY basic form example.

<cfinput validate="zipcode" required="yes" message="Need a Zip code Dork">

This is a Cold fusion cfinput which works just like an input lets me set it to make sure it's a zip code, it must be entered before it will allow you to progress AND it lets you set the message to tell the user what's going on. I don't have to refresh the page, I don't have to set any special settings inside the input... hell looks like I did it in 1/10th the time it would take you to do that in ASP or PHP.

Lets look at something more advanced. Say you want someone to be able to view some information but not be able to copy/paste the entire text. Cold Fusion lets you make ANY PAGE... I mean ANY into a PDF or FLASHpage. Hell I can make http://www.yahoo.com's index page a PDF. I won't even bother to go into the usefulness of this.

Here's another slam... lets talk queries.

<CFQUERY name="Query1" datasource="Datasource1">
SELECT *
FROM ColdFusionOWNS
WHERE Noen="Talkingouthisassagain"
</CFQUERY>

Notice anything about that? Wow I didn't have to make a ODBC connection string... I didn't have to specific what the values for the columns are... OMG!!! My query only took 5 lines? Hell even complex queries are VASTLY smaller than ASP or PHP queries.

Don't tell me that Cold fusion is going out the door when there are more jobs out there for Cold Fusion Developers than EVER! Don't tell me it sucks when I can design, code, and implement websites 4-5 times faster than you. Don't tell me Cold Fusion is crap when I can make massive changes in very short time periods.

Sure... you compare Cold fusion and ASP/PHP and you'll notice a lot of differences when it comes to scripting. But don't even try Java compliance.

http://www.cipm.info/websites.cfm

Those lists of sites are ALL written in Cold Fusion and get hundreds of thousands of hits a day. Many are mission critical for Homeland security working along with Customs to relay information about pests coming into this country and other countries. Java Applets, Map programs and a plethora of other programs all working seemlessly together. Just like ASP and PHP can do.

But it was built faster, cheaper, and just as secure.

I'm done with this subject.

3/1/2006 12:18:38 AM

Quote :

"Cold Fusion has built in error checking to give you a solid idea of what you screwed up. Lets say I add a letter to a query output by accident. ASP is like "It don't work". PHP does the same. Cold Fusion goes... "Yo dumbass you don't have a query named that. There error is on line ####". "

Fatal error: Cannot instantiate non-existent class: dumbestthingiveeverheard in /home/stein/public_html/raigedoesntknowwhathestalkingabout.php on line 2

Quote :

"Here's another slam... lets talk queries. <CFQUERY name="Query1" datasource="Datasource1"> SELECT * FROM ColdFusionOWNS WHERE Noen="Talkingouthisassagain" </CFQUERY> Notice anything about that? Wow I didn't have to make a ODBC connection string... I didn't have to specific what the values for the columns are... OMG!!! My query only took 5 lines? Hell even complex queries are VASTLY smaller than ASP or PHP queries. "

$Query1 = mysql_query("SELECT * FROM EveryRaigePostIsDumberThanTheLast WHERE ItJustKeepsGettingWorse='Y'", $Datasource1);

Quote :

"Those lists of sites are ALL written in Cold Fusion and get hundreds of thousands of hits a day. "

Whoa.

Wait a second.

Did you use, as your big piece of evidence as to how great ColdFusion is, a page that has page transitions on it?

This is a joke right? I mean there's no way you can be serious.

[Edited on March 1, 2006 at 12:46 AM. Reason : .]

3/1/2006 12:35:48 AM

No it was a listing of sites that are used daily with the numbers I mentioned. Not a page that transitions to other sites that im reporting the number of hits.

3/1/2006 7:53:57 AM

webobjects is the best

3/1/2006 8:24:16 AM

Quote :

"No it was a listing of sites that are used daily with the numbers I mentioned. Not a page that transitions to other sites that im reporting the number of hits."

Too bad it shows that the person who developed it is either:
A) clueless
B) an insult to his profession
or
C) a 10 year old

<meta http-equiv="Page-Exit" content="revealTrans(Duration=2,Transition=23)">

Next thing you know, you're going to be linking us to pages with "Under Construction" graphics and MIDIs playing and telling us how great the backend for that is.

Of course, you're "done with the subject", because just like every other thread you'll leave this one looking like an even bigger idiot.

[Edited on March 1, 2006 at 8:46 AM. Reason : .]

3/1/2006 8:45:57 AM

bttmft.

This is very entertaining.

3/1/2006 1:28:55 PM

This is stupid. We're arguing about 3 very different languages each having it's good points. My point is that Cold Fusion isn't going anywhere and is a VERY viable solution that is NOT cost inefficient unless the developers are too close minded to use it.

For those reading just check out the features of Cold Fusion here --> http://www.macromedia.com/software/coldfusion/?promoid=BINO

Look at the Demos (http://www.macromedia.com/software/coldfusion/demos/)

Look at the mobile communication built in! (http://www.macromedia.com/software/coldfusion/event_gateways/)

And hell lets look at some of the top users of Cold Fusion (http://www.macromedia.com/software/coldfusion/proven/)

My point stands that Cold Fusion is viable, and increasing it's user base daily because it does SO MANY things that ASP and PHP don't without a lot of effort.

3/1/2006 2:59:14 PM

what was this thread about - OOOOOH OK - nm i thought maybe we had gotten offtopic and arguing about whether the honda civic or accord will get you to your destination faster/safer/easier/quicker/better - this crap should be locked

3/1/2006 3:02:19 PM

Quote :

"My point is that Cold Fusion isn't going anywhere and is a VERY viable solution that is NOT cost inefficient unless the developers are too close minded to use it. ... Look at the mobile communication built in! (http://www.macromedia.com/software/coldfusion/event_gateways/)"

ALL THIS AND MORE FOR JUST $6,000!

Look, it enables you to know absolutely nothing about what you're doing (common theme in your threads) and not get fired, we get that. Just don't try and pawn it off on us as this awesome, awesome web technology when we all know it's not.

3/1/2006 4:56:04 PM

So... let me get this straight.

I don't know anything about what I'm doing... when I use a web technology that does a lot of things for me that would take ANY coder who did the manually... oh... hours to days of development?

That's like saying I'm stupid for using a calculator instead of doing it in my head.

It IS awesome technology. How long would it take you to design an script and backend that would allow you to instantly convert ANYTHING on a page to a PDF?

How long would it take you to set a validation script for an email, or a zip code? I do it in 5 seconds. How long does it take you?

How long would it take you to create make it so your application can communicate to Blackberry's etc. Typically you have to create the same page again with lower graphics etc.

You can say anything you want but the fact is Cold Fusion is BAD ASS! $6,000 is NOTHING for an investment in a technology that will save them $20,000 in development costs (Time, lost revenue etc).

The fact is I can do 99.999% of what you can do.. faster, just as secure, and can maintain it much easier than you can yours. And your comment about me not knowing what I'm doing... childish man. But what can I expect from a 21 year old.

I'm done here. Not even gonna argue about this anymore.

[Edited on March 1, 2006 at 6:09 PM. Reason : !]

3/1/2006 6:09:11 PM

Quote :

"So... let me get this straight. I don't know anything about what I'm doing"

Correct.

You're right. I think we're just about done here. Having "OMG FAST FAST FAST" development time is kind of pointless when your serving it up with a side order of slow and bloated Cold Fusion and have no idea what the underlying code is doing, which I think is pretty obvious considering you're thinking data validation without refreshing the page is being handled by PHP or ASP.

I mean, I honestly don't care what it is you use to make your awesome pages that undoubtly use those sexy page transitions. You'll be able to see all the errors you make just like in every other language, but since ColdFusion is so FAST and EASY I'm sure you don't even make any at all!

End of the day I just know I'm quite glad to not be in bed with ColdFusion and Network Solutions.

Quote :

"But what can I expect from a 21 year old."

Obviously the same level of professionalism as an old man such as yourself, though with only a tiny bit of the senility you seem to be exhibiting.

3/1/2006 6:37:24 PM

Quote :

"How long would it take you to design an script and backend that would allow you to instantly convert ANYTHING on a page to a PDF?"

Not that long. If I were doing it in JSP I would just use iText (it's free by the way) and bam, pdf output. They make a .Net version also...so I could be doing it in ASP.Net (C#) as well.

[Edited on March 1, 2006 at 6:57 PM. Reason : c# ftw]

3/1/2006 6:54:35 PM

.net ftw

3/1/2006 7:41:26 PM