hermanthegerman Posted November 22, 2011 Report Share Posted November 22, 2011 I'm using the admintool in Plastic 4 to migrate from SQL CE to SQL Server... The migration failed with the following: Ungültiger Spaltenname 'irevisionnumber'.Ungültiger Spaltenname 'slast'. bei System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) bei System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) bei System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) bei System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) bei System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) bei System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) bei System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) bei System.Data.SqlClient.SqlCommand.ExecuteNonQuery() bei Codice.CM.Data.CmCommand.ExecuteNonQuery() bei admintool.DatabaseCopier.DoCopyTable(CmConnection srcConn, CmConnection dstConn, String tableName) bei admintool.DatabaseCopier.CopyTable(String tableName) bei admintool.DatabaseCopier.Start() It's a german system. It says "invalid column name" irevisionnumber, slast... The field irevisionnumber is missing on the server. Link to comment Share on other sites More sharing options...
psantosl Posted November 22, 2011 Report Share Posted November 22, 2011 Hi hermanthegerman and sorry for the inconvenience, The problem is caused by the beta database format. The thing is that your destination database definitely has less fields than the source one. We must get it fixed but in the meantime you can always drop the invalid fields from the source table. (Do a backup first). Let me know if it helps. Link to comment Share on other sites More sharing options...
mdutt Posted November 23, 2011 Report Share Posted November 23, 2011 ...you can always drop the invalid fields from the source table. (Do a backup first). How can we achieve this? I tried to open the .sdf file(s) in SQL Server Management Studio 2008 R2 and it says the file is an invalid SQL Server Compact file. Any suggestions? Link to comment Share on other sites More sharing options...
psantosl Posted November 23, 2011 Report Share Posted November 23, 2011 1- You can start up your plastic scm server 2- Grant yourself "advanced query" permission 3- use cm q "execquery drop XXXX" -> drop the right stuff This is pretty advanced usage, so be careful. We will try to fix the migration tool asap. Link to comment Share on other sites More sharing options...
mdutt Posted November 23, 2011 Report Share Posted November 23, 2011 OK. The colleague responsible for the migration now decided to wait for your fix. It's simply much safer than experimenting with dropping columns in an environment we hardly know... Link to comment Share on other sites More sharing options...
psantosl Posted November 23, 2011 Report Share Posted November 23, 2011 ok, ok, we're on it... Violeta... come and fix it!! XD Link to comment Share on other sites More sharing options...
mdutt Posted November 24, 2011 Report Share Posted November 24, 2011 Good thing that you have a team page on your company website. Now I know who's the one we can whip on XD Just kidding. Glad to hear that you're on it. Link to comment Share on other sites More sharing options...
psantosl Posted November 24, 2011 Report Share Posted November 24, 2011 XD Violeta is working on it *right now*... she's the one to blame Link to comment Share on other sites More sharing options...
mdutt Posted November 24, 2011 Report Share Posted November 24, 2011 Yes I saw her on the team page. That's what my posting was all about ;-) I'm impressed. You really mean ASAP when you say it :-) As I am a developer too I don't blame her. Making mistakes is human (and I make enough of 'em too...). All the more if a new release is coming up. Hope she didn't get in trouble because of us ^^ Link to comment Share on other sites More sharing options...
psantosl Posted November 24, 2011 Report Share Posted November 24, 2011 Absolutely not! I was joking!!! XD Our goal is to come up with the best scm in the world. We're probably the smallest team doing SCMs too (git's is bigger, svn too, perforce has like 200 people on the company...), but, plastic is by far the best... The downside? Some stability stuff like the one you found. But, nobody reacts faster either. You know... help us telling the world Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.