Stack Overflow
Stack Overflow

Questions tagged [sql-server-migration-assi]

SQL Server Migration Assistant is a tool to automate migration from number of various databases (Oracle, Access, Sybase, MySQL) to SQL Server platform.

SQL Server Migration Assistant is a tool to automate migration from number of various databases (Oracle, Access, Sybase, MySQL) to SQL Server platform.

Product home page: https://learn.microsoft.com/en-us/archive/blogs/ssma/

70 questions
0
votes
1 answer

SSMA unable to find specified provider

i've installed the full oracle client 12.2.0 and i'm trying to migrate some db from oracle to sql server with SSMA, but when i try to connect to oracle i get the folowing error: Unable to find specified provider. Compatible Oracle Data Access…
Serphentelm
  • 97
  • 9
0
votes
0 answers

SQL Server Migration Assistant Migration Stops Roughly After 10 minutes

I am migrating about 6 million records from a MySql 5.7 DB to SQL Server 2012 using Sql Server Migration Assistant v7.10. I have set the batch size to 1000 and migration time out to 30 minutes under SSMA project settings. Every time I run the…
N P
  • 201
  • 2
  • 8
0
votes
1 answer

Unable to run .sql file in SQL Server

I have a .sql dump file 20 gb and I am trying to run it on Mysql workbench using run script and after successful execution, using SSMA I'll migrate the data from Mysql workbench to SQL Server. I have migrated the data this way many times…
Wadhawan994
  • 49
  • 1
  • 8
0
votes
1 answer

Primary key -Primary Index in DB2 Vs Primary Key - Clustered index in SQL

Primary Index in DB2 Vs Clustered index in SQL. While migrating db2 to SQL i came to know that primary key in db2 is creating primary index not clustered index. I found primary index is different from clustered index in DB2 is it correct? In that…
PMP
  • 13
  • 1
0
votes
0 answers

Where to get documentation on and/or source of SQL Server Migration Assistant extended procedures?

I am running into login timeout errors while calling a procedure that uses xp_ora2ms_exec2_ex through JDBC. There's nothing in the SQL Server Profiler trace log. The DB was restored from a back-up. I'm wondering if some setting did not get…
Chry Cheng
  • 3,378
  • 5
  • 47
  • 79
0
votes
1 answer

How to Configure SSMA to convert DB2 INTEGER GENERATED BY DEFAULT AS IDENTITY

I am trying to use the Microsoft SQL Server Migration Assistant for DB2 v7.5 to migrate from DB2 v 11.1 to SQL Server 2014. The DB2 columns defined as INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY are getting converted to an Integer but not…
Rick Grant
  • 25
  • 5
0
votes
1 answer

SQL Server Migration Assistant - How to migrate access to SQL Server 2008 r2?

I'm trying to migrate our Access Database to a database on SQL Server 2008 R2. When I try to migrate it, I get an error message: You cannot connect to an older version (SQL Server 2008) of target SQL Server from a higher version SSMA project…
user1777929
  • 777
  • 1
  • 10
  • 28
0
votes
0 answers

SSMA ProtectedStorage.ssma file being used by another process

I am getting a repeated error trying to build the protected storage file for SSMA for Oracle version 6.0.1. I have made various attempts; nothing works! SSMA insists on writing to the roaming profile directory and the file it writes to is ALWAYS…
A L Morris
  • 11
  • 4
0
votes
1 answer

Best Approach to Migrate from MySQL to SQL server on Live Environment

My client has a large MySQL database with about 5GB of data (15M records). They want to migrate to SQL Server 2008 R2. What is the best Approach to Migrate from MySQL to SQL server on Live Environment?
Mohamed Mahyoub
  • 381
  • 2
  • 18
0
votes
1 answer

MySql to MSSQL migration

I have a database in mysql that I would like to migrate to mssql since I would like to use that database for an asp.net application.I have everything setup but anytime I try to convert the schema using SSMA(SQL Server Migration Assistant) I keep…
Thompson Franklin
  • 21
  • 3
0
votes
0 answers

Error while running SSMA script from Command Prompt

I wrote an XML script for SSMA and ran it from command prompt once and it worked perfectly. Then I decided to run it again and I have pop-up Windows that says "this app will not work on your computer". And in cmd I have "Access denied". I am the…
Rejmar
  • 9
  • 3
0
votes
1 answer

MySql to SQL Server - SQL Server Migration Assistance tool is showing few tables

We have a database which has 511 tables and 'SQL Server Migration Assistance for MySQL' is showing only 31 tables. I am using Version-6.0.0. It is not showing any error in 'output' window. Followed - https://www.youtube.com/watch?v=fXe4XL41jVE for…
sameermkulkarni
  • 41
  • 8
0
votes
1 answer

SSMA Oracle To SQL 2008 - Oracle db To blank SQL Database

I am new to Oracle, I am using the SSMA for Oracle tool to do the migration work. I am having some issues migrating data from an Oracle database to a blank SQL Database. I have followed the guides I have found online but still no luck. I cannot…
David B
  • 889
  • 2
  • 11
  • 29
0
votes
1 answer

Sql Server Migration Assistant (SSMA) For mySql Not Showing All Tables

I'm using SSMA version 6.0 for mySql. After I connect to the mySQL source database, it's only showing 45 of the 300+ tables in the schema I want to migrate. I don't see any properties or settings to limit the number of tables displayed. I did…
Andy
  • 1
  • 2
0
votes
1 answer

SSMA MySql to MsSql Null Value Error

The MySQL contains some tables with some zero date time : '0000-00-00 00:00:00'. When using SSMA to migrate the database into MsSql I am facing the error about cannot insert DbNull. This is understandable since neither MySql or MsSql has this field…
Patrick Desjardins
  • 136,852
  • 88
  • 292
  • 341
1 2 3
4
5