| Invert |
James Sturdy
03/16/2010 11:09
ALTER TABLE fails because table must have at least one data column...
When updating a database sitting on SQL Server 2008, from a database sitting on SQL Server 2005, I'm receiving an error message of the following:
ALTER TABLE DROP COLUMN failed because '<ColumnName>' is the only data column in table '<TableName>'. A table must have at least one data column.
When updating the same database sitting on SQL Server 2005, it all works as expected.
I've checked in SQL Server 2008 Management Studio for any options that I might be able to turn off to allow this to continue, but there are none that are related.
Just to clarify, this happens for every table. The tables do all have more than one column, however when it is removing them it gets to the last column and throws this error. If I remove the table that's causing the error, it just encounters the same error on the next table it tries to update.
Currently the only solution is to delete all of the tables in the database and then perform the Sync. This isn't ideal of course, as all the data would be lost, not to mention it defeats the point of the Sync really, as I could just create a blank database and the relevant scripts in the management studio and use them...
Is there any way to get this working?
|
Vlad Nekrasov
03/18/2010 06:12
ALTER TABLE fails because table must have at least one data column...
Hello,
I’m sorry, but the current product version is not fully compatible with MS SQL Server 2005 and 2008. For now we recommend you to use our product with one version of MS SQL Server.
Best regards,
Vlad Nekrasov
Perpetuum Software Team
|
Peter Hallengreen
03/23/2010 08:51
ALTER TABLE fails because table must have at least one data column...
| Quote: | Hello,
I’m sorry, but the current product version is not fully compatible with MS SQL Server 2005 and 2008. For now we recommend you to use our product with one version of MS SQL Server.
Best regards,
Vlad Nekrasov
Perpetuum Software Team |
Hi there,
First post and starting to evaluate the API.
Will this mean that now that we have clients on both MSSQL 2005 and MSSQL 2008, that we have to have two sync-sources ?
|
Vlad Nekrasov
03/25/2010 08:33
ALTER TABLE fails because table must have at least one data column...
Hello,
In current version a synchronization between MSSQL 2005 and MSSQL 2008 is possible if MSSQL 2005 is a Source Database (Database, DBsnapshot or DataContext of LinqToSQL) and MSSQL 2008 is a Target Database.
An error occurs if MSSQL 2008 is a Source Database and MSSQL 2005 is a Target Database.
Best regards,
Vlad Nekrasov
Perpetuum Software Team
|
Eric Cossettini
04/15/2010 00:50
ALTER TABLE fails because table must have at least one data column...
I have a 2005 source and 2008 destination and get this error.
Please advise when a solution might be available.
|
Vlad Nekrasov
04/15/2010 06:42
ALTER TABLE fails because table must have at least one data column...
Hello,
Please give your version of MS SQL Server 2008
Best regards,
Vlad Nekrasov
Perpetuum Software Team
|