Solved

Database Convert -- AS400 to Microsoft SQL server ?

Posted on 2013-02-04
5
712 Views
Last Modified: 2013-02-20
Do you have a generic script to automatically take the entire AS400 database (or one table) and convert it to a new Microsoft SQL server database (or one table) or export to CSV/etc files ?
0
Comment
Question by:finance_teacher
5 Comments
 
LVL 50

Expert Comment

by:Lowfatspread
ID: 38851217
have you considered using import  or replication?

which versions of sql server and as400 ?

what are you actually trying to achieve?

normally you would just use your database modelling package to generate a schema for a "new/different" database system....
0
 
LVL 33

Accepted Solution

by:
shalomc earned 125 total points
ID: 38851338
There is an AS400 command that dumps the contents of a table to CSV.  
It is called CPYTOIMPF. You will then have to copy the csv file over to a PC either via a shared disk, or via FTP.
0
 
LVL 34

Assisted Solution

by:Gary Patterson
Gary Patterson earned 125 total points
ID: 38851430
Here's a nice method.  Requires you configure the DB2 database as a linked server, so you need a connection to the source database:

http://www.mssqltips.com/sqlservertip/1896/dynamically-import-data-from-a-foreign-database-using-a-sql-server-linked-server/

IF you don't have a connection to the source database, post back and we can discuss other options.

- Gary Patterson
0
 
LVL 15

Assisted Solution

by:Aaron Shilo
Aaron Shilo earned 125 total points
ID: 38851507
Open the SQL Server Business Intelligence Development Studio and create a new SSIS project. Add a data pump task. Add a source object as being the AS/400 and a destination as being the SQL Server. Select the objects to copy. When you run the package the data will be copied to the SQL Server.
0
 
LVL 27

Assisted Solution

by:tliotta
tliotta earned 125 total points
ID: 38853452
Be aware that there might be various elements of the AS/400 'database' that have no corresponding elements in SQL Server. If you are converting a SQL database, it might be more straightforward than if it's a 'native' database.

Tom
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How to share SSIS Package? 6 37
SQL Error - Query 6 26
VB.NET 2008 - SQL Timeout 9 24
SQL Query Help Top 1 and Distinct? 6 26
Read about achieving the basic levels of HRIS security in the workplace.
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how the fundamental information of how to create a table.

778 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question