Well, it doesn't look like LIMIT/OFFSET it's really an option in SQL Server. Here's an article that describes a way of achieving the same type of result:
http://blogs.msdn.com/sqlserver/archive/2006/10/25/limit-in-sql-server.aspx However, it's not really a drop-in replacement. Perhaps you could tweak yaml_db to recognize the sqlserver adapter and skip the paging part altogether (i.e. put all records in one 'page')? Eric On Jul 16, 10:15 am, "Adam Wiggins" <[EMAIL PROTECTED]> wrote: > On Wed, Jul 16, 2008 at 11:47 AM, etlund <[EMAIL PROTECTED]> wrote: > > When I use the most recent version of yaml_db (from git) it fails to > > export my data from a SQL Server db. The reason is that SQL Server > > doesn't support the 'LIMIT' SQL statement that shows up in the yaml_db > > dump method. > > Thanks for the report Eric. Would it be possible for you to play > around with the sql query it's generating in your sql server's shell > and see if you can find a syntax it supports? Then report that here > and we'll figure out how to turn it into a patch. > > Adam --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Heroku" 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/heroku?hl=en -~----------~----~----~----~------~----~------~--~---
