Replacing an old Lotus Notes system...

for a couple hundred users... These folks currently replicate several Notes databases at least once a day.
Do you think I'm crazy for considering a new solution with SQL Server in the middle and MSDE or SQL Personal edition on all the remote machines? Is it feasible or am I trying to fit a sqaure peg in a round hole?
The way to do this with the least amount of work is to migrate to Exchange
and take your public folders offline.
"Curious" <anonymous@.discussions.microsoft.com> wrote in message
news:4D54C201-725B-445E-8581-A1CE9B7C0DF6@.microsoft.com...
> for a couple hundred users... These folks currently replicate several
Notes databases at least once a day.
> Do you think I'm crazy for considering a new solution with SQL Server in
the middle and MSDE or SQL Personal edition on all the remote machines? Is
it feasible or am I trying to fit a sqaure peg in a round hole?
|||Thanks Hillary, but I think we're looking for a more traditional RDBMS environment with constraints, triggers, easy reporting via SQL queries, probably through a Windows UI...
|||Then what you are going to wind up doing is creating an application which
can browse the documents in Notes, extract them, and load them into SQL
Server. You will also have to pay attention to any document linkages. You
are also going to have to build some intelligent application logic to
extract discrete data within forms to load them into tables. It can be
done, but there is no easy or clean way of doing it.
Mike
Principal Mentor
Solid Quality Learning
"More than just Training"
SQL Server MVP
http://www.solidqualitylearning.com
http://www.mssqlserver.com