Migration of Data

[pratip]

Hi,

I want to know about "Migration of Data". How can I use it.

Thanks,
Pratip

[saravanankm]

Hi

Pls visit this Site Oracle database Migration Information

http://dba-services.berkeley.edu/docs/oracle/manual-9iR2/server.920/a96530/migintro.htm

I hope this is helpful for U!

With Regards
Captain

[PetrusvdM]

Hi,

I want to know about "Migration of Data". How can I use it.

Thanks,
Pratip

You can try to use ThoughtScape Designer, the coolest by far !

Not sure, I think their official web site url is:
www.teleiossoftware.com

Proceed to migrate as follows:
==============================
* Import the strucure of the MS-Access db
* Create a new catalog (for sql server), copy this structure there and copy export the struture
* Define a new migration set and execute !

Detailed Step-by-step description: I'm in the mood to explain ...
----------------------------------

* Create a new Dictionary (A dictionary can hold multiple catalogs: A catalog represents a database if you do not know ThoughtScape)

* Import the structure of the MS-Accces database into the dictionary
as a catalog
- Dictionary Menu
- Import Structure Menu Option
- Identify your MS Access database as the db to import

* Create a new Catalog (To hold the target structure).
- Select Microsft SQL server 2000 or 2005 as the Plugin Type
- Specify the database connection parameters

* Copy the tables (the table structure and relations ...) from the MS Access Catalog to the SQL Server Catalog
- Right Click on the MS-Access catalog in the component pool
- Click "Copy Tables From" on the popup menu
- Select all the tables selecting the check-box next to the
MS-Access catalog tree node
- Click OK

* Export the copied structure
- Right Click on the Sql Server component pool node
- Click the "Force Export Structure" popup menu item
- Click Yes
- The Db will be created and the table and relation strucre with it

* Define a migration set from the MS-Access catalog to the Sql Server Catalog
- Right Click on the Sql Server Catalog that you created
- Click: "Define Migration Set To" popup menu option
- Graphical Migration setup box appears ...
- Right Click in the left gray area
- Click the "Add Source Catalog" popup menu
- Select the "MS Access Catalog" that you created as a source
- Right Click in the Center Right Area
- Click the "Map By Name" popup menu item
- ThoughtScape automatically maps all tables and all columns by name
- Alter Any of the mappings if desired by draggin and dropping if you so desire
- Close the Migration Set Dialog
* Locate the newly created set in the Tables tree-view of the component pool - Under the "Sql Server catalog", "Migration Sets" - "Migration Set 1"
* Execute the migration !!!!
- Right Click on the Migrationm Set node in the component pool
- Click the Execute Migration popup menu item
- This tsep will move all your data !!!

:>

[PeaBrain]

I am using a product called "ThoughtScape Designer", Its the best, you can do data migrations or even migrate the database to any platform. Check it out ! I dont have a url but do a search on the name.