How to migrate databases of different SQL Server versions

Need to move databases from SQL Server 2000 to SQL Server 2005 – 2008 or vice versa?
dbForge Schema Comparer for SQL Server can successfully do any of these tasks. This tool generates a script in the same syntax that is used by the Target database. For example, if the Target database is on SQL Server 2000, User-Defined Data Type in the script will be written like EXEC sp_addtype ‘State’, ‘bit’, ‘NOT NULL’, whereas for SQL Server 2005-2008, it could be CREATE TYPE dbo.[State] FROM bit NOT NULL.
Different syntax:

MS SQL Schema Comparison

What schema comparison and synchronization tool do you need?

Anything able to compare and synchronize database schemas or packed with extended functionality? Want clear schema differences and safe database synchronization? Search for a stable SQL Server schema compare tool? 

dbForge Schema Compare for SQL Server delivers!

• Rich features set
• Best bang for your buck
• Remarkable customer support
• Standard and Professional editions
• 30-day fully functional trial!
• Free 1-year subscription for updates