Which is a better option for deploying databases VSDBCMD or SQLCMD when using a database project (VS 2010). Is there any major drawback other than the defaulted variables (databasename, datapath and logpath)?
VSDBCMD vs. SQLCMD
1.9k Views Asked by Vishal Gamji At
2
There are 2 best solutions below
3
Sub-Star
On
Your question is not very clear, so it isn't easy to give you a good answer, but according to your comment to Remus's answer, I assume you are trying to execute the .sql script that vsdbcmd.exe generated. If my assumption is correct, you need to use sqlcmd.exe to execute this script.
According to this thread on MSDN Forums, the VSDB team didn't want to duplicate functionality in vsdbcmd.exe that already exists in sqlcmd.exe.
Related Questions in SQL
- Can MVC.NET prevent SQL-injection at razor or controller level?
- SQL server not returning all rows
- When dealing with databases, does adding a different table when we can use a simple hash a good thing?
- Creating a parametrized field name for a SELECT clause
- Combine two rows based on common ID
- Column displays each count
- Slick query for one to optional one (zero or one) relationship
- Aggregate and count in PostgreSQL
- MAX and GROUP BY - SQL
- SQL statement for a tricky 2 table query
- How to create nested selects with sql?
- Pull and push data from and into sql databases using Excel VBA without pasting the data in Excel sheets
- Best Practice for adding columns to a Table in Oracle database
- SQL FIFO STACK using two tables
- SQL Query - Order by String (which contains number and chars)
Related Questions in DATABASE
- When dealing with databases, does adding a different table when we can use a simple hash a good thing?
- How to not load all database records in my TListbox in Firemonkey Delphi XE8
- microsoft odbc driver manager data source name not found and no default driver specified
- Cloud Connection with Java Window application
- Automatic background scan if user edit column?
- Jmeter JDBC Connection Configuration Parametrization of Database URL for accessing SQL Database
- How to grant privileges to current user
- MySQL: Insert a new row at a specific primary key, or alternately, bump all subsequent rows down?
- Inserting and returning autoidentity in SQLite3
- Architecture: Multiple Mongo databases+connections vs multiple collections with Express
- SQL - Adding a flag based on results within a query - best practice?
- Android database query not returning any results
- Developing a search and tag heavy website
- Oracle stored procedure wrapping compile error with inline comments
- Problems communicating with mysql in php
Related Questions in VISUAL-STUDIO-2010
- How would I be able to use a file in visual studio project on any computer?
- Which is the most advantageous strategy for creating a tweaked Visual Studio Project Template?
- ASP.NET textbox textchange with same text input
- windows phone emulator of visual studio 2010
- Reference to an object magically disaprears? STRANGE
- Implementing a custom header bar for chromiumembedded
- Aldebaran Nao robot simulator without a real robot
- windows form application to work with Oracle without installing Oracle client
- Referenced DLL is not found when running application from VS
- Records won't update in datagridview
- Writing to text file with StreamWriter. File used by another process
- Double templated function overload fails
- Make input to Web Service field optional not required
- How to update label from callback function in code behind?
- display .NET code error instead of HTTP 500
Related Questions in PROJECT
- Which projects in my solution are using a project reference for a certain project?
- How to improve Project structure in c# web application
- How make xamarin projects to open in visual studio?
- Run an existing python web application inside a virtalenv
- How to make PyCharm's Project Files window display class/method names
- Xcode 6 stopped cleaning project before building
- Access XML file in project bundle in Xcode 6.3.2
- VB6 read only project file
- syntax error in insert into command. The error could be while entering date value
- How to import a Makefile-based project filesystem to Eclipse based ARM DS-5 Workbench?
- How to append textbox with texts on the photo?
- How to position an object in 3d space according to a 2d screen position?
- What is the best approach to build a project for mobile and web version in GWT?
- Downloading my existing project in google cloud using Gcloud SDK
- Objective-c and Swift mixed project -Swift.h file report errors
Related Questions in DATADUDE
- VS 2010 Database unit testing with custom testcondition
- VSDBCMD vs. SQLCMD
- Is there a way to suppress SQL03006 error in VS2010 database project?
- Visual Studio For Database Professionals 2008
- Using nullable columns in a WHERE clause
- Is there a way in a visual studio database project to exclude certain object during deployment?
- Is there a table designer for VS2010 database project?
- Good datadude walkthrough
- Vs2010 Data Generation Plan fails with "Data generation failed because of the following exception: Column "xyz" does not allow DBNull.Value"
- Visual Studio Database Edition memory problems and auto recompile
- Circular references in Visual Studio Database Edition
- VS 2010 build database project receive SQL04151
- How to merge changes from a source-controlled VS2010 database project to local development DB
- Visual Studio DB GDR2 - Can I deploy to a File without SysAdmin Privleges?
- How do you fix TSD02016 error in Database
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
vsdbcmd is a diff tool: it can analyze the .dbschema, compare it with the target db and bring the target db up to the schema in the .dbschema file by selectively adding, dropping and altering existing objects. sqlcmd is only an execution tool, it takes a .sql script and blindly runs it. So it really apples to oranges, the two tools are quite different in purpose and capabilities.