David Three options really
1. BCI with suitable UNIX ODBC driver - EasySoft is/was the recommended choice. One of their guys is on the list, though IIRC they have changed their name. The advantage is that with BCI you are pushing, so you control the content and don't have do deal with the overheads in the odbc client. So long as you do it right (e.g. call sensible stored procedures on the SQL Server side, look at MERGE if using SQL Server 2008) you can get good volumes across. One of my clients uses it heavily for posting trades. 2. OleDB/ODBC etc. client using DTS or SSIS Can be hard work and slow depending on how well or badly defined your database is now. 3. Middle tier Pull out the data using UniObjects and post from a .Net middle tier. That's what my tools [AD] conduit [/AD] does or you can roll your own. Brian -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Norman, David (Health) Sent: 13 August 2010 01:24 To: 'u2-users@listserver.u2ug.org' Subject: [U2] Unix to SQLServer In the dying months of our major application, we are looking at sending small amounts of data from UniVerse 10.0.16 HP-UX 11 to an SQLServer database every few minutes from a phantom. I assume ODBC would be the way to go, with middleware from someone. Which middleware do people recommend ? Is there any which doesn't require UniVerse to be stopped to install ? I looked on the Wiki but didn't find anything about this. Thanks, ======================== David Norman Senior Software Engineer - SA Ambulance Service ICT Services SA Health Government of South Australia Box 3, GPO Adelaide, South Australia 5001 *+61 8 8274 0384 * fax +61 8 8271 4844 * david.nor...@health.sa.gov.au This e-mail may contain confidential information, which also may be legally privileged. Only the intended recipient(s) may access, use, distribute or copy this e-mail. If this e-mail is received in error, please inform the sender by return e-mail and delete the original. If there are doubts about the validity of this message, please contact the sender by telephone. It is the recipient's responsibility to check the e-mail and any attached files for viruses. _______________________________________________ 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
