Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP General > upload sql files from IIS to sql

Reply
Thread Tools

upload sql files from IIS to sql

 
 
Jeremy Smith
Guest
Posts: n/a
 
      08-10-2004
We have clients upload sql files to a folder on an IIS 6.0. The sql
file are then processed by a scheduled task that runs once every
10mins to process the file with oSQL. With oSQL the files upload the
data to a 2 tier SQL server. The developers are complaining about
performance and are saying it is the OS/hardware. I have Profmon on
the IIS server and 2 tier SQL server. Both only peak at %5 usage on
processor memory stays close to the same.

I believe that it would better to have IIS make a connection to the
SQL server and upload the record directly.

What do you think?

and any examples would be nice or URL that talks about how to do this.

Thanks for you ideas and help!!
 
Reply With Quote
 
 
 
 
Jeff Cochran
Guest
Posts: n/a
 
      08-10-2004
On 10 Aug 2004 06:49:15 -0700, http://www.velocityreviews.com/forums/(E-Mail Removed) (Jeremy Smith)
wrote:

>We have clients upload sql files to a folder on an IIS 6.0. The sql
>file are then processed by a scheduled task that runs once every
>10mins to process the file with oSQL. With oSQL the files upload the
>data to a 2 tier SQL server. The developers are complaining about
>performance and are saying it is the OS/hardware. I have Profmon on
>the IIS server and 2 tier SQL server. Both only peak at %5 usage on
>processor memory stays close to the same.
>
>I believe that it would better to have IIS make a connection to the
>SQL server and upload the record directly.
>
>What do you think?


There's no such thing as a "SQL File" so it depends greatly on what
these files actually are. Show us a sample file and maybe a table
structure, or at least tell us exactly what they are and what they're
doing. This could be as simple as running a query to INSERT/UPDATE
records, it could be you really want to use DTS or any number of
options.

Jeff

>and any examples would be nice or URL that talks about how to do this.
>
>Thanks for you ideas and help!!


 
Reply With Quote
 
 
 
 
JoshW
Guest
Posts: n/a
 
      08-17-2004
I believe he is referring to files with ".sql" extensions, so in that
case, yes, there are "SQL Files". If this is the case, then I would
think you would be able to store the .sql files in a database table
much like you would a .gif, .jpg, .doc, .txt or anything else
(although this seems to sometimes be frowned upon by more
knowledgeable people than I).

In any case, I am having a problem getting IIS 6.0 to serve files with
a .sql extension. For example, if I have a file sitting out in a
directory somewhere, such as
"http://someIISserver/someApp/someFolder/xxx.sql" I get a 404 Error
when I try to access that URL. I believe this has something to do
with the Web Service Extensions in IIS 6.0, but I have no idea what
DLL I should use to serve the .sql files... Any ideas?
>
> There's no such thing as a "SQL File" so it depends greatly on what
> these files actually are. Show us a sample file and maybe a table
> structure, or at least tell us exactly what they are and what they're
> doing. This could be as simple as running a query to INSERT/UPDATE
> records, it could be you really want to use DTS or any number of
> options.
>
> Jeff
>
> >and any examples would be nice or URL that talks about how to do this.
> >
> >Thanks for you ideas and help!!

 
Reply With Quote
 
JoshW
Guest
Posts: n/a
 
      08-17-2004
I believe he is referring to files with ".sql" extensions, so in that
case, yes, there are "SQL Files". If this is the case, then I would
think you would be able to store the .sql files in a database table
much like you would a .gif, .jpg, .doc, .txt or anything else
(although this seems to sometimes be frowned upon by more
knowledgeable people than I).

In any case, I am having a problem getting IIS 6.0 to serve files with
a .sql extension. For example, if I have a file sitting out in a
directory somewhere, such as
"http://someIISserver/someApp/someFolder/xxx.sql" I get a 404 Error
when I try to access that URL. I believe this has something to do
with the Web Service Extensions in IIS 6.0, but I have no idea what
DLL I should use to serve the .sql files... Any ideas?
>
> There's no such thing as a "SQL File" so it depends greatly on what
> these files actually are. Show us a sample file and maybe a table
> structure, or at least tell us exactly what they are and what they're
> doing. This could be as simple as running a query to INSERT/UPDATE
> records, it could be you really want to use DTS or any number of
> options.
>
> Jeff
>
> >and any examples would be nice or URL that talks about how to do this.
> >
> >Thanks for you ideas and help!!

 
Reply With Quote
 
Jeff Cochran
Guest
Posts: n/a
 
      08-18-2004
On 17 Aug 2004 14:50:53 -0700, (E-Mail Removed) (JoshW) wrote:

>I believe he is referring to files with ".sql" extensions, so in that
>case, yes, there are "SQL Files". If this is the case, then I would
>think you would be able to store the .sql files in a database table
>much like you would a .gif, .jpg, .doc, .txt or anything else
>(although this seems to sometimes be frowned upon by more
>knowledgeable people than I).
>
>In any case, I am having a problem getting IIS 6.0 to serve files with
>a .sql extension. For example, if I have a file sitting out in a
>directory somewhere, such as
>"http://someIISserver/someApp/someFolder/xxx.sql" I get a 404 Error
>when I try to access that URL. I believe this has something to do
>with the Web Service Extensions in IIS 6.0, but I have no idea what
>DLL I should use to serve the .sql files... Any ideas?


You'll need to create a MIME type for the file, see:

http://www.microsoft.com/resources/d...imemapcfg.mspx

If these are SQL scripts, then they're plain text, but it really
depends on what the file is as to what MIME type to add/create.

Jeff


>> There's no such thing as a "SQL File" so it depends greatly on what
>> these files actually are. Show us a sample file and maybe a table
>> structure, or at least tell us exactly what they are and what they're
>> doing. This could be as simple as running a query to INSERT/UPDATE
>> records, it could be you really want to use DTS or any number of
>> options.
>>
>> Jeff
>>
>> >and any examples would be nice or URL that talks about how to do this.
>> >
>> >Thanks for you ideas and help!!


 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
IIS + .Net 2.0 + Upload : temporary files disappears =?Utf-8?B?RGF2aWQ=?= ASP .Net 0 06-23-2007 02:40 PM
upload files into sql server db Andy ASP .Net 2 03-03-2006 05:16 PM
Upload a file without file Upload control - ASP.Net =?Utf-8?B?U2FyYXY=?= ASP .Net 3 08-03-2005 01:09 AM
SQL Server connection string works with IIS 5.1 but not IIS 6 in ASP.NET John Kennedy ASP .Net Web Services 5 08-14-2003 12:15 AM
SQL Server connection string works with IIS 5.1 but not IIS 6 in ASP.NET John Kennedy ASP .Net Security 5 08-14-2003 12:15 AM



Advertisments