[Modus] convert to sql from access

[Michael B. Smith]

Title: Message

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.