On Tue, Aug 25, 2009 at 11:26 PM, George<[email protected]> wrote: > > Hi there, > > I found Clifford Heath's SQL Server Adapter at > http://github.com/cjheath/do/tree/master. > Presumably that is what's needed to connect to a SQL Server database > but I've no idea how to make use of it! > After downloading do we run a command to install it or copy it to a > folder or what? > Many thanks for your patience. > George
Hi, I noticed a couple tweets out there about SQL Server support: http://twitter.com/GeorgeAdamson/status/3533151672 http://twitter.com/trydionel/status/3388238838 There are two components needed to support a particular vendor's RDBMS in DataMapper: - one is a low-level DataObjects Driver implementation (which handles stuff like making connections, reading results, mapping SQL types to Ruby types, etc.), - and the other is a DataMapper Adapter (which concerns itself with the SQL-generation side of the ORM, and thus also, the dialectical differences between different implementations of SQL.) This is the current state of development for supporting SQL Server: In the case of SQL Server, the DataObjects Driver, has been been implemented to a certain degree: - I merged in Clifford Heath's (cjheath) work on a SQL Server DataObjects Driver for MRI into the DataObjects repo, next branch. Unfortunately, I haven't had a chance to test how well this is working and there is likely some breakage. - I created a SQL Server DataObjects Driver for JRuby (JDBC). The vast majority of tests are passing for this. About 10% of tests are failing, primarily due to issues with Date/Time support. Its been a couple of years since I've done anything serious with MSSQL, so its taken a little time to get back up to speed. I've also only tested my work against SQL Server 2008 Express Edition. As with most MS endeavors, there are a ton of different SKUs out there, and I don't know how far back we'd want to support (i.e. 7, 2000, 2005, 2008.) The second part of the equation, the SQL Server DataMapper Adapter, is available in cjheath's dm-core fork, next branch. (see: http://github.com/cjheath/dm-core/blob/5b1313e3c57b642a316e10d25d6b10dac35d89fc/lib/dm-core/adapters/sqlserver_adapter.rb) If you're interested in accelerating the development, I'd encourage you to go ahead and try working with the Driver/Adapter and give us some feedback here. Alex --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "DataMapper" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/datamapper?hl=en -~----------~----~----~----~------~----~------~--~---
