When using the SQL Server Migration Assistant for Oracle (OracleToSQL) to convert the tables in an Oracle database to tables in a SQL Server database; it automatically converts the Oracle NUMBER datatype to the SQL Server NUMERIC datatype. The Oracle tables used a column with the datatype and precision of NUMBER(10, 0) as the PRIMARY KEY. This column gets its […]
Find Your SQL Server Version
SQL Server usually comes in 4 versions: Standard Enterprise Express Developer To find the version of your SQL Server instance: Open SQL Server Configuration Manager Select SQL Server Services => right-click on the SQL Server instance service => select Properties In the Advanced tab, scroll to the Stock Keeping Unit Name to see the version