Re: [U2] Convert data from UniData to Microsoft SQl server
I think you multiply by a thousand and round up -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
Re: [U2] Convert data from UniData to Microsoft SQl server
Multiple what by a thousand and round up ? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan Ell Sent: Wednesday, May 15, 2013 9:32 AM To: U2 Users List Subject: Re: [U2] Convert data from UniData to Microsoft SQl server I think you multiply by a thousand and round up -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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Convert data from UniData to Microsoft SQl server
On 15/05/13 18:43, Kathleené M Hunter wrote: Multiple what by a thousand and round up ? Measure the disk space used by your Unidata account, and convert Kb to Mb. And Dan Ell is only *half* joking. Really. I did an account dump and transfer to SQL-Server, and SQL-Server really did take on the order of one order of magnitude more disk space! Cheers, Wol -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan Ell Sent: Wednesday, May 15, 2013 9:32 AM To: U2 Users List Subject: Re: [U2] Convert data from UniData to Microsoft SQl server I think you multiply by a thousand and round up -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 ___ 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
Re: [U2] Convert data from UniData to Microsoft SQl server
The amount of disk space the Unidata files are using -Original Message- From: Kathleené M Hunter kmhun...@resolutionprovider.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Wed, May 15, 2013 10:44 am Subject: Re: [U2] Convert data from UniData to Microsoft SQl server Multiple what by a thousand and round up ? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan Ell Sent: Wednesday, May 15, 2013 9:32 AM To: U2 Users List Subject: Re: [U2] Convert data from UniData to Microsoft SQl server I think you multiply by a thousand and round up -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 ___ 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
Re: [U2] Convert data from UniData to Microsoft SQl server
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
Re: [U2] Convert data from UniData to Microsoft SQl server
The last one I saw was a 20MB UniData file took up 200MB in SQL Server. Having said that, it is *highly* dependent on the nature of your data, how many multivalued/sub-multivalued attributes there are (and how deep), as well as what data types you select for your SQL schema. This means there is generic way to calculate how much your data will expand when stored in SQL Server - other than actually trying. For what purpose are you moving data into SQL Server? Cheers, Dan -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 10:26 AM 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