Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 I get this error when I deploy database

Author  Topic 

mavericky
Posting Yak Master

117 Posts

Posted - 2011-10-31 : 12:32:33
Hi ,

I get this error on database depoly-
Error TSD00560: An incompatible collation combination has been detected between the source and target. Deploying a case insensitive model to a case sensitive target can produce unintended changes and possible data loss. Consider using a case sensitive source model collation.

Database Settings:
in project: English (United States) (1033) - CI
in database: Latin1_General_Bin
This setting works fine for my other databases though.
Can someone help me?
Thanks,
Mavericky

nigelrivett
Master Smack Fu Yak Hacker

3385 Posts

Posted - 2011-10-31 : 12:53:58
How are you deploying?

==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page
   

- Advertisement -