http://skysigal.com/ 2026-06-21T11:30:02+00:00 http://skysigal.com/ http://skysigal.com/lib/tpl/bootstrap3/images/favicon.ico text/html 2023-11-04T03:39:50+00:00 Anonymous (anonymous@undisclosed.example.com) http://skysigal.com/it/ad/db_projects/howto/a_quick_intro?rev=1699069190&do=diff IT:AD:Data:Db/Projects:HowTo:A Quick Intro * (UP) howto index Process Create a new Db Project: After that, the usual reaction is …wow. It’s not a db…and what ever it is -- it’s big! What am I supposed to do?!? Relax. The reality is that SQL Server can manage very complex and powerful scenarios. text/html 2023-11-04T22:56:06+00:00 Anonymous (anonymous@undisclosed.example.com) http://skysigal.com/it/ad/db_projects/howto/create_a_project_from_an_existing_database?rev=1699138566&do=diff IT:AD:Data:Db:Projects:HowTo:Create a Project from an Existing Database * (UP) howto index Using Visual Studio 2012 In Solution Explorer. create a new Project, of type Sql Server Database Project Once created, in Solution Explorer, right click the Project node. text/html 2023-11-04T03:39:51+00:00 Anonymous (anonymous@undisclosed.example.com) http://skysigal.com/it/ad/db_projects/howto/deploying_dbschemas_from_the_commandline?rev=1699069191&do=diff IT:AD:Data:Db:Projects:HowTo:Deploying DbSchemas from the CommandLine * (UP) howto index Process //All on one line: vsdbcmd.exe /a:Deploy /cs:"Server=MYSQLSERVER;Integrated Security=true;Pooling=false" /dsp:Sql /dd+ /model:"Northwind.dbschema" /p:TargetDatabase="NewNorthwind" text/html 2023-11-04T22:56:07+00:00 Anonymous (anonymous@undisclosed.example.com) http://skysigal.com/it/ad/db_projects/howto/how_to_build_a_database_from_a_db_project?rev=1699138567&do=diff IT:AD:Data:Db:Projects:HowTo:How to build a Database from a Db Project * (UP) howto index Process In Solution Explorer, rick click the project, in order to bring up its Properties, and from there go to the build tab: WARNING: Notice the name of the db it is going to use…yeah, master…now you know why it gave you that whopping big warning up front (you certainly do NOT want to create tables in the master db). text/html 2023-11-04T03:39:52+00:00 Anonymous (anonymous@undisclosed.example.com) http://skysigal.com/it/ad/db_projects/howto/import_existing_databases?rev=1699069192&do=diff IT:AD:Data:Db:Projects:HowTo:Import Existing Databases * (UP) howto index Process Build a Db Project from a Database In the last post, I showed how to create a Db project and create SQL tables by hand, or at least start by hand, and finess them via the Schema View. text/html 2023-11-04T03:39:53+00:00 Anonymous (anonymous@undisclosed.example.com) http://skysigal.com/it/ad/db_projects/howto/keep_incremental_scripts_in_db_projects?rev=1699069193&do=diff IT:AD:Data:Db:Projects:HowTo:Keep incremental Scripts in Db Projects * (UP) howto index Finally had a second to check out something that drove me nuts on the GTM2 project: trying to keep previous, incremental, release files within a Visual Studio Database project. text/html 2023-11-04T03:39:53+00:00 Anonymous (anonymous@undisclosed.example.com) http://skysigal.com/it/ad/db_projects/howto/work_with_custom_variables?rev=1699069193&do=diff IT:AD:Data:Db:Projects:HowTo:Work with Custom Variables * (UP) howto index Process Using Custom Variables * Add the custom var (eg: “XXX”) to Database.sqlcmdvars * Refer to the variable later in scripts using the following sytax: $(XXX) Using built in variables