thanks for ready and thanks for the suggestions.

I have been using MySQL for a few years. My current project requires me to use MS SQL. I'm looking for a few pointer web links to learn about the differences in MySQL to SQL. I will also be using PHP so any PHP/SQL links are appreciated.

My client requires me to give them a DDL file for their SQL Server team to integrate. Is a DDL the same as a .sql file? How can i create a DDL?

Is there a way to make a SQL DDL have permission for create/edit/remove tables and that's about it?

thanks

For me, and wikipedia agrees (http://en.wikipedia.org/wiki/Data_Definition_Language), the DDL is nothing more than the script you will run to create the db structure, the stored procedures, triggers, constraints and everything that will define your DB schema.

So, yes, a DDL file is an .SQL file too, usually.

Is there a way to make a SQL DDL have permission for create/edit/remove tables and that's about it?

Not that I know of, but you can define the permissions to the DB objects (being tables, views , functions or stored procedures) from the DDL, simply with the GRANT command.

thanks @tripy

Tripy is right (as usual). And the grant SQL command will allow you to set the permissions you need, at the user or role level.

Tripy is right (as usual).

No no, it's not usual, trust me.
What saves me here is the "foreign language" lag that allow me to think a bit more longer about what I'm going to write...