How do you fix TSD02016 error in Database

Posted by Keith Sirmons on Stack Overflow See other posts from Stack Overflow or by Keith Sirmons
Published on 2010-06-14T16:38:45Z Indexed on 2010/06/14 16:42 UTC
Read the original article Hit count: 529

Filed under:

datadude

|

vsdbcmd

Howdy,

I have a database I am using the Visual Studio 2010 Database Project tool vsdbcmd.exe to create a schema from.

vsdbcmd /a:Import /dsp:Sql /model:"Database" /cs:"Server=SqlServer; Initial Catalog=DatabaseName; Integrated Security=SSPI;"

The tool is reporting an error:

Error TSD02016, Gen-259 (12,50) The column name is not valid. No table name was specified.

How would I go about pinpointing where this error is originating?

I have found one resource on the internet (http://social.msdn.microsoft.com....) that points to a possibility of a keyword used incorrectly, but the error messages are not the same.

What is Gen-259?

Thank you,
Keith

© Stack Overflow or respective owner

Related posts about datadude

Building a database installer with WiX, datadude and Visual Studio 2010

as seen on SQL Blog - Search for 'SQL Blog'
Today I have been using Windows Installer XML (WiX) to build an installer (.msi file) that would install a SQL Server database on a server of my choosing; the source code for that database lives in datadude (a tool which you may know by one of quite a few other names). The basis for this work was… >>> More
Workaround for datadude deployment bug - NullReferenceException

as seen on SQL Blog - Search for 'SQL Blog'
I have come across a bug in Visual Studio 2010 Database Projects (aka datadude aka DPro aka Visual Studio Database Development Tools aka Visual Studio Team Edition for Database Professionals aka Juneau aka SQL Server Data Tools) that other people may encounter so, for the purposes of googling, I'm… >>> More
Visual Studio Database Edition (DataDude) error numbers?

as seen on Stack Overflow - Search for 'Stack Overflow'
Is there a list somewhere of all the output message numbers from VSDB Depolyments (VsDbCmd.exe from Visual Studio Database Edition)? For example, TSD01268 = normal action successful TSD01236 = missing referenced file (fail) TSD01237 = missing script file (fail) TSD00566 = deployment script generated… >>> More
Is it possible to run Visual Studio Database Edition schema migrations from the command line?

as seen on Stack Overflow - Search for 'Stack Overflow'
Visual Studio 2008 Database Edition (Data Dude) has the ability to perform schema comparisons between databases and generate a script which migrates from one database to the other. Is it possible to perform this comparison and generate the migration script from the command line? If so, what are the… >>> More
How do you fix TSD02016 error in Database

as seen on Stack Overflow - Search for 'Stack Overflow'
Howdy, I have a database I am using the Visual Studio 2010 Database Project tool vsdbcmd.exe to create a schema from. vsdbcmd /a:Import /dsp:Sql /model:"Database" /cs:"Server=SqlServer; Initial Catalog=DatabaseName; Integrated Security=SSPI;" The tool is reporting an error: Error TSD02016… >>> More

Related posts about vsdbcmd

VSDBCMD deployment for additions to third party databases

as seen on Stack Overflow - Search for 'Stack Overflow'
We have some custom objects (stored procedures etc) in an SQL Server 2005 database belonging to an ERP system. The custom objects are in different schemas to the ERP objects. We're using Database Edition .dbproj projects and vsdbcmd deployment for all our custom application databases and would like… >>> More
VSDB to SSDT part 3 : command-line deployment with SqlPackage.exe, replacement for Vsdbcmd.exe

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
For our continuous integration needs, we use a powershell script to handle deployment. A simpler approach would be to have a deployment task embedded within the build process. See the solution provided here by Jakob Ehn (a most interesting read which also dives into the '”deploying from Visual Studio”… >>> More
Building a database installer with WiX, datadude and Visual Studio 2010

as seen on SQL Blog - Search for 'SQL Blog'
Today I have been using Windows Installer XML (WiX) to build an installer (.msi file) that would install a SQL Server database on a server of my choosing; the source code for that database lives in datadude (a tool which you may know by one of quite a few other names). The basis for this work was… >>> More
VSDBCMD returns "An unexpected failure occurred: Object reference not set to an instance of an objec

as seen on Stack Overflow - Search for 'Stack Overflow'
I have been succesfully using the command line database deployment tool VSDBCMD on my dev and test environments but the tool fails in our integration environmrnt. I am using the VS 2010 version of the tool. The servers have all of the prerequisites including: .net 4.0 sql server compact edition… >>> More
How do you fix TSD02016 error in Database

as seen on Stack Overflow - Search for 'Stack Overflow'
Howdy, I have a database I am using the Visual Studio 2010 Database Project tool vsdbcmd.exe to create a schema from. vsdbcmd /a:Import /dsp:Sql /model:"Database" /cs:"Server=SqlServer; Initial Catalog=DatabaseName; Integrated Security=SSPI;" The tool is reporting an error: Error TSD02016… >>> More