@sergea: "I've used ADO before and now SQL-DMO to execute
SQL statements on a SQL Server database.
I was just thinking if SQL-DMO has any capabilities
that ADO.NET does not have when it comes to
having a programming interface to SQL Server?
Would you know if I should not waste my time learning
SQL-DMO and rather learn/use C# (ADO.NET) instead?
Does SQL-DMO exist in SQL 2005?
Thank you"
    @sergea: "<quote>
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"
    @sergea: "I am currently using VB and SQL DMO.
I am looping in a folder and reading each file into a string variable
and then using ExecuteImmediate to create the SQL server objects.
I don't want to use OSQL as running the SQL DMO is much faster
than OSQL.
I'll stay away from ADO and try to learn ADO.NET with
SqlClient 2.0.
I'm also going to keep in mind to read more about 2005's SMO
and RMO.
Thank you all for the replies."
{'source': 'USENET', 'other_information': '{"reply_count": 2, "forum_name": "comp.databases.ms-sqlserver.20140826.mbox"}', 'file': 'data/output/usenet-comp.databases.parquet'}