Activity overview
Latest activity by mattkarp
I got the same, "Error: Deployment to scripts folders is not supported by VersionedWork.", error when trying to update a scripts folder using "Direct from source control" as my Source. If you just get latest version of this folder to pull it down locally and then switch your source to "Scripts folder" this error went away and I was able to update my Target Scripts folder no problem. / comments
I got the same, "Error: Deployment to scripts folders is not supported by VersionedWork.", error when trying to update a scripts folder using "Direct from source control" as my Source. If you just...
We have 3 user defined table types that continuously show up as uncommitted over and over. We tried everything in terms of deleting it locally and getting it again form source, changing it locally and on the server but no matter what it continues to show up as 3 uncommitted objects. / comments
We have 3 user defined table types that continuously show up as uncommitted over and over. We tried everything in terms of deleting it locally and getting it again form source, changing it locally...
I get this warning as well. It happens on procs and on some .sql files we have in the "data" folder (putting data under source control) and don't understand what is causing it or how to resolve it. Please help. / comments
I get this warning as well. It happens on procs and on some .sql files we have in the "data" folder (putting data under source control) and don't understand what is causing it or how to resolve it...
We got the same, "The list of changes to commit was out of date", error when trying to commit a list of specific objects (table and views). What we discovered is that the list of objects which we were changing were all manually rolled back in TFS the day before. We then went to TFS directly and manually made the changes we were trying to commit via SQL Source Control. We then got latest via SQL Source and made a test comment in one of those objects which we manually checked in via TFS and checked in the test comment via SQL Source no problem. It essentially reset the "state" of those objects on TFS after they had been rolled back. / comments
We got the same, "The list of changes to commit was out of date", error when trying to commit a list of specific objects (table and views). What we discovered is that the list of objects which we...
David,
We have a situation where we have to send deployment scripts to existing customers where we cannot see their SQL Server. So we "hope" the schema looks like it did since we last deployed, but we have no way to guarantee that or control that (due to the nature of our clients and product). When we deploy, ideally we'd like to tear down all non-destructive objects (sps, views, functions, etc.) first. For destructive objects, tables, we have to deal with them differently because we have to preserve (and in some cases etl/migrate) the data and obviously this depends on the nature of the change to the table. So in the case of the non-destructive changes we'd like the "drop if exists" feature or an option to wholesale drop all existing objects specified then re-create in the correct dependency order. / comments
David,
We have a situation where we have to send deployment scripts to existing customers where we cannot see their SQL Server. So we "hope" the schema looks like it did since we last deployed, bu...
Matthew,
Are you saying that the /argfile switch can not be used to dynamically pass in parameters or setting to an existing project (.sqlgen file)? I understood this switch as being used for that purpose. For example, I would like to be able to dynamically pass in the bit flag for "Delete data from table before generation" in the Table generation settings or the Min value for the IDs generator in the Column generation settings. Can not the /argfile switch do this? If it cannot do this I need to know as I will need to design another approach.
Thank you,
Matt Karp / comments
Matthew,
Are you saying that the /argfile switch can not be used to dynamically pass in parameters or setting to an existing project (.sqlgen file)? I understood this switch as being used for that...