SQL Updates

[Sehboo]

Hi,

I have sql updates that I need to apply to the new version of my
application. This is a text file with bunch of updates like new
tables, stored procedures, etc.

I can run this file on sql query analyzer to apply all the updates at
once. This has bunch of "GO"s to seperate different statements.

But here is the problem. I cannot just take this file and run it thry
my objSQLDbCmd.ExecuteNonQuery(); method. I get the error.

I wrote this utility where I take one statement (delimited by
semicolon) and run it. This utility works.

So, either my file can have 'go's or semicolon. I want to have just
one and be able to run the same file thru my utility and sql query
analyzer.

Is there any way that I can just take the same file and run it in my
..net code and have the same effect?

Thanks

[Nicholas Paldino [.NET/C# MVP]]

Sehboo,

Why not have your application cycle through the lines in the file,
looking for "go" (which is delimited properly), and then execute the
statements sequentially as you find them? It's easy enough to break it up
into separate commands and execute them.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Sehboo" <Ma*********@gmail.com> wrote in message
news:11*********************@g10g2000cwb.googlegro ups.com...

Hi,

I have sql updates that I need to apply to the new version of my
application. This is a text file with bunch of updates like new
tables, stored procedures, etc.

I can run this file on sql query analyzer to apply all the updates at
once. This has bunch of "GO"s to seperate different statements.

But here is the problem. I cannot just take this file and run it thry
my objSQLDbCmd.ExecuteNonQuery(); method. I get the error.

I wrote this utility where I take one statement (delimited by
semicolon) and run it. This utility works.

So, either my file can have 'go's or semicolon. I want to have just
one and be able to run the same file thru my utility and sql query
analyzer.

Is there any way that I can just take the same file and run it in my
.net code and have the same effect?

Thanks

[Sehboo]

but what if "go" is part of the statement?

Nicholas Paldino [.NET/C# MVP] wrote:

Sehboo,

Why not have your application cycle through the lines in the file,
looking for "go" (which is delimited properly), and then execute the
statements sequentially as you find them? It's easy enough to break it up
into separate commands and execute them.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Sehboo" <Ma*********@gmail.com> wrote in message
news:11*********************@g10g2000cwb.googlegro ups.com...

Hi,

I have sql updates that I need to apply to the new version of my
application. This is a text file with bunch of updates like new
tables, stored procedures, etc.

I can run this file on sql query analyzer to apply all the updates at
once. This has bunch of "GO"s to seperate different statements.

But here is the problem. I cannot just take this file and run it thry
my objSQLDbCmd.ExecuteNonQuery(); method. I get the error.

I wrote this utility where I take one statement (delimited by
semicolon) and run it. This utility works.

So, either my file can have 'go's or semicolon. I want to have just
one and be able to run the same file thru my utility and sql query
analyzer.

Is there any way that I can just take the same file and run it in my
.net code and have the same effect?

Thanks

[Nicholas Paldino [.NET/C# MVP]]

Sehboo,

SQL is a language like anything else. It has a grammar that indicates
what is valid and what is not. You need to find out how to parse it
correctly, and then perform that action on your script.

Personally, I would just look for the word "go" on a line by itself.
That's how I usually see it in scripts.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Sehboo" <Ma*********@gmail.com> wrote in message
news:11*********************@c74g2000cwc.googlegro ups.com...

but what if "go" is part of the statement?

Nicholas Paldino [.NET/C# MVP] wrote:

Sehboo,

Why not have your application cycle through the lines in the file,
looking for "go" (which is delimited properly), and then execute the
statements sequentially as you find them? It's easy enough to break it
up
into separate commands and execute them.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Sehboo" <Ma*********@gmail.com> wrote in message
news:11*********************@g10g2000cwb.googlegro ups.com...

> Hi,
>
> I have sql updates that I need to apply to the new version of my
> application. This is a text file with bunch of updates like new
> tables, stored procedures, etc.
>
> I can run this file on sql query analyzer to apply all the updates at
> once. This has bunch of "GO"s to seperate different statements.
>
> But here is the problem. I cannot just take this file and run it thry
> my objSQLDbCmd.ExecuteNonQuery(); method. I get the error.
>
> I wrote this utility where I take one statement (delimited by
> semicolon) and run it. This utility works.
>
> So, either my file can have 'go's or semicolon. I want to have just
> one and be able to run the same file thru my utility and sql query
> analyzer.
>
> Is there any way that I can just take the same file and run it in my
> .net code and have the same effect?
>
> Thanks
>

[chanmm]

You can either usr the Diagnostics.Process.Start to run the isql for your
text file as patarmeter or run the text file with isql in command prompt
could be easier ;-)

chanmm

"Sehboo" <Ma*********@gmail.com> wrote in message
news:11*********************@g10g2000cwb.googlegro ups.com...

Hi,

I have sql updates that I need to apply to the new version of my
application. This is a text file with bunch of updates like new
tables, stored procedures, etc.

I can run this file on sql query analyzer to apply all the updates at
once. This has bunch of "GO"s to seperate different statements.

But here is the problem. I cannot just take this file and run it thry
my objSQLDbCmd.ExecuteNonQuery(); method. I get the error.

I wrote this utility where I take one statement (delimited by
semicolon) and run it. This utility works.

So, either my file can have 'go's or semicolon. I want to have just
one and be able to run the same file thru my utility and sql query
analyzer.

Is there any way that I can just take the same file and run it in my
.net code and have the same effect?

Thanks