Skip to Main Content
Database Modeling with Microsoft® Visio for Enterprise Architects
book

Database Modeling with Microsoft® Visio for Enterprise Architects

by Terry Halpin, Ken Evans, Pat Hallock, Bill Maclean
September 2003
Intermediate to advanced content levelIntermediate to advanced
425 pages
16h 30m
English
Morgan Kaufmann
Content preview from Database Modeling with Microsoft® Visio for Enterprise Architects
columns, which will work fine. For date columns, VEA will insert the result
of a date function in the column.
b. If the target column is the subject of a unique index, the INSERT statement
that restores the backup data will fail. The only way around this is to make
the changes via script instead of ODBC connection. Remove the unique
index from the script and put the index on later, when you can get the
real data.
c. If the new column is mandatory and a foreign key, you need to do some
preparation prior to running the update. You have a few choices to handle this
situation.
i. Edit the script to remove the
NOT NULL qualification for the new column.
Also ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Mastering Data Modeling: A User-Driven Approach

Mastering Data Modeling: A User-Driven Approach

John Carlis
Architecting Data-Intensive SaaS Applications

Architecting Data-Intensive SaaS Applications

William Waddington, Kevin McGinley, Pui Kei Johnston Chu, Gjorgji Georgievski, Dinesh Kulkarni
Limitless Analytics with Azure Synapse

Limitless Analytics with Azure Synapse

Saranya Ravichander, Prashant Kumar Mishra

Publisher Resources

ISBN: 9781558609198