Hi,
I have created a installer to generate database and tables on server automatically.This application works fine only with sql server.
I have to generalize the same application for various dbs like oracle,db2,etc.
I have written the application in c#.
for this i have create a text file which contains script for genrating db and its tables.My problem is:
executing sql statement one by one from this file
following is the content of the file
/*****************************************************************
CREATE DATABASE [Info]
COLLATE SQL_Latin1_General_CP1_CI_AS
GO
USE [Info]
GO
CREATE TABLE [dbo].[Employees] (
[Name] [char] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[Rsvp] [int] NULL ,
[Requests] [nvarchar] (4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY];
ALTER TABLE [dbo].[Employees] WITH NOCHECK ADD
CONSTRAINT [PK_Employees] PRIMARY KEY CLUSTERED
(
[Name]
) ON [PRIMARY];
*******************************************************************/
please help me for the same.
Regards,
Amol