Perry Whittle (10/8/2011)

---

dmoutray (10/7/2011)

---

The exact wording in the Microsoft document is "Each Server License for SQL Server 2008 R2 Enterprise permits you to run the software in up to four...

The second point (on doing a side-by-side upgrade) is from the SQL Server 2008 R2 Upgrade Technical Reference Guide, page 98.

"Licensing Note: if you install SQL Server 2008 R2...

sqlfriends (10/7/2011)

---

We cannot use trial version of Enterprise, is because once the test server is upgraded, we want to keep using it, the developer will use it as a testing...

Lynn Pettis (10/7/2011)

---

I don't think that means you can install the same licensed version on 4 physical machines. I think it means you can install the copy on virtual systems...

That is inded the way I read it. If you download the PDF Licensing Quick...

Hmmm. SQL Server doesn't support hosting the database files on Networked Attached Storage (NAS) as opposed to a SAN.

You can do it, but you might get some flaky errors....

Oh, yes, the licensing is quite confusing! :crazy:

I had to research this at work, too, for an upgrade to 2008 R2. In addition to the excellent suggestions about using...

Steve Jones - SSC Editor (10/7/2011)

---

That makes sense, sorry. Wasn't aware you were looking beyond tables.

Have you looked at Dependecy Tracker? If you have SQL Doc, you might have a...

Hey! You...

Grant Fritchey (10/7/2011)

---

This is a tough one. It's hard to know what you need to know in that situation. The main thing I'd focus on finding out is, which databases...

I really...

Red Gate does have some awesome tools. Currently I am using SQL Doc to reverse engineer the database. Best of all, I can publish the documentation in HTML...

Red Gate does have some awesome tools. Currently I am using SQL Doc to reverse engineer the database. Best of all, I can publish the documentation in HTML...

Well, I should add that I am not the primary database adminstrator. I just take care of the Business Intelligence data warehouses. The company itself is huge, and...

happycat59 (10/5/2011)

---

I have been using a product call "Enterprise Architect" for a few years - it is more than capable of meeting your needs. You can reverse engineer from...