|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
January 14th, 2004, 04:34 PM
|
|||
|
|||
|
Fill a bimary field by Enterprise Manger
Dear all,
I have created a table with a binary field. How can I store a pdf file into it by using Enterprise Manager? Thanks. Regards, Ivan
|
|
#2
January 14th, 2004, 04:42 PM
|
||||
|
||||
|
Sorry if this isn't the answer you are looking for, but it is far more efficient to store the PDF in a folder and put the PDF's link or path in the database.
|
|
#3
January 14th, 2004, 04:49 PM
|
|||
|
|||
|
Thanks for your quick reply. In fact I am still think about whether to store the files in DB or just store the links.
Can you suggest the pros of storing links or the cons of storing files in DB? I just thought storing the files in DB can save efforts to update the links if I store just the links and migrate the server. Thanks.
|
|
#4
January 14th, 2004, 04:53 PM
|
||||
|
||||
|
When you store and retrieve the document in the database, you are moving a lot of bytes across the network. This is very inefficient. It's better to store the data in a folder somewhere and put the link to the data in the database.
|
|
#5
January 15th, 2004, 06:31 PM
|
|||
|
|||
|
how tables & database created told stepwise
|
|
| Viewing: ASP Free Forums > Database > Microsoft SQL Server > Fill a bimary field by Enterprise Manger |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
