running SQL / script files to create objects

digitiger · Post by **digitiger** » Wed 12 Mar 2008 10:09

I need to run script files to generate the DB objects (multiple) but am not able to find any component for same purpose.

I use your latest drivers for SQL Server with Delphi 6.

Please help

Regards

Antaeus · Post by **Antaeus** » Thu 13 Mar 2008 13:44

You can try using the TSQLQuery component and its ExecSQL method for this.

We provide a component dedicated for executing large scripts in our DAC components (SDAC, ODAC, etc.). In the nearest time we are going to release UniDAC with SQL Server provider support. UniDAC is our Universal Data Access Components which can be an alternative for dbExpress. UniDAC also includes a component for executing large scripts.