There are a lot of factors that will determine this. The main thing is the data types used on the SQL side. See the following link for size of each data type http://msdn.microsoft.com/en-us/library/ms172424(v=sql.100).aspx
As a rule of thumb using the fixed length data types will take up more space than the variable length data types. Another piece that will contribute to your size is the fact you will need to create cross-reference tables, where you can do multivalues in UniData. As a rough estimate we have seen a 2:1 ratio in the amount of disk space used. HTH -Dan Dan Goble | Senior Systems Engineer Interline Brands, Inc. 804 East Gate Drive Suite 100, Mount Laurel, NJ 08054 Office: 856.533.3110 | Mobile: 609.792.6855 E-mail: dan.go...@interlinebrands.com | Website: www.interlinebrands.com This e-mail and any files transmitted with it are confidential and intended solely for the individual or entity to whom they are addressed. Please notify the sender immediately by e-mail if you have received this e-mail in error and delete all copies of this message. -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kathleené M Hunter Sent: Wednesday, May 15, 2013 12:26 PM To: u2-users@listserver.u2ug.org Subject: [U2] Convert data from UniData to Microsoft SQl server Does anyone have a way to calculate the disk space required to move data from a UniData Server to a Microsoft SQL server. _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
