Getting error when comparing backup with live database

Pascal_Girard · January 17, 2008 4:04PM

We need to compare a SQL Backup with my live database and I got this error."Unknow type for identity column other Parameter Name: Type"

If I compare the live database all work fine.

Pascal Girard
Developper
Multitel Inc

richardjm · January 18, 2008 3:52AM

Well spotted, I've fixed that error recently. What I believe it was caused by is when you have an identity column that is also a User Defined Data Type in a backup.

6.1 has this fix contained which should be out next week.

HTH

Pascal_Girard · January 18, 2008 8:14AM

Thank's, I waiting with enthousiasme the release.

Pascal

Robert C · January 24, 2008 6:22AM

Hi,

Just to let you know, 6.1 is now out. You can get this by going to Check for Updates on the Help menu.

Robert

Getting error when comparing backup with live database

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk