cncjay
Well Known Member
We are looking to migrate from AS/400 DB/200 database to Microsoft SQL server
I have some hardware / architecture questions, hopefully the experts here can provide feedback.
1) Our current production data is 1.2 Terybyte on the AS/400 - roughly what would be the size when moved to MS SQL platform ?
2) When moving production data, what would be the best methodology to follow. Running R98403 where source is AS/400 and destination would be MS SQL - that process would be very long. Are there any 3rd party tools or something within MSSQL such as bulk copy or Data Transfer service that I can leverage to expedite this process.
3) We are concerned with having enough arms for the database. Currently, we have 42 - 15K drives on the AS/400. From performance perspectives, what would be a recommendation when looking into a storage system that would at least match the I/O of the current system, hopefully, far exceeding the current performance.
Lastly, what are your thoughts on using SSD drives, how does E1 behave with those ? For some reason our hardware vendor, in general, is steering us away from those, not becuase of E1, just in general.
Thank you in advance for your valuable feedback.
I have some hardware / architecture questions, hopefully the experts here can provide feedback.
1) Our current production data is 1.2 Terybyte on the AS/400 - roughly what would be the size when moved to MS SQL platform ?
2) When moving production data, what would be the best methodology to follow. Running R98403 where source is AS/400 and destination would be MS SQL - that process would be very long. Are there any 3rd party tools or something within MSSQL such as bulk copy or Data Transfer service that I can leverage to expedite this process.
3) We are concerned with having enough arms for the database. Currently, we have 42 - 15K drives on the AS/400. From performance perspectives, what would be a recommendation when looking into a storage system that would at least match the I/O of the current system, hopefully, far exceeding the current performance.
Lastly, what are your thoughts on using SSD drives, how does E1 behave with those ? For some reason our hardware vendor, in general, is steering us away from those, not becuase of E1, just in general.
Thank you in advance for your valuable feedback.