Thanks for all of the suggestions. I was a little off in what it is that we want to do with this, but all of your suggestions were very helpful. What they really wanted was a way to compare data in SQL Server and UV. So we are probably going to write a .NET app that sits in the middle and pulls the data from both sides into datasets and compares them for differences.
Thanks, Nick Cipollina -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Tod Sigafoos Sent: Friday, February 03, 2006 10:14 AM To: Nick Cipollina Subject: Re: [U2][UV] Universe and SQL Server Nick, Thursday, February 2, 2006, 1:41:23 PM, you wrote: NC> Hello all, NC> We are currently looking into ways to share our data between NC> universe and SQL Server, and I am trying to get some suggestions NC> on the best way to do this. We are currently generating text NC> files in UV and ftp'ing those files to a designated location. We NC> have a task scheduler that picks up the files when they arrive and NC> inserts them into SQL server. I know there are ways to NC> communicate directly between SQL server and Universe and I am NC> looking for the best way to do this. It doesn't matter if NC> Universe reaches out to SQL Server or vice versa. Thanks. I think you will find the BCI client of Universe to be very good at the communication to SqlServer. Last year I worked with a client who needed the same type of communication. We developed a couple of routines they could use to 'read/write' SqlServer with minimal interference with the Universe developers. It turned out faily well .. quick and error free. There really is no need to go to any 'external middleware' answer when all the tools are right there. It lowers maintenance as your developers don't need to learn anything new (although that IS always fun). Give it a try .. ask questions here. -- DSig ````` David Tod Sigafoos ( O O ) _______oOOo__( )__oOOo_______ 'Politics is like driving. To go backward, put it in R. To go forward, put it in D' unknown ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
