Knowledge Base
Knowledge Base
  • User Guides
    • Ispirer Toolkit
    • Ispirer InsightWays
    • Ispirer Metrics tools
    • Ispirer Toolkit for Linux
    • Ispirer Toolkitのユーザーガイド(日本語版)
  • Database Migration
    • Ispirer Toolkit FAQ
    • Database: Setup and Troubleshooting
    • Tips and Tricks
  • Application Conversion
    • Ispirer Toolkit FAQ
    • Application: Setup and Troubleshooting
  • Log In

  1. You are here
  2. Home
  3. Ispirer Migration Knowledge Base
  4. Database Migration
  5. Database: Setup and Troubleshooting
  6. Microsoft SQL Server

  • Share via
    • Share via...
    • Twitter
    • LinkedIn
    • Facebook
    • Telegram
    • WhatsApp
    • Yammer
    • Reddit
  • Print


Ispirer Website Ispirer Toolkit Overview Free Trial

Microsoft SQL Server

Source


ODBC Connection Tune

Windows

  • ODBC Driver Installation for Windows
  • ODBC Driver Configuration for Windows


Linux

  • ODBC Driver Installation for Linux
  • ODBC Driver Configuration for Linux


Settings

  • Source User Privileges


Troubleshooting

  • TCP Provider: Error code 0x2746", SSL Provider: [error:1425F102:SSL routines:ssl_choose_client_version:unsupported protocol]



Target

Settings

  • Target User Privileges
  • Bin Directory and Utilities to Perform Import


Troubleshooting

  • PRIMARY Filegroup is Full - Insufficient Disk Space
  • Violation of PRIMARY KEY Constraint 'CNS_NAME'. Cannot Insert Duplicate Key in Object 'TABLE_NAME'
  • Microsoft ODBC Driver for SQL Server: Data Source Name Not Found and No Default Driver Specified
  • Invalid Descriptor Index
  • TRUNC (date) Function Conversion from Oracle to Microsoft SQL Server


Tool Specifics

  • Advanced Options
Knowledge Base

Knowledge Base


© 1999-2025 Ispirer Systems