[Modus] convert to sql from access

[Michael B. Smith]

Title: Message

<sigh>

 

Thanks. I was hoping someone here could tell me.

 

I do have that same program in my ModusGate directory.

 

I don't think support is too happy with me these days... but I'll send'em another email...

 

:-P

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Jim Barstow
Sent: Monday, January 19, 2004 4:14 PM
To: [EMAIL PROTECTED]
Subject: [Modus] convert to sql from access

There is a quarantine mover tool in the modusmail directory.. 

 

I think this is its purpose..  Setup your SQL quarantine, then run quarantine mover

---snip---

C:\Program Files\Vircom\modusMail>quarantinemover -?
Usage: quarantinemover
       -m mailbox name <quarantine or spam>
       -s start ID
       -e end ID
       -n number of messages to process
       -w sleep time (ms)

---snip---

and I believe it copies the Native DB over to your current quarantine setup.  You may want to verify how this operates with Vircom first.

 

Sr. Network Engineer
Diversified Solutions and Services, Inc.

22645 Canal Road, Suite B

Orange Beach, AL 36561

(251)980-8968

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Michael B. Smith
Sent: Monday, January 19, 2004 2:11 PM
To: [EMAIL PROTECTED]
Subject: [Modus] convert to sql from access

Sorry, about that.

 

I'm running ModusGate v3, build 282, plus updates 2, 3 and 4.

 

I'm referring to the quarantine database. I want to transition from using the default MDB to using MS-SQL on another server.

 

I know how to create the MS-SQL tables and database, and configure ModusGate -- I just don't know how to get the MDB data into SQL; so my users don't loose anything.

 

Thanks.

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Jim Barstow
Sent: Monday, January 19, 2004 12:37 PM
To: [EMAIL PROTECTED]
Subject: [Modus] convert to sql from access

With a little more detail, are you talking about an extended auth database, quarantine, or what?

 

I have a DTS package I wrote to do this, it was quite simple and only imported a handful of fields from the Access EXT DB to the SQL EXT DB.

 

Unfortunately, I dont know if there is a way to export or save a DTS transaction for you to use.  I simply added an access object, an sql object, and setup data transformations for the fields I needed to copy. Took all of about 10 minutes, maybe 30 for the amature DTS builder.

 

Sr. Network Engineer
Diversified Solutions and Services, Inc.

22645 Canal Road, Suite B

Orange Beach, AL 36561

(251)980-8968

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Michael B. Smith
Sent: Monday, January 19, 2004 9:42 AM
To: [EMAIL PROTECTED]
Subject: [Modus] convert to sql from access

Does anyone have a script/process/whatever to convert from access/mdb to sql/odbc?

 

(I have the script to create the tables, I'm talking about a way to import the old data into the new DB.)

 

Thanks.