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
- SQL schema for a fill-in-the-blank exercise
- Hibernate: JOIN inheritance question - why the need for two left joins
- What's supposed to be the problem in this query?
- Compare fields in two tables
- How to change woocomerce or full wordpress currency with value from USD to AUD
- Dynamic query creation with Array like implementation
- SQL query to get student enrolled in this month in a course - Moodle
- SQL LAG() function returning 0 for every row despite available previous rows
- Convert C# DateTime.Ticks to Bigquery DateTime Format
- Use row values from another table to select them as columns and establish relations between them (pivot table)
- SQL: Generate combination table based on source and destination column from same table
- how to use system's environnement variables in sql script
- PHP fetchAll on JOIN
- Multitable joining in Sql
- How to display name starting from 'z' by using BETWEEN cmd only?
Related Questions in DATABASE
- How to add the dynamic new rows from my registration form in my database?
- How to store a date/time in sqlite (or something similar to a date)
- Problem with add new attribute in table with BOTO3 on python
- When an E-R attribute should be perceived as a relationship attribute or as an entity set attribute?
- SQLAlchemy: efficient relationship loading in 3-way many-to-many relationship
- Cannot connect to Postgres Database when running Quarkus Tests with Gitlab ci
- Local or remote database with react-native?
- I want to edit a specific row in database
- How to enter data in mongodb array at specific position such that if there is only 2 data in array and I want to insert at 5, then rest data is null
- Open Web Library
- database login.py and register.py error showing 404 file not found and doesn't work
- SQL71561: SqlComputedColumn: When column selected
- Liquibase as SaaS To Configure Multiple Database as Dynamic
- Updated max input vars but table still shows error
- Spring does not map set of roles
Related Questions in VISUAL-STUDIO-2010
- how do i stop system stack overflow in visual basic?
- How to remove shortcut/alias to a .cpp and .h file from another project in Visual Studio 2019?
- VS2010 Macro/Environment issue causing a HResult: 0x80070057 (E_INVALIDARG) exception
- DevOps 2022 Server not connecting on VS 2012 and VS 2010
- How can i make a prefab instantiate another prefab?
- VS2010 Installer Project Custom Action to run an EXE is failing
- I commit from my Microsoft Visual Studio, however, I am now seeing that i now have two versions of two files
- Is there a way to make AfxMessageBox() take focus from another program?
- in visual studio 2017 was use a model i made but i get the error Read_POLS_Chunk(): Error reading a polygon not 1-3 vertices
- C++ vector subscript out of range : Monotone Interpolation
- c language, When decimal digit of %g in printf equal to 0.5, and length is more than 6, it is not upper ceil, why?
- IloEnv env ; don't work in the dbug and it can access to it
- Create a kml for a Google Earth tree view item through vb-net
- Error in RDLC REPORT in vs2010- An error occurred during local report processing, Object reference not set to an object instance
- This AVD's configuration is missing a kernel file! Visual Studio Code
Related Questions in PROJECT
- Need advice for a project
- Plugin with id 'com.android.application' not found in Github Winlator Project
- Import error in tensorflow in jupyter notebook ( import tensorflow_io as tfio )
- How to create a multiple line typing animation with only CSS?
- Using Eclipse Maven project, import new version of a class from a jar file created from another Maven project
- Eclipse: "package...does not exist" when building a Maven package that references a class in another project
- Azure DevOps team and work item structure for larger projects which affects multiple systems
- Is there a way to add bulk of files to a Visual Studio C++ project?
- I'm in Playwright, how do I run specific test cases by tag in (CI) execution
- Implementing JWT Authentication in a Node.js Application
- Copying field from MSproject Gant view to Resource Sheet view gettign error 91
- How to pass through a VBA Project Password and remove the VBA Project Password via vb code
- how to analyse a project in sonarcloud
- How can I hide the "BRAND NEW" project in my portfolio?
- How to automate report writing by extracting relevant text?
Related Questions in DATADUDE
- Frequent Setup and Tear Down of SQL Server Replication
- Does wrapping nullable columns in ISNULL cause table scans?
- How to merge changes from a source-controlled VS2010 database project to local development DB
- VS2010 Partial Database Projects, will they help in my scenario?
- Schema Compare and Update comments out unused code
- Scripting Server Objects in a Visual Studio 2010 Database Project
- When deploying a database project with vsdbcmd I get the error "Vardecimal support is enabled for the database but disabled for the project"
- Vs2010 Data Generation Plan fails with "Data generation failed because of the following exception: Column "xyz" does not allow DBNull.Value"
- vsdbcmd data loss may occur, but where?
- RedGate SQL tools v Microsoft Visual Studio Team System Database Edition (Data Dude)
- Good datadude walkthrough
- Is there a way to suppress SQL03006 error in VS2010 database project?
- VSDBCMD vs. SQLCMD
- VS 2010 Database unit testing with custom testcondition
- VS2010 DB Project - moving stored proc to another schema
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.