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 |
|
enak
Starting Member
34 Posts |
 Posted - 2007-08-28 : 12:34:28
|
| I have been asked to look into converting a DBase II database on an AS400 to MS SQL Server 2000 or newer running on Windows 2003 or newer.I know that it can be done but how hard will it be and how long could it take?Are there any conversion packages out there that will do the majority of the leg work for us?We also need to convert all of the screens written in RPG to a web based application. We want to get rid of the AS400.Thanksenak |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-08-29 : 06:47:00
|
I would imagine you can point DTS (Data Transformation Service) at the Dbase files (using an ODBC driver etc.) and just import the table structure and data without much effort.Beyond that it depends on how your application connects to DBase. If its written in DBase it will need to be changed to something else (or maybe it can be changed to just point to the new database, now in SQL Server, via ODBC [I don't know enough about DBase to know if that is possible].If its written in something OTHER than DBase, and just using DBase to store the data, it should be relatively easy (again, using ODBC) to point the application at the new database, now in SQL Server.(For "ODBC" also read OLEDB and ADO  )Kristen |
 |
|
|
Ifor
Aged Yak Warrior
700 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-08-29 : 08:52:24
|
| "A RPG program on an AS400 is likely to be using DB2, not dBaseII!"hehehe ... well spotted! |
|
|
|
enak
Starting Member
34 Posts |
Posted - 2007-08-31 : 11:57:22
|
Thanks for the link. I have read that and will pursue it further.One path I am investigating is whether or not we should convert from the AS400 platform and (sorry) DB2 and go with a pc server and microsoft based software.Do you have an opinion on that?quote:
Originally posted by Ifor
A RPG program on an AS400 is likely to be using DB2, not dBaseII!It may be necessary to buy a third party driver in order to establish a connection.This may be of interest:http://www.ml-software.com/fileadmin/template/user_upload/oRPGWhitePaper_v1.2.pdf
|
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-31 : 14:54:46
|
| It's hard to say since should you convert AS400 based system to windows based depends on many factors. You need ask yourself what's motivation of such convertson. AS400 doesn't work your way? Cost too much to keep it? Like to explore windows technology after spent too much time on RPG? |
|
|
|
|
|
|
Conversion of DBase II to SQL Server