A Curious Case of NUMBER truncation

Oracle’s FLOAT  may truncate a float number beyond its binary digit limit. For example, execute the following in Oracle: DECLARE testvar FLOAT(5); BEGIN Testvar := 123.45; DBMS_OUTPUT.put_line(to_char(testvar)); END;   The statement will return 120 as the number 123.45 is rounded to 120, which has the max 4 binary digit.  This case above is documented here….

0

"End of Support" for Older SSMA v4.0 family of Products

[ Updated: 2/8/2012 Selina Jia] Microsoft would like to inform customers that support for SSMA v4.0 family of products (including SSMA Extension Packs) is going to end on October 30th 2011. Following are the products in SSMA v4.0 family for which this “End of Support” notice is applicable: 1.       SQL Server Migration Assistant 2005 for…

3

MySQL to SQL Server 2008 Migration Workshop Video

The following are workshop video series for migrating from MySQL to SQL Server 2008:  Getting Started with SSMA for MySQL This video covers step-by-step instructions on how to install and get up and running with the SSMA tool for MySQL. Note: The video was recorded with SSMA CTP1 version. The full release version of the…

0

How To Perform Incremental Data Migration Using SSMA

SSMA provides an ability for you to customize sql statement used during data migration. This feature can be used in the following scenarios: Split migration of a large table into multiple iterations Migrate data partially based on specific criteria (e.g. migrate data only for a selected department) To customize data migration sql statement: Modify project…

3