Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 831
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

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