Posted by serge on 07/25/05 15:32

> So if you want to script or automate DBA tasks, or develop an admin
> application, then DMO is usually a much better choice; if you're
> writing business applications, where you need to process and manipulate
> data efficiently, then ADO would be preferred.

I understand better now, however would you know if executing
SQL script files that create a database (tables, indexes, constraints,
functions, stored procedures, triggers, ...) in ADO would execute
faster than in SQL DMO? I am currently building the database using
SQL DMO and if I understand your explanation well, you say using
ADO would be preferred if processing/manipulating data.

My SQL scripts are mainly CREATE scripts, would they fall under
the SQL DMO choice or ADO?

Or there probably won't make a speed difference if executed using
DMO or ADO?

Thank you

[Back to original message]