MySQL vs Microsoft SQL 2000

poppy

This is probably a dumb question, but I'm fairly new to this who SQL thing, so bear with a newbie 🙂

I've done a few sites using php & mysql, but a new site I'm working with told me they don't have mysql, only Microsoft SQL 2000, which made me go 🙁

I guess my question is - how do I make a conversion from mysql to Microsoft and why does Bill Gates consistently ruin my world :rolleyes:

Is SQL 200) something I, as a user, would have to purchase, or like mysql, is there a way to access it online?

If I need to bring out my magic lamp and begin rubbing, would now be the time?

gracias for any and all help
-poppy

tomhath

M$ $QL 2000 isn't free. It could cost you several hundred dollars or a few thousand dollars depending on the license(s) you need.

poppy

is there any way around it? I know SOMEONE has a secret they're just DYING to share with me 😉

stolzyboy

a | k | a | a | z | z | a | a | k | a |

a little puzzle for you read between the lines kinda

BeastRider

Originally posted by poppy
is there any way around it? I know SOMEONE has a secret they're just DYING to share with me 😉

You mean you would resort to software theft? MS Sql is a commercial product. No matter your thoughts on open source versus commercial software, Microsoft has made it clear that they consider the MS Sql code proprietary.

Is there a difference between stealing a computer out of a Microsoft office and stealing some software out of a Microsoft box?

stolzyboy

You mean you would resort to software theft?

BeastRider, you trying to tell me you don't have any pirated software or pirated mp3's, LOL, i think not

BeastRider

Originally posted by poppy
I've done a few sites using php & mysql, but a new site I'm working with told me they don't have mysql, only Microsoft SQL 2000, which made me go 🙁

I guess my question is - how do I make a conversion from mysql to Microsoft and why does Bill Gates consistently ruin my world :rolleyes:

Is SQL 200) something I, as a user, would have to purchase, or like mysql, is there a way to access it online?

-poppy

1) If the new site that you are working with has MS SQL 2000 available, then you would not need your own copy. Most MS Sql licenses provide for a personal MS SQl for the desktop and development machine. But, your site can tell you specifically.

2) Making the transition in the databases themselves should be fairly straightforward. You can export out of one and into the other. There may be differences in SQL syntax and options. You will need to modify your php scripts to use the msmsql commands, or perhaps look at a product that provides for database abstraction.

BeastRider

Originally posted by stolzyboy
BeastRider, you trying to tell me you don't have any pirated software or pirated mp3's, LOL, i think not

It is true. I own not a single mp3, pirated or otherwise. I have copies of my CD's, mainly so that I can leave them in the juke box and still put them into my car stereo. I do not have a single copied VCR tape or a DVD.

Every last copy of software on my work and home computers is either licensed or open source. I insure that my company is in compliance as a matter of fudiciary responsibility. I insure that my home machine is legal because I think it is the right thing to do. I sell software for a living. I cannot see how one reconciles stealing software while expecting others not to steal the stuff I produce.

That is not to say that I have not downloaded tons of software for evaluation purposes. But, you will find that anything that is in use on a regular basis is licensed and legal.

poppy

Originally posted by BeastRider
You mean you would resort to software theft? MS Sql is a commercial product. No matter your thoughts on open source versus commercial software, Microsoft has made it clear that they consider the MS Sql code proprietary.

Is there a difference between stealing a computer out of a Microsoft office and stealing some software out of a Microsoft box?

I wasn't talking about resorting to theft. Sheesh! Like I said earlier, I'm very new to this stuff, but everyone that's helped me has had all these secrets they've picked up. For all I knew, maybe you could just mysql and use it as a substitute. I'm just asking questions, just trying to learn.

stolzyboy

i wasn't suggesting for work, as we have valid copies and licenses also, but most peeps have downloaded pirated mp3's, software, etc...

BeastRider

Originally posted by stolzyboy
i wasn't suggesting for work, as we have valid copies and licenses also, but most peeps have downloaded pirated mp3's, software, etc...

Well, I tell you, I have been might tempted to become a music pirate these days, but I haven't done it yet.

I know this is off topic, but it really chaps my ass that

a) CD prices are through the roof for garbage
b) the music companies are pushing copy protection schemes that won't even let me make personal copies for my own use. Whatever happened to the "fair use" doctrine.

The reality is that I listen to a lot of commercial free internet radio, and I am planning on hooking up with XM radio. While I would like to have a music library, the reality is there is much more available than I would ever have time to copy.

I will say this... you would never find me turning in someone for music theft... and if the licensing requirements and intrusiveness of installation software gets any worse, I may change my mind there as well.

I used to be solidly in the commercial software camp, but, to modify that old saying, while I am trying to play fair ball with them, they are trying to shove the bat up my ass. I don't like it. Open source, if nothing else, keeps the stinking bums from snooping into things that don't concern them.

BeastRider

Originally posted by poppy
I wasn't talking about resorting to theft. Sheesh! Like I said earlier, I'm very new to this stuff, but everyone that's helped me has had all these secrets they've picked up. For all I knew, maybe you could just mysql and use it as a substitute. I'm just asking questions, just trying to learn.

Don't get your shorts all tied up in a wad. I take it all back then. Usually, secrets means, "Hey, do you have the warez hack?"

MS Sql is actually a very nice product and should make a big dent in Oracle sales (hooray!)

stolzyboy

i hear what you are saying BeastRider

and apparently poppy couldn't figure out the little puzzle

too bad for him

Doug_G

If you happen to have Microsoft Access 2000 or higher, it ships with MSDE which is basically a personal version of SQL server without the SQL Server client tools. You can do everything you need to stage your database locally with MSDE and then copy out of your local database to your remote database.

MSDE is also packaged with some applications. For example if you download Web Matrix from www.asp.net there is also a MSDE download to support Web Matrix.