• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 802
  • Last Modified:

Database Convert -- AS400 to Microsoft SQL server ?

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
finance_teacher
Asked:
finance_teacher
4 Solutions
 
LowfatspreadCommented:
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
 
shalomcCTOCommented:
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
 
Gary PattersonVP Technology / Senior Consultant Commented:
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
 
Aaron ShiloChief Database ArchitectCommented:
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
 
tliottaCommented:
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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now