Extracting Exchange files into sql server db

[bobv]

Does anyone know of a method to extract Exchange data (.edb files) into a sql server database using SQl Server Enterprise Manager? Any help would be greatly appreciated.
Thanks
BV

[Timothy H. Schilbach]

Hey There,

This is a simple issue. All you have to do is go to your Exchange manager and select EXPORT from the TOOLS menu. Select the objects you wish to export and then select a location.

Open up your Enterprise manager for SQL and then select the database in which you wish to import your data too. Select IMPORT and then select TEXT file method. Your CSV will be comma delimited and the first row will be the headers for your table.

Your done! Very simple. Now if you wish to import different fields and you need more data or control over your data, you will need to obtain a copy of the Back Office 4.5 Resource Kit CD. On this CD you will find an applivation called HEADER.EXE. This tool has to be copied to an exchange server in your organization and then ran. It will let you select any field inside of exchange and generate a template file for your export.

Once your file has been generated, then you can export form the Exchange manager and select that file as your destination. You can then import your comma delimited file into your SQL server.

Timothy H. Schilbach
Sr. Messaging Administrator
Snap-on Incorporated
262-656-6184



------------
bobv at 3/25/2002 6:41:11 PM


Does anyone know of a method to extract Exchange data (.edb files) into a sql server database using SQl Server Enterprise Manager? Any help would be greatly appreciated.
Thanks
BV

[bobv]

Thanks for the reply. Also, I am hoping to set this up as a scheduled job in EM, which will extract data on a nightly basis. What I'm looking for is some sort of a db driver. Any info on this.
Thanks again
BV


------------
bobv at 3/25/2002 6:41:11 PM


Does anyone know of a method to extract Exchange data (.edb files) into a sql server database using SQl Server Enterprise Manager? Any help would be greatly appreciated.
Thanks
BV

[Timothy H. Schilbach]

Hey Again,

A data connector would pose a most interresting challenge. Your in luck! it is posisble!

You need to obtain the latest version of the MS SDK from MS at: http://www.microsoft.com/msdownload/platformsdk/sdkupdate/

You can go into it then and look at the section reguarding "Microsoft Exchange Connectors". Yes I sad CONNECTORS. All a connector is a connection from one database to another. Notice the Novell, Lotus, CCMail, MS Mail, MEMO connectors. What do all those systems have in common? They are all databases of some sort.

You have a choice here. Get a connector that will run from a 3rd party, or program on yourself. If you program one yourself I would suggest using C++, but VB can be used as any COM langiage (VB, JAVA, C++, J++) can be used to program a connector.

But I dont want to program a connector! Thats ok, here is an alternative! Simply make a DTS package that runs the mad.exe with a few special command line switches and have an export done to a file on the drive. Have the DTS go further and pickup this file and import it in! Now you have a nightly dump to SQL from a DTS package on the SQL server!

It doesnt get much more simple than that. I have dumped data using the MS Scheduler to a comma delimited file and exported to an LDAP (Netscape) directory for parsing and updates to all users within it. Its simple, its easy, its fun!

Timothy H. Schilbach
Sr. Messaging Administrator
Snap-on Incorporated
262-656-6184



------------
bobv at 3/26/2002 1:19:48 PM

Thanks for the reply. Also, I am hoping to set this up as a scheduled job in EM, which will extract data on a nightly basis. What I'm looking for is some sort of a db driver. Any info on this.
Thanks again
BV


------------
bobv at 3/25/2002 6:41:11 PM


Does anyone know of a method to extract Exchange data (.edb files) into a sql server database using SQl Server Enterprise Manager? Any help would be greatly appreciated.
Thanks
BV

[bobv]

Excellent! I'll give it a try
BV


------------
Timothy H. Schilbach at 3/26/2002 1:30:02 PM

Hey Again,

A data connector would pose a most interresting challenge. Your in luck! it is posisble!

You need to obtain the latest version of the MS SDK from MS at: http://www.microsoft.com/msdownload/platformsdk/sdkupdate/

You can go into it then and look at the section reguarding "Microsoft Exchange Connectors". Yes I sad CONNECTORS. All a connector is a connection from one database to another. Notice the Novell, Lotus, CCMail, MS Mail, MEMO connectors. What do all those systems have in common? They are all databases of some sort.

You have a choice here. Get a connector that will run from a 3rd party, or program on yourself. If you program one yourself I would suggest using C++, but VB can be used as any COM langiage (VB, JAVA, C++, J++) can be used to program a connector.

But I dont want to program a connector! Thats ok, here is an alternative! Simply make a DTS package that runs the mad.exe with a few special command line switches and have an export done to a file on the drive. Have the DTS go further and pickup this file and import it in! Now you have a nightly dump to SQL from a DTS package on the SQL server!

It doesnt get much more simple than that. I have dumped data using the MS Scheduler to a comma delimited file and exported to an LDAP (Netscape) directory for parsing and updates to all users within it. Its simple, its easy, its fun!

Timothy H. Schilbach
Sr. Messaging Administrator
Snap-on Incorporated
262-656-6184



------------
bobv at 3/26/2002 1:19:48 PM

Thanks for the reply. Also, I am hoping to set this up as a scheduled job in EM, which will extract data on a nightly basis. What I'm looking for is some sort of a db driver. Any info on this.
Thanks again
BV


------------
bobv at 3/25/2002 6:41:11 PM


Does anyone know of a method to extract Exchange data (.edb files) into a sql server database using SQl Server Enterprise Manager? Any help would be greatly appreciated.
Thanks
BV