Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Export data to Microsoft SQL Server 7.0 1
- Thread starter diegoful
- Start date
-
1
- #2
The fastest way is to export a view from the notes database to a comma separated text file, an then use SQL Servers' bulkload utility.
Bulkload can be comtrolled via OLE if I'm not mistaken, so you could probaly control it all from Notes.
If the size of the data is not too much, use can have notes attach to SQL Server via ODBC and move the information that way.
Wayne
Bulkload can be comtrolled via OLE if I'm not mistaken, so you could probaly control it all from Notes.
If the size of the data is not too much, use can have notes attach to SQL Server via ODBC and move the information that way.
Wayne
- Status
