Using OSQL in ASP page to upload SQL file to SQL DB

Using OSQL in ASP page to upload SQL file to SQL DB

am 11.10.2004 20:36:02 von godtoall

Our old developer used OSQL to upload a .sql file to a stored
procedure. Our organization has requested that we increase the
capacity by 7 times. The current design is not capable of handling
this load. Does anyone recommend a method or website with example code
on how I can have the client upload the sol to the database?

Re: Using OSQL in ASP page to upload SQL file to SQL DB

am 11.10.2004 20:38:44 von reb01501

Jeremy Smith wrote:
> Our old developer used OSQL to upload a .sql file to a stored
> procedure. Our organization has requested that we increase the
> capacity by 7 times. The current design is not capable of handling
> this load. Does anyone recommend a method or website with example code
> on how I can have the client upload the sol to the database?

I don't understand your requirement. A .sql file typically contains a script
which is run on a sql server. I've never heard the term "upload" used in
relation to a .sql file.

Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.