https://support.ispirer.com/ 2026-05-12T18:08:16+0000 https://support.ispirer.com/ https://support.ispirer.com/lib/tpl/bootstrap3/images/favicon.ico text/html 2025-06-03T16:05:10+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/sql-server/advanced-options?rev=1748966710&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial Microsoft SQL Server: Advanced Options At the “Target Options” page of SQLWays you can see the button “Advanced”, which opens the window with additional options for target database: ---------- FILEGROUPS Section Tables This option defines FILGROUP for tables. text/html 2026-04-17T12:55:02+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/sql-server/bin-directory?rev=1776430502&do=diff Ispirer Website Ispirer Toolkit Overview Free Trial Microsoft SQL Server: Bin Directory and Utilities to Perform Import SQLWays is able to execute the import process automatically. To perform it, user should provide target database credentials and Bin Directory. Bin Directory is a path to a folder containing command line utility of the target database, such as psql.exe, sqlcmd.exe, mysql.exe and others. With the help of this utility import process is performed. text/html 2023-10-25T15:20:28+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/sql-server/cns-name-violation?rev=1698247228&do=diff Ispirer Website Ispirer Capabilitie: Microsoft SQL Server Migration Free Trial Violation of PRIMARY KEY Constraint 'CNS_NAME'. Cannot Insert Duplicate Key in Object 'TABLE_NAME'. Symptoms During import to SQL Server the message with the following content may occur: “Error = [Microsoft][SQL Native Client][SQL Server]Violation of PRIMARY KEY constraint 'CNS_NAME'. Cannot insert duplicate key in object 'TABLE_NAME' text/html 2024-02-23T17:36:53+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/sql-server/data-source-name-not-found?rev=1708709813&do=diff Ispirer Website Ispirer Capabilities: Microsoft SQL Server Migration Free Trial Microsoft ODBC Driver for SQL Server: Data Source Name Not Found and No Default Driver Specified Symptoms During import into SQL Server, you may receive the following message: “Sqlcmd: Error: Microsoft ODBC Driver for SQL Server: Data source name not found and no default driver specified. text/html 2023-10-25T15:16:44+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/sql-server/full-primary-filegroup?rev=1698247004&do=diff Ispirer Website Ispirer Capabilities: Microsoft SQL Server Migration Free Trial PRIMARY Filegroup is Full - Insufficient Disk Space Symptoms Troubles with allocating space for an object in a database because the 'PRIMARY' filegroup is full. Please, create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup. text/html 2023-10-25T15:28:54+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/sql-server/invalid-descriptor-index?rev=1698247734&do=diff Ispirer Website Ispirer Capabilities: Microsoft SQL Server Migration Free Trial Invalid Descriptor Index Symptoms When making an import of data using the Microsoft BCP utility into a table in the SQL Server database, you may receive an error: SQLState = S1002, NativeError = 0 Error = [Microsoft][SQL Server Native Client 11.0] Invalid Descriptor Index text/html 2024-04-23T15:52:22+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/sql-server/odbc-driver-configuration-linux?rev=1713887542&do=diff Ispirer Website Ispirer Capabilities: Microsoft SQL Server Migration Free Trial Microsoft ODBC Driver 17 Configuration To configure the ODBC connection for the Microsoft ODBC driver 17 for SQL Server, you need to update the following files: odbcinst.ini: [ODBC Driver 17 for SQL Server] Description=Microsoft ODBC Driver 17 for SQL Server Driver=/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.10.so.5.1 UsageCount=1 text/html 2025-06-03T16:05:09+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/sql-server/odbc-driver-configuration?rev=1748966709&do=diff Ispirer Website Ispirer Capabilities: Microsoft SQL Server Migration Free Trial Microsoft SQL Server ODBC Driver Configuration for Windows Microsoft SQL Server 2012 Please follow the next steps to specify the ODBC connection: Open ODBC Data Source Administrator (64 bit), tab 'System DSN' Press on button 'Add' and select SQL Server Native Client driver: text/html 2024-04-23T16:14:03+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/sql-server/odbc-driver-installation-linux?rev=1713888843&do=diff Ispirer Website Ispirer Capabilities: Microsoft SQL Server Migration Free Trial Microsoft ODBC Driver 17 Installation If you don't have the SQL Server ODBC driver, please proceed with the installation and follow the instructions below. Download the appropriate ODBC driver for SQL Server from the Microsoft Corp. website. To install the Microsoft ODBC driver 17 depending on the Linux version, follow these steps: text/html 2026-03-20T12:00:08+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/sql-server/odbc-driver-installation?rev=1774008008&do=diff Ispirer Website Ispirer Capabilities: Microsoft SQL Server Migration Free Trial Microsoft SQL Server ODBC Driver Installation for Windows Check ODBC Data Source Please check whether you already have Microsoft SQL Server ODBC driver installed on your machine. You can check it on the ODBC Data Source Administrator on the Driver tab. text/html 2023-12-14T14:43:06+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/sql-server/source-user-privileges?rev=1702564986&do=diff Ispirer Website Ispirer Capabilities: Microsoft SQL Server Migration Free Trial Microsoft SQL Server: Setting Up Source User Privileges As for Microsoft SQL Server, SQLWays utility uses select statements to system tables and views to extract information about the source DDL for all the objects that need to be converted. So, we need to create a login with a default database where objects required for the migration are stored. Create a user for this login and assign the following privileges that… text/html 2024-09-06T13:12:31+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/sql-server/target-user-privileges?rev=1725628351&do=diff Ispirer Website Ispirer Capabilities: Microsoft SQL Server Migration Free Trial Microsoft SQL Server: Setting Up Target User Privileges To make an import into the Microsoft SQL Database you can utilize the existing user or create a new user and assign appropriate privileges to it. If you decide to create a new user in Microsoft SQL you can follow the statements below: text/html 2024-04-23T16:00:06+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/sql-server/tcp-provider-error?rev=1713888006&do=diff Ispirer Website Ispirer Capabilitie: Microsoft SQL Server Migration Free Trial TCP Provider: Error code 0x2746", SSL Provider: [error:1425F102:SSL routines:ssl_choose_client_version:unsupported protocol]. Symptoms The following problems may have occurred while connecting to an older version of Microsoft SQL Server: [bob@localhost ~]$ isql -v MSSQL10.0_VMDBSRV002_ETEST sa Ispirer_1999 [08001][unixODBC][Microsoft][ODBC Driver 17 for SQL Server]TCP Provider: Error code 0x2746 [08001][unixODBC… text/html 2023-10-25T15:36:58+0000 Anonymous (anonymous@undisclosed.example.com) https://support.ispirer.com/knowledge-base/database-migration/setup-and-troubleshooting/sql-server/trunc-function-conversion?rev=1698248218&do=diff Ispirer Website Ispirer Capabilities: Microsoft SQL Server Migration Free Trial TRUNC (date) Function Conversion from Oracle to Microsoft SQL Server The TRUNC (date) function returns date with the time portion of the day truncated to the unit specified by the format model fmt. Microsoft SQL Server does not support TRUNC function. Therefore, need to create an additional object, namely a function that simulates the operation of the TRUNC function.