sql help
- From: kostas papadakis
- Date: Thu, 26 Nov 2009 22:54:15 -0800
hello my names is kostas i am from greece.
i have 1 linux server and 4 counter strike servers (game servers)
here is plugin \Steam\steamapps\kostasprimavera\dedicated server\cstrike\plugin.txt
and i need to send me from the server 1 file by sql
anyone know how to send this file
Uri Dimant wrote:
StuI'd say it depends on business requirements.
12-?e?-07
Stu
I'd say it depends on business requirements. What if application are
configured to modify files via SQL Server? What if you need to transfer the
database , you will have to transfer all filesystem as well. So it is
really depends
"Stuart Ainsworth" <stuart.ainsworth@xxxxxxxxx> wrote in message
news:31c9a134-80fc-48b1-a075-4e340b21e21e@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Previous Posts In This Thread:
On ?et??t?, 12 ?e?e?????? 2007 2:17 p?
Uri Dimant wrote:
StuI'd say it depends on business requirements.
Stu
I'd say it depends on business requirements. What if application are
configured to modify files via SQL Server? What if you need to transfer the
database , you will have to transfer all filesystem as well. So it is
really depends
"Stuart Ainsworth" <stuart.ainsworth@xxxxxxxxx> wrote in message
news:31c9a134-80fc-48b1-a075-4e340b21e21e@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On ?et??t?, 12 ?e?e?????? 2007 5:42 p?
eric wrote:
File Transfer using SQL connection
Lots of people say they store BLOB/LOB data using the file system
instead of in the SQL database. OK, fine. But can I at least
transfer the BLOB data using the SQL connection so I don't have to
worry about sharing a drive, or setting up another server (like IIS/
HTTP or FTP)?
On ?et??t?, 12 ?e?e?????? 2007 5:42 p?
Stuart Ainsworth wrote:
Re: File Transfer using SQL connection
On Dec 11, 10:28 pm, eric <es...@xxxxxxxxxxxx> wrote:
Short answer: no.
By storing the path to the file in the database rather than the file
itself, you are assuming that your client can use the path (and
appropriate connection information) to access the file. The SQL
database (and SQL connection) are simply used to tell you where the
file is.
Stu
On S???at?, 15 ?e?e?????? 2007 4:51 p?
eric wrote:
Re: File Transfer using SQL connection
On Dec 12, 12:17 am, "Uri Dimant" <u...@xxxxxxxxxxx> wrote:
So do you have any ideas for me? I know it is possible, for example,
a custom stored procedure could take the data sent from the client and
save it to a file. It could also read data from a file and return it
to the client. I know that much from reading posts on this newsgroup,
but I don't know how to write a custom stored procedure, and before I
learn I'd like to see if I have other options, or know what other
issues I'll run in to.
I know about the possible issues related to backup/restore, or trying
to copy a database, but I really don't have the option of keeping the
files inside the database anyway, because some customers will be using
the Express version with a limit of 4GB. A single file could be
500MB, so they would reach the limit quickly, plus from other posts
I've read, it is better not to keep files that large in the database
anyway (even if I could).
On S???at?, 15 ?e?e?????? 2007 4:51 p?
eric wrote:
Re: File Transfer using SQL connection
On Dec 11, 8:36 pm, Stuart Ainsworth <stuart.ainswo...@xxxxxxxxx>
wrote:
I'd like to *not* make that assumption. Also, I probably wouldn't
store the path and filename, I'd just use a naming convention that
used the row's unique ID as the file name, and all of the files would
be kept in a designated location. The client-side would just use the
row ID to request a file.
I'm pretty sure what I want to do will require stored procedures, and
probably a custom stored procedure, so I guess maybe I'll be able to
answer my own question once I learn more about them. It also looks
like MSSQL 2008 has a new FILESTREAM column type, which is designed
for larger files... I may be able to wait for that to be released, but
it would only help me if it is also included in the Express version,
and only if files stored in that way would not count towards the
overall 4GB database limit that the Express version has. So far I
don't see any details on the 2008 Express version.
On S???at?, 15 ?e?e?????? 2007 4:51 p?
eric wrote:
Re: File Transfer using SQL connection
On Dec 12, 12:12 pm, eric <es...@xxxxxxxxxxxx> wrote:
Yee-ha! Just found this quote on MSDN:
"SQL Server Express supports FILESTREAM. The 4-GB database size limit
does not include the FILESTREAM data container" --
http://msdn2.microsoft.com/en-us/library/bb895334(SQL.100).aspx
So if I can wait until 2008 comes out, and this FILESTREAM stuff works
as stated, sounds like exactly what I need.
EggHeadCafe - Software Developer Portal of Choice
Get Volume Serial Number in C#
http://www.eggheadcafe.com/tutorials/aspnet/473acdd3-eb2d-4620-8b54-4058ff9aff29/get-volume-serial-number.aspx
.
- Prev by Date: me
- Next by Date: Re: Why can't recursive queries contain...?
- Previous by thread: me
- Next by thread: How costly is it to use BCP or OPENROWSET to create Excel files?
- Index(es):
Relevant Pages
|
