How can we help you today? How can we help you today?

Error in SQL Compare

Hi
during database comparison or during a snapshot creation I receive the following error :

unexpected char: 0xံF :shock:

Have you some suggestions to understand problem and to solve or bypass it .

Is important for me to do this compare because i'm sure that someone have damaged db where i receive error and i MUST rebuild it correctly from an old version that work fine.

Best Regards

Luca Dileo
Infoadv
0

Comments

3 comments

Sort by
  • Brian Donahue
    Hello Luca,

    This error sounds a lot like the Unicode SQL object name got scrambled somehow. Have you tried simply running DBCC CHECKDB first to try to find errors in the database? I'll be the first to admit that if you have a corrupted database, SQL Compare is going to have problems registering it.
    Brian Donahue
    0
  • Infoadv
    The first thing that i do is to run DBCC CHECKDB , but no errors was found in database.
    Only if i try to run DBCC CHECKTABLE , on table that i think is corrupted i receive invalid object.

    I don't known how i can do .
    Infoadv
    0
  • Brian Donahue
    Hello,

    Can you do a DBCC CHECKTABLE ... REPAIR_REBUILD (making sure, of course, to back up the database first!!)
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.