It would be nice if there were a user interface for VsDbCmd, huh? Well, I wrote one! (You’re welcome. Not that hard but there’s some hunting around and tweeking required to get it right. Once you get everything packaged up and copied over to your database machine, you have to remember the command-line syntax for doing your Import or Deploy. This step is a little confusing and tedious. You’ve got to package up a handful of files that VsDbCmd needs to run. It’s not going to drop the database and re-create from nothing unless you ask it to.)īut there’s a catch. (BTW, VsDbPro is smart enough to know how to deploy just the updates to the schema and preserve the data in the database. You have the option to either generate a SQL script that you can edit and run yourself or have VsDbCmd do the deployment for you. You can take the output from your DbPro database project on your developer workstation and use VsDbCmd to deploy your changes to the production database.You can then take this *.dbschema file and bring it back to your developer workstation and import it into your DbPro database project. This generates a *.dbschema file that contains all the details of the schema on your database including the source for all your tables, views, stored procedures, functions, permissions, etc. If you want to script out a production db schema for putting under source control you can do an “Import”.Once you’ve copied VsDbCmd to that machine, you have two very helpful features: VsDbCmd is a command-line tool that you can put on a USB thumb drive (or copy over the network) to a machine that does not have DbPro installed. What if you can’t connect from your developer workstation? Do you need to install DbPro on the production machine? This works great if you can connect to your production database from your developer workstation. When you need to deploy changes to production, you do a Database Comparison between your project and your production database and DbPro generates an update script for you that publishes your changes to the production database. If you’re using DbPro to manage your database schema during development, you’re doing it with Visual Studio installed on your desktop. There’s an underappreciated feature in Visual Studio 2008 Database Edition (DbPro) and that’s VsDbCmd.exe.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |