gdavies2002 (7/21/2015)

---

Do you have a process of keeping the stubs in sync with the real DB projects? Or of publishing this change across both DBs?

Second question: Is your DB6 (say)...

We do use dacpacs, in fact they are a very important part of our development model. We develop in Visual Studio more than in SSMS, and we have several instances...

Conventions are somewhat subjective. I lean towards prefixes for dev, prod etc, and they work well.

Another thing that works very well is Server Groups within SSMS Registered Servers. I have...

Yes, looks like you can only suppress warnings,...

You can. Go into project properties, click on the "Build" tab, and where it says "Suppress Transact-SQL warnings:", put in...

Peter Schott (5/19/2015)

---

We were in a similar situation, but I was able to use SQLPackage to extract a dacpac from all existing databases, then used that extracted dacpac as the...

Thank you.

Robert Frasca (5/19/2015)

---

...I don't see how you solved your dependency issue which is why those references are important. For example, if I've removed two columns from Table 1 on DB2...

Somebody else...

Thanks.

Good article and good ideas, something to consider in future database designs. Thanks.

We are a Microsoft shop, and our developers live in Visual Studio. They also do a lot of DB development. This happens in Visual Studio SSDT. We tie it to...

Great topic, and discussion.

On a related note, wish Microsoft didn't require using GUIDs in In-Memory OLTP (Heckaton) tables...

You mentioned in comments that your product/service uses .NET web services, SSIS packages, and .xls files, all Microsoft products. I would think these integrate with SQL Server far better than...

Oh I love this quote, I'm going to steal it...