Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-07-22 : 08:18:01
|
| Hugh writes "I need to import (or convert)data from a Lotus Domino4 database to a SQL 7. What is the best way to do that?" |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2002-07-23 : 04:47:20
|
| Get the drivers for Lotus in SQL, then use DTS, to import the data..I know there is a notes driver, but not sure on the domino driver, you may already have it on your machine if you have domino...PeaceRick |
 |
|
|
setbasedisthetruepath
Used SQL Salesman
992 Posts |
Posted - 2002-07-26 : 17:04:12
|
| And then get ready for pain. A Lotus Notes conversion is a difficult task for a few reasons: (1) the Notes ODBC driver is somewhat less than robust, (2) the Notes authentication scheme ( your .nsf flat file if I remember correctly ) is also less than robust and you may encounter resistance moving that file to the database server, and (3) Lotus Notes is not a database product; rather, it is a record management system in the same vein as Btrieve. Notes developers do not use relational concepts in their "database" designs and this causes (or will cause for you later) immense headache.Jonathan Boott, MCDBA |
|
|
|
|
|
|
Importing a Lotus database to SQL