• 4/13/2009 1:50:00 PM -> Deploying meta-data for database 'CardTrackingSystem_Data' • 4/13/2009 1:50:00 PM -> Ensuring Filegroups exist on database 'CardTrackingSystem_Data' • 4/13/2009 1:50:01 PM -> Filegroup verification complete. • 4/13/2009 1:50:01 PM -> Ensuring Tables exist on database 'CardTrackingSystem_Data' • 4/13/2009 1:50:03 PM -> The table 'Inventory' is being prepared to be modified. • 4/13/2009 1:50:03 PM -> The relationship 'Inventory_2_Items' was successfully dropped. • 4/13/2009 1:50:04 PM -> The index 'ReferenceNo_idx' was successfully dropped. • 4/13/2009 1:50:04 PM -> The index 'Vendor_Carrier_idx' was successfully dropped. • 4/13/2009 1:50:04 PM -> The index 'Vendor_idx' was successfully dropped. X 4/13/2009 1:50:05 PM -> Altering table 'Inventory' failed. X 4/13/2009 1:50:05 PM -> FailedOperationException X 4/13/2009 1:50:05 PM -> Alter failed for Table 'dbo.Inventory'. X 4/13/2009 1:50:05 PM -> ExecutionFailureException X 4/13/2009 1:50:05 PM -> An exception occurred while executing a Transact-SQL statement or batch. X 4/13/2009 1:50:05 PM -> SqlException X 4/13/2009 1:50:05 PM -> Implicit conversion from data type datetime to int is not allowed. Use the CONVERT function to run this query. X 4/13/2009 1:50:05 PM -> X 4/13/2009 1:50:05 PM -> Source : Microsoft.SqlServer.Smo X 4/13/2009 1:50:05 PM -> X 4/13/2009 1:50:05 PM -> Stack Trace: X 4/13/2009 1:50:05 PM -> at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) X 4/13/2009 1:50:05 PM -> at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) X 4/13/2009 1:50:05 PM -> at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) X 4/13/2009 1:50:05 PM -> at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) X 4/13/2009 1:50:05 PM -> at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) X 4/13/2009 1:50:05 PM -> at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) X 4/13/2009 1:50:05 PM -> at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() X 4/13/2009 1:50:05 PM -> at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType) X 4/13/2009 1:50:05 PM -> at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType) X 4/13/2009 1:50:05 PM -> at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(StringCollection queries) X 4/13/2009 1:50:05 PM -> at Microsoft.SqlServer.Management.Smo.SqlSmoObject.ExecuteNonQuery(StringCollection queries, Boolean includeDbContext) X 4/13/2009 1:50:05 PM -> at Microsoft.SqlServer.Management.Smo.SqlSmoObject.AlterImplFinish(StringCollection alterQuery, ScriptingOptions so) X 4/13/2009 1:50:05 PM -> at Microsoft.SqlServer.Management.Smo.SqlSmoObject.AlterImplWorker() X 4/13/2009 1:50:05 PM -> at Microsoft.SqlServer.Management.Smo.SqlSmoObject.AlterImpl() X 4/13/2009 1:50:05 PM -> at Microsoft.SqlServer.Management.Smo.Table.Alter() X 4/13/2009 1:50:05 PM -> at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.AlterSmoObject(IAlterable ObjectToAlter, String ObjectName, DBEObjectType ObjectType) X 4/13/2009 1:50:05 PM -> • 4/13/2009 1:50:05 PM -> Table verification complete. • 4/13/2009 1:50:05 PM -> Dropping unneeded filegroups for 'CardTrackingSystem_Data' • 4/13/2009 1:50:05 PM -> Unneeded filegroups dropped on database 'CardTrackingSystem_Data' • 4/13/2009 1:50:05 PM -> Ensuring Indexes exist on database 'CardTrackingSystem_Data' • 4/13/2009 1:50:06 PM -> The index 'ReferenceNo_idx' was created successfully. • 4/13/2009 1:50:06 PM -> The index 'Vendor_Carrier_idx' was created successfully. • 4/13/2009 1:50:06 PM -> The index 'Vendor_idx' was created successfully. • 4/13/2009 1:50:06 PM -> Index verification complete. • 4/13/2009 1:50:06 PM -> Ensuring Foreign Keys exist on database 'CardTrackingSystem_Data' • 4/13/2009 1:50:06 PM -> The relationship 'Inventory_2_Items' was created successfully. • 4/13/2009 1:50:06 PM -> Foreign Key verification complete. • 4/13/2009 1:50:06 PM -> Ensuring Triggers exist on database 'CardTrackingSystem_Data' • 4/13/2009 1:50:06 PM -> Trigger verification complete. • 4/13/2009 1:50:06 PM -> Ensuring Assemblies exist on database 'CardTrackingSystem_Data' • 4/13/2009 1:50:06 PM -> Assembly verification complete. • 4/13/2009 1:50:06 PM -> Ensuring Views, Stored Procedures, and UDFs exist on database 'CardTrackingSystem_Data' • 4/13/2009 1:50:07 PM -> The view 'SFSUserPermissionInfo' was created successfully. • 4/13/2009 1:50:07 PM -> The view 'SFSUserRolePermissionInfo' was created successfully. • 4/13/2009 1:50:08 PM -> View, Stored Procedure, and UDF verification complete. • 4/13/2009 1:50:08 PM -> Ensuring Indexes exist on database 'CardTrackingSystem_Data' • 4/13/2009 1:50:08 PM -> Index verification complete. • 4/13/2009 1:50:08 PM -> Finished verifying databases on server. • 4/13/2009 1:50:08 PM -> The meta data conversion to the SQL Server has been completed.