Database modeling and constraints

J

Joe Sarna

I am building a data warehouse and have created the model in Visio 2003 Enterprise arch. Within the model, I have relationships between various tables. However when I generate the database or update it, I do not want to pass over the constraints, since the data warehouse will maintain the integrity during the loading

Is there some way that I can turn off the creation of the constraints in the database while keeping them in the model

Joe
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

"Failed to Initialize the Modeling Engine" message 9
Temporarily disable relationships/constraints 1
import database diagram to database template? 1
Forward Engineer a Database 1
Can't access database modeling tools in Visio 2007 on XP SP2 3
Visio 2003 Pro: How to make a database diagram with individual row 0
Visio ; Data Modeling Diagram 4
Visio 2007 Database Model Bug 2

Top