pain

Nice article, I guess I will try to support those Royals since they're trying

that's great

🙂

Two things here.

1. You need code control.

2. You need a process for building the release.

#2 has lots of options.

For #1, I don't think it needs to be a dedicated QA...

Yep, second vote for you being correct. Let the backup complete *before* you start the release.

Is f: a local drive?

Check out sys.index_columns (http://msdn.microsoft.com/en-us/library/ms175105.aspx) and you can get the columns. If not, join with sys.columns and you should get the types.

You can't merge databases. You can merge the data in the tables, but there could be different logic for every table.

In terms of what you are doing with these...

No difference in how it will work. The 2008 instance will change the file format since that's the engine code, but the interpreter will handle code just like the 2005...

One other issue to consider is how do we decide what's on the test for new features? Who "becomes" the expert? The "who" can be a group, but how does...

I think PASS will need to back it at some point, but PASS is a volunteer organization, so it would be the same people here that would need it run...

I'll check with Red Gate tomorrow. In terms of sponsorship, I think we can do something. Not sure we want to host it, but maybe we'll pay for something like...

I think what would help is someone taking a stab at organizing this. There are a few areas that need work, for example: requirements, questions, testing process, review process, and...

I'll post an announcement or two and see what I can get going.