Database references in visual studio database project

Question

Hi,

I have imported the schema of a database that is currently on the server. I got so many unresolved references. So, I came to know that I have to add master database reference to the project. But, the project builds on the local system. And I have to take the master.dbschema of the server where actually the databse resides. So, how could I get the master.dbschema file from the server into local? If I could get it, where should I copy that file? Please help me regarding this.

 

Thanks

Answer 1

Hello,

Go to the database project in solution explorer, right click the project and choose 'Add Database Reference', in the prompted dialog, click the Browser button to find the master.dbschema on the server.

You can also refer to the following article: http://blogs.msdn.com/b/gertd/archive/2007/07/26/database-references.aspx

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Send us any feedback you have about the help from MSFT at [e-mail].

Answer 2

You might also find the following help topics relevant:

http://msdn.microsoft.com/en-us/library/dd193425.aspx

http://msdn.microsoft.com/en-us/library/dd193268.aspx

You could also use the VSBDCMD command-line tool to import the master.dbschema file and then check that file in to version control and reference it from your database project.  For information about using vsdbcmd to import a schema, see the following topic: http://msdn.microsoft.com/en-us/library/dd172135.aspx

 

 

---

Steven Powell (MSFT), Programming Writer