Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
PeaBrain
Starting Member
2 Posts |
 Posted - 2008-01-21 : 03:31:37
|
| HI GuysI have a vary large NS-Access database that needs to be migrated with its data to SQL Server, are there any good tools available to do this ?How would one proceed doing this ? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-01-21 : 03:42:22
|
Use "Upsize Wizard".
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
PetrusvdM
Starting Member
1 Post |
Posted - 2008-01-21 : 10:13:14
|
Use ThoughtScape Designer, the coolest by far !Not sure, I think their official web site url is:[url]www.teleiossoftware.com[/url]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 dictionaryas 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
Starting Member
2 Posts |
Posted - 2008-01-22 : 00:45:46
|
| Thanks guys, I had a look at the Upsize and ToughtScape tool. The ThoughtScape tool is worth a look ! |
|
|
|
|
|
|
Datbase Migration