locked
Any local database used by DBPro? RRS feed

  • Question

  • I'm impressed by DBPro's ability to accurately determine object dependencies. Does it do this by keeping somesort of physical local database, or can it determine this by the script files it manages?
    Monday, February 1, 2010 7:35 PM

Answers

  • All versions of DBPro GDR and after do not require a local database. Previously to the GDR DBPro had a local instance that kept track of relationships and such. Now with the GDR we have an in memory model that tracks relationships, validates SQL and such.
    This posting is provided "AS IS" with no warranties, and confers no rights
    • Marked as answer by Randy Minder Monday, February 1, 2010 8:38 PM
    Monday, February 1, 2010 8:18 PM
  • If by "somesort of physical local database" you mean a Sql Server database, no.  That was the case in VS 2008 SP1 and prior where we would actually apply the scripts in the project to a temporary database on a local server instance.  But, in VS 2008 GDR and beyond, we moved to maintaining an underlying model of all the Sql Server objects and their relationships, rather than a live database, allowing for a completely offline development experience while also addressing some of the issues surrounding the version of Sql Server you might have been using as your local instance (IE: Sql Express doesn't allow full text indexing so you couldn't have them in a database project without installing Sql Dev+ locally)

    Andrew

    • Marked as answer by Randy Minder Monday, February 1, 2010 8:38 PM
    Monday, February 1, 2010 8:25 PM

All replies

  • All versions of DBPro GDR and after do not require a local database. Previously to the GDR DBPro had a local instance that kept track of relationships and such. Now with the GDR we have an in memory model that tracks relationships, validates SQL and such.
    This posting is provided "AS IS" with no warranties, and confers no rights
    • Marked as answer by Randy Minder Monday, February 1, 2010 8:38 PM
    Monday, February 1, 2010 8:18 PM
  • If by "somesort of physical local database" you mean a Sql Server database, no.  That was the case in VS 2008 SP1 and prior where we would actually apply the scripts in the project to a temporary database on a local server instance.  But, in VS 2008 GDR and beyond, we moved to maintaining an underlying model of all the Sql Server objects and their relationships, rather than a live database, allowing for a completely offline development experience while also addressing some of the issues surrounding the version of Sql Server you might have been using as your local instance (IE: Sql Express doesn't allow full text indexing so you couldn't have them in a database project without installing Sql Dev+ locally)

    Andrew

    • Marked as answer by Randy Minder Monday, February 1, 2010 8:38 PM
    Monday, February 1, 2010 8:25 PM