Monday, June 14, 2010
The Latest Reason I Hate SQL Server
When is a copy of a database not a copy of a database? When it was made using SQL Server's "copy database" feature, that's when.Having run into this before I should have known better, but I needed to make a copy of a production database for testing purposes. Normally I'd take a backup and restore it to a different database, but I noticed SQL 2005 has a "copy database" function I hadn't seen before. So I figured I'd give it a try. Totally and utterly pointless. It looks like it copies the database until you start looking at all the fields using auto-increment IDs in your old database that magically aren't still auto-increment IDs in the "copy" of the database. Thanks for another worthless feature Microsoft. I only use SQL Server under duress anyway, but why can't they get even such basic things like "copy database" right? Inexcusable.