x

Export data from exchange 2010 into sql 2008

I need to pull the calendar data from exchange into sql. I know exchange uses ESE and I have been unsuccessful finding an easy way to do this.

more ▼

asked Oct 08, 2012 at 01:12 PM in Default

avatar image

Briley
0 1 1 1

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

I tried asking this question a while ago (http://ask.sqlservercentral.com/questions/3452/tsql-to-query-exchange-server-data.html) and got nowhere. I'm afraid its something that simply wont happen, or at least, wont happen simply.

more ▼

answered Oct 08, 2012 at 01:52 PM

avatar image

Fatherjack ♦♦
43.7k 79 97 117

There is an ODBC driver for exchange... Or maybe that came with Crystal reports.

Oct 08, 2012 at 04:24 PM sp_lock

Oh... Just seen that I tried to help last time ;-)

Never done it before, but powershell could be a reasonable way forward.

Oct 08, 2012 at 04:27 PM sp_lock

So AgendaX queries exchange for the data?

Oct 09, 2012 at 02:20 PM Briley

yes, install and point to your mail server and bingo.

Oct 09, 2012 at 02:22 PM Fatherjack ♦♦
(comments are locked)
10|1200 characters needed characters left

I think the best way to do this is going to be with a third party software. From doing more research I found MX-Sync that is supposed to be able to do this. Has anyone ever tried it?

more ▼

answered Oct 09, 2012 at 02:11 PM

avatar image

Briley
0 1 1 1

To get just the schedule information we use a product called AgendaX. Its pretty reliable but does have a habit of needing a lot of resources when it scans that Exchange data.

Not heard of the product you mention so cant comment

Oct 09, 2012 at 02:15 PM Fatherjack ♦♦
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x35

asked: Oct 08, 2012 at 01:12 PM

Seen: 1449 times

Last Updated: Oct 09, 2012 at 02:22 PM

Copyright 2016 Redgate Software. Privacy Policy