the mssql problem again...

pld

Okay, so i have been trying to migrate a site i built using php, apache, mysql on a win2k machine. the site works wonderfully at the moment in its current config. however, the idiot IS guys at my company insist on trying to use m$ sql for the db backend. so i figure what the heck, its still sql, right?

Except that I am running into a couple of strange problems. I had managed to track down an entire bunch of problems and fix them, but there are still a few lingering ones. so i guess i have 2 quick questions.

can anyone point me in the direction of a decent tutorial or documentation concerning migrating from mysql to ms-sql? (assuming one even exists)
in my mysql tables, i had a primary key that auto incremented. simple. now how do i pull off the same in ms-sql? i just cant seem to get that particular sore spot worked out at the moment...

thanks for any help, i appreciate everyone's input that has helped me so far!

barand

M$SQL has an import wizard (accessible via 'Enterprise Manager'. All you will need is a MyODBC link to you MySQL db.
Still using Enterprise Manager, select the table and open for 'design'. In the options for each field you can set an option called 'identity' to yes. This is the auto_inc equivalent.

hth

pld

thanks barand!

I am on my way to getting this conversion running smoothly. one quick question, though. is there some syntax i am missing in limiting retrieval of data from the database?

in mysql, i could do: SELECT * FROM table WHERE ... order by date desc limit 5

i've got all the equivalents in ms, except for the limit 5 bit

(frustrated at the overall lack of information on the net regarding ms sql... hopefully this will get more people to consider mysql!)
thx again...

barand

I think it's

SELECT TOP 5 ...
or you can
SELECT TOP 5%

No offset equivalent to LIMIT x,y

pld

thanks barand, i'll give it a shot and code the offset bit from the php end i suppose 🙂 thanks again!

hoascht

if you want to get the last inserted id, try this SQL-Statement:

SELECT @@INDENTITY

greetings from germany
hoascht