Creating DDL files

[cesarcesar]

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

[NogDog]

Data Definition Language

You probably should ask them if they have any specific requirements for this, as there is not a precisely defined protocol. Most likely a SQL file with the table definitions is all they need, I suspect, but it's possible they want something else.