MS-SQL Server Create DB

Sudhaker

Delphi Developer

Tue, 27 Jul 2004 14:31:03 GMT

MS-SQL Server Create DB

greetings for the day,

I have generated SQL Script for my existing MS-SQL server database using
Generate SQL Script option in the MS-SQLserver.

Can anyone help me out how write a utility which will read the sql script
file and create database from delphi..

sudhaker

Andy Macki

Delphi Developer

Tue, 27 Jul 2004 17:52:54 GMT

Re:MS-SQL Server Create DB

Quote

Sudhaker <sudha...@botree.co.in> wrote in message news:3c637043_1@dnews...
> I have generated SQL Script for my existing MS-SQL server database using
> Generate SQL Script option in the MS-SQLserver.

> Can anyone help me out how write a utility which will read the sql script
> file and create database from delphi..

If you just want to run the script, you can use the osql utility that ships
with sql server to run it. e.g.

osql -E -S localhost -n -i CreateTestDB.sql

See SQL Server's help (BOL) for all the options, e.g. -U -P for specifying
user name/password.

Regards,
Andy Mackie.

Bertrand Bourgea

Delphi Developer

Tue, 27 Jul 2004 20:10:41 GMT

Re:MS-SQL Server Create DB

If you want to build it into an application, then one way is to use
TADOConnection and TADOCommand. If you use GO in your script then you will
have to read the bacthsections (eg. the statements separated by GO) from
file and execute it bacth by batch.
If you use BDE then have a look at RX components, who have a component which
takes a batch script.

Regards,
Bertrand Bourgeat

"Andy Mackie" <amac...@citynetworks.co.uk> skrev i en meddelelse
news:3c639f3a$1_1@dnews...

Quote

> Sudhaker <sudha...@botree.co.in> wrote in message news:3c637043_1@dnews...
> > I have generated SQL Script for my existing MS-SQL server database using
> > Generate SQL Script option in the MS-SQLserver.

> > Can anyone help me out how write a utility which will read the sql
script
> > file and create database from delphi..

> If you just want to run the script, you can use the osql utility that
ships
> with sql server to run it. e.g.

> osql -E -S localhost -n -i CreateTestDB.sql

> See SQL Server's help (BOL) for all the options, e.g. -U -P for specifying
> user name/password.

> Regards,
> Andy Mackie.

Jim Elde

Delphi Developer

Wed, 28 Jul 2004 00:49:11 GMT

Re:MS-SQL Server Create DB

Check out CodeCentral #17523

http://ww6.borland.com/codecentral/

-Jim

Quote

"Sudhaker" <sudha...@botree.co.in> wrote in message news:3c637043_1@dnews...
> greetings for the day,

> I have generated SQL Script for my existing MS-SQL server database using
> Generate SQL Script option in the MS-SQLserver.

> Can anyone help me out how write a utility which will read the sql script
> file and create database from delphi..

> sudhaker

Other Threads

1. Creating MS SQL Server database in the specific path Using SQL-DMO

2. MS OLE DB Providers for ODBC and SQL Server

3. Can I create a new db and tables in SQL Server using ADOX

4. SQL Server 7 create DB error

5. Create DB on SQL Server

6. Delphi 3.0 - IIS ISAPI + SQL Server (MS) + BDE = SQL Server not found errors

7. Creating a database with MS SQL Server 6.5

8. There are many connections created by TTable in MS SQL Server

9. Creating Data Dictionary on MS SQL Server 6.0

10. tools for Finding/Applying DB changes to client db with MS SQL