Hiya,
The biggest problem that you are likely to encounter if is your C++ code refers to system tables (such as sysobjects, sysindexes etc) as they all have different names between the two systems.
In terms of simple DDL and DML language, they are virtually identical, it is if you move towards DBA functions, or start using stored procedures that the problems can occur.
HTH
Tim