Re: Is storing images in sql really that bad now?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Jake (rondican_at_hotmail.com)
Date: 09/17/04 

Date: Fri, 17 Sep 2004 07:18:35 -0700

Adrian,

    Will the new msde 2005 be able to handle merge replication? I tested
Merge (granted it was justa couple of rows of data) between MSDE and sql2k
and it worked. I don't want to spend a lot of time testing this if someone
knows for sure that merge replication will not work.

Jake

"Adrian Edwards" <a.n.other@hotmail.com> wrote in message
news:cieqt7$edm$1@sparta.btinternet.com...
> The only issues I can see are MSDE works great with a couple of
> connections but is deliberately set to degrade with more than 5-8 users.
>
> Replication may be an issue, transactional replication between SQL
> Server and MSDE is not a problem but I'm not sure the other way. Merge
> replication does no work with MSDE.
>
> Adrian
>
> Jake wrote:
>
> > Hello,
> >
> > I have seen a lot of articles and comments trying to disuade
people
> > from storing photos images in sql2k and msde. My question is why?
> > Microsoft's sharepoint technology stores all .doc, .xls, .pdf, .jpg,
etc.
> > into sql2k or msde depending on what backend you are using. Here is the
> > issue we are running into and would appreciate suggestions. We have an
> > application that is running on a windows 2000 tablet pc. Currently the
app
> > (coded in vb.net) takes data from the access database (that resides on
the
> > tablet pc) and moves it to our Sql Server in the office via the internet
as
> > some staff are in different states. The application also transfers .jpg
and
> > .tif files between the server and the client(currently stored as files).
We
> > are having issues with scalability due to the amount of growth we have
been
> > experiencing. Two years ago there was about 15 users running this
> > application, now there are over 60, with growth expected to continue. My
> > question is can MSDE help solve this problem. I was thinking that if I
use
> > MSDE on the client and tweak the application to store the .jpg and .tif
> > files into the MSDE then I could have SQL manage the replication. I know
> > there is a limitation of 2 gigs on MSDE and we would make a temp db that
the
> > clients would replicate to and move the data up to the live database
thus
> > hopefully eliminating that issue. So basically with the amount of data
we
> > are transferring can MSDE accomplish this with Sql Server at the office,
> > thus eliminating our vb.net application? The average size for a .tif or
.jpg
> > is between 200k and 3mb. Thanks in advance
> >
> >

Relevant Pages

  • Re: Replication with SqlServer and MSDE
    ... You can set up replication with one SQL Server and multiple MSDE instances. ... how replication works with Identity fields (I insert a Order in my laptop ...
    (microsoft.public.sqlserver.programming)
  • Re: Replication between MSDE and SQL Server 2000
    ... replication process between the SQL Server 2000 and the laptop MSDE? ... As I am investigating the database to do this project, MSDE is an option, ... The reason why I need to do the replication is the sales persons bring the ...
    (microsoft.public.sqlserver.replication)
  • Re: merge replication doesnt work properly
    ... Looking for a SQL Server replication book? ... But on the other end there is a MSDE, ... >> Hilary Cotter ...
    (microsoft.public.sqlserver.replication)
  • RE: Smart Client & Replication
    ... As for replication type, ... If you are using MSDE on the client, ... queued updating subscribers. ... Paul Ibison SQL Server MVP, ...
    (microsoft.public.sqlserver.replication)
  • Re: Transaction Replication und MSDE
    ... >>> ich hatte eine Transaction Replication mit 2x MSDE geplant. ... >>> geht leider aber nicht da MSDE nicht als Verleger oder Verteiler ... Versuch gerade per osql eine Merge Replication ... Leider scheint in sp_adddistributiondb ein kleiner Fehler ...
    (microsoft.public.de.sqlserver)