Data References In DBPro 2005

Discussion of database references within the DBPro.

Presented By: "Data Dude" Gert

• Can only represent 3 or 4 part names
• Reference can be to .DBPROJ or .DBMETA files
• Referenced schema's are loaded into the DisignDB
• Cannot resolve OPENQUERY(), OPENROWSET()
• Need to create a separate DBMETA file to reference 4 part names i.e. use linked servers.
• Will need to create a Post-Build event to copy the DBMETA file.

Summary: Many of these issues get resolved in DBPro 2008 that will be released 8 weeks after the release of SQL Server 2008 (Late June 2008)