Sign in to follow this  
Followers 0
sureshksva

Automation Script required

4 posts in this topic

Hi,

We want to migrate data from MSAccess to Oracle Database. We are uisng Oracle 11g. Can any one please provide me the automation script for this?

I have done this manually by using SQL developer.

I am looking for automation if possible.

Thanks.

Share this post


Link to post
Share on other sites



sureshksva,

Welcoem to the AutoIt forum. :)

But not the best start.

Firstly you have posted this in the "Examples" section - but I will move it to the correct section in a moment. However, please take care when posting in future.

And then we do not write scripts to order - we help YOU get your own scripts working as you wish. However, you might get lucky and find some kind soul who has something ready to go and does not mind sharing. ;)

M23


Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind._______My UDFs:

Spoiler

ArrayMultiColSort ---- Sort arrays on multiple columns
ChooseFileFolder ---- Single and multiple selections from specified path treeview listing
Date_Time_Convert -- Easily convert date/time formats, including the language used
ExtMsgBox --------- A highly customisable replacement for MsgBox
GUIExtender -------- Extend and retract multiple sections within a GUI
GUIFrame ---------- Subdivide GUIs into many adjustable frames
GUIListViewEx ------- Insert, delete, move, drag, sort, edit and colour ListView items
GUITreeViewEx ------ Check/clear parent and child checkboxes in a TreeView
Marquee ----------- Scrolling tickertape GUIs
NoFocusLines ------- Remove the dotted focus lines from buttons, sliders, radios and checkboxes
Notify ------------- Small notifications on the edge of the display
Scrollbars ----------Automatically sized scrollbars with a single command
StringSize ---------- Automatically size controls to fit text
Toast -------------- Small GUIs which pop out of the notification area

 

Share this post


Link to post
Share on other sites

That quite a task there. It can probably be accomplished using ODBC but would still take a lot of condition handling for a fully automated solution.

How are you accomplishing it using SQL Dev? You could automate those keystrokes which would be a dirtier automation but simpler than starting from scratch.

Share this post


Link to post
Share on other sites

Hi Melba,

Thanks for your suggestion and from next time onwards will do the same.

@Spudw2k,

Have created .mdb file and repository and created a new task for the task then using TOOLS>Migrate>Associate Migrate... ..> COPY to Oracle then data got migrated from MSAccess to Oracle Database.

Thanks.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0