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 |
|
robvolk
Most Valuable Yak
15732 Posts |
 Posted - 2005-03-29 : 10:30:38
|
| I haven't read all of the SQL Team posts on this yet, but I would appreciate any advice and experience people have with moving AS/400 data & databases to SQL Server. I don't have all the details on the system I'm migrating, but I have a couple of general questions:- Moving data method: DTS, bcp, text files, other?- Database documentation for AS/400, tools available? anything like INFORMATION_SCHEMA views?- Data type conversion issues- Data relationship conversion issues- Data volume issues, would a certain amount be too much to reasonably migrate?I do know that almost all of the code used in AS/400 is RPG, and the basic format of the data is flat file. Some of the data is partitioned across two different machines as well. The developers have created .Net applications to access the data directly, using the Ritmo product offered here:http://www.hitsw.com/products_services/sqldb2/ritmodb2/ritmodb2.htmlIf anyone has used this in the past, would it help to migrate or maybe document the database?Thanks for your input. |
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2005-03-30 : 09:10:33
|
| When we did it we dumped the dbs to flat CSV files which I dropped into a SQL table then split back into Relational tables in SQL with SPs. All the dumps were done manually by an RPG programer to a desktop hard drive via cable interface.Took 3 days to dump all the DBs. This Probubly does not help but I feel your pain and offer sympathetic support.JimUsers <> Logic |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-03-30 : 20:42:57
|
| Thanks Jim. I managed to get a set of schema docs from them and everything is flat file, so it should convert pretty easily. The developers there are pretty sharp, they've already overcome a lot of things and they swear by Ritmo, so they can do up a .Net file maker if I need one.BTW, does DB2 or RPG provide a standard tool to document the schema of a file? How does the schema get stored anyway? |
|
|
|
|
|
|
|
|
AS/400 Data Migration Question(s)