Re: SQL Server questions

2007-11-23 Thread David Avendasora
I am using Microsoft SQLServer 2000 with the MS JDBC driver on my projects and once I started using Chuck's DB context delegate everything has worked just fine. I have not yet upgraded to SQLServer 2005. I can't get away from it, so I've learned to "embrace" it. The dirty feeling goes away,

Re: SQL Server questions

2007-11-19 Thread Chuck Hill
On Nov 19, 2007, at 6:56 AM, Randy Wigginton wrote: Does anyone have experience with connecting new world order WO to a sql server database? You are referring to Microsoft SQL Server or a generic "a sql server database"? I am using MS SQL on the project I am working on now. You may run

Re: SQL Server questions

2007-11-19 Thread Steve Quirk
I've use the jtds jdbc lib and the freetds command line tool in the past. http://jtds.sourceforge.net/ http://www.freetds.org/ I don't have any experience migrating the entire db though. But how hard could that be? ;-) -steve On Mon, 19 Nov 2007, Randy Wigginton wrote: Does anyone have

Re: SQL Server questions

2007-11-19 Thread Simon J. Oliver
I have similar situation where I need to periodically extract a few gigs of data out out umpteen MS SQL Server tables and put it into MySQL. I tried various different migration tools and had the most success with SQLYog ( http://www.webyog.com/en/ ). It's commercial software ($100, less if

SQL Server questions

2007-11-19 Thread Randy Wigginton
Does anyone have experience with connecting new world order WO to a sql server database? There is a jdbc driver, so theoretically it should "just work"... but it kills SQL Explorer and Eclipse every time I try to look at it. Does anyone have some suggestions on how to get data out of sql s