If you are planning to migrate other database products such as Oracle, Informix, MySQL, Sybase to SQL Server 2008, you should be reading the white papers available on this link. SQL Server 2008 Migration White Papers from Microsoft Download Center.
The documents will provide an overview of the non-SQL Server database Migration to SQL Server 2008 and how the SQL Server Migration Assistant (SSMA) will assist in conversion of those database objects to SQL Server database objects. What data types would be a good match on SQL Server.
Do you like this site? Like our FB page @ Facebook.com\LearnSQLWithBru so that, you know when there is a new blog post.