Database —
We’re converting a legacy administrative app from ColdFusion, which runs SQL Server, to Ruby on Rails. Generally speaking, it’s all going very well. There are few important adjustments that have to be made, though, both becasue a legacy app, by nature won’t likely conform to the Rails conventions (table, column names) and [...]
And has been temporarily closed.
After re-writing an existing asp.net app and migrating from 1.1 to 2.0 I was getting the connection pooling error:
System.Web.HttpUnhandledException: Exception of type ‘System.Web.HttpUnhandledException’ was thrown. —> System.InvalidOperationException: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled [...]
SQL Server doesn’t have something like MySQL’s dump client built-in, which is really useful for backing up/recreating tables or the entire database. I know there are some good commercial tools to facilitate data export, such red-gate’s suite, but this is a very nice stored procedure that will generate insert statements you can use to [...]