I am starting to use the DDT to update development/production databases but I am getting some errors which I don't have a clue how to fix them. Attached is the log file, and here are some of the errors:
• 9/24/2008 8:29:42 PM -> Deploying meta-data for database 'Progytech_CommonDatabase'
• 9/24/2008 8:29:42 PM -> Ensuring Filegroups exist on database 'Progytech_CommonDatabase'
X 9/24/2008 8:29:44 PM -> Creating datafile 'Progytech_CommonDatabase' failed.
X 9/24/2008 8:29:44 PM -> FailedOperationException
X 9/24/2008 8:29:44 PM -> Create failed for DataFile 'Progytech_CommonDatabase'.
X 9/24/2008 8:29:44 PM -> ExecutionFailureException
X 9/24/2008 8:29:44 PM -> An exception occurred while executing a Transact-SQL statement or batch.
X 9/24/2008 8:29:44 PM -> SqlException
X 9/24/2008 8:29:44 PM -> The file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\Progytech_CommonDatabase.mdf' cannot be overwritten. It is being used by database 'Progytech_CommonDatabase'.
X 9/24/2008 8:29:44 PM -> The logical file name "Progytech_CommonDatabase" is already in use. Choose a different name.
The database already exist on my ISP hosting server, so I guess I will get this error all the time, but should this be just a warning, because I am not really trying to create the database.
Here is another one which is really clueless to me:
X 9/24/2008 8:30:46 PM -> Altering table 'ServiceCalls' failed.
X 9/24/2008 8:30:46 PM -> FailedOperationException
X 9/24/2008 8:30:46 PM -> Alter failed for Table 'dbo.ServiceCalls'.
X 9/24/2008 8:30:46 PM -> ExecutionFailureException
X 9/24/2008 8:30:46 PM -> An exception occurred while executing a Transact-SQL statement or batch.
X 9/24/2008 8:30:46 PM -> SqlException
X 9/24/2008 8:30:46 PM -> Implicit conversion from data type datetime to bigint is not allowed. Use the CONVERT function to run this query.
I don't have any table which I made that kind of change to the fields, so I don't even know in this table which field is this error related to.
And the last one:
X 9/24/2008 8:32:14 PM -> Altering index 'PK_ServiceCalls' failed.
X 9/24/2008 8:32:14 PM -> FailedOperationException
X 9/24/2008 8:32:14 PM -> Alter failed for Index 'PK_ServiceCalls'.
X 9/24/2008 8:32:14 PM -> SmoException
X 9/24/2008 8:32:14 PM -> Modifying the IsClustered property of the Index object is not allowed. You must drop and recreate the object with the desired property.
I have not made any changes to this index at all.
I appreciate if somebody can clarify what am I doing wrong here. At this point I am not able to do modifications to some of my tables with the DDT.
Edhy Rijo