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
1
vote
1 answer

SQL Server Migration Assistant for Oracle truncating text at 100 chars

I've been trying unsuccessfully to migrate an oracle database to sql server 2005. The problem I'm seeing is with migration of Oracle "LONG" text to SQL varchar. I only get the first 100 characters of data from the field I'm checking in the Oracle…
adrianstovall
  • 31
  • 1
  • 5
0
votes
1 answer

SSMA for MySQL painfully slow when moving data to SQLAzure

I'm trying to move data over from MySQL to SQLAzure. The "Microsoft SQL Server Migration Assistant for MySQL v5.1" tool has been invaluable in getting the structure and most of the data translated/moved, but we have one table that's, well,…
Jeremy Logan
  • 47,151
  • 38
  • 123
  • 143
0
votes
0 answers

SSMA- Not migrating all the rows from oracle to sql via ssma

I migrated data from Oracle to SQL Server, the rows count in Oracle is around 11487 rows, but when SSMA finished the migration "message said 99.7% rows processed" It was not 100%. Also, there is no error Migrating data... Analyzing…
syncdm2012
  • 445
  • 2
  • 10
  • 22
0
votes
0 answers

Establishing connection with the source database failed. External component has thrown an exception

I'm using SSMA to migrate an ACCESS back-end to SQL Server. The Load and Link (usually) work well, but the Migrate portion refuses to work at random intervals, giving the error Establishing connection with the source database failed. External…
Jeff Lipton
  • 27
  • 7
0
votes
1 answer

SQL Server Migration Assistant DLL errors when trying to import any Access database

I'm currently trying to re-import an Access database into a SQL Server database (to update a demo with the most recent data). I've previously been able to run that import on this machine with SSMA, but since the last time I've imported, I've changed…
Katerine459
  • 465
  • 1
  • 3
  • 13
0
votes
1 answer

SSMA for Access -- No Objects Were Selected

Is there a version of this app that actually works??? I'm running version 9.1 and it's terrible. Sometimes it will migrate a table but not the data, and 90% of the time it will say "No objects were selected" even though all the tables have…
Jeff Lipton
  • 27
  • 7
0
votes
1 answer

SSMA for MySQL - values of float data type are different between MySQL and SQL Server

I am using SSMA for MySQL tool to migrate data from MySQL to SQL Server 2016. After migration data completed. The field value of float type from MySQL table is different from SQL Server field. In MySQL table, the value is 90177104, but in SQL Server…
Lei
  • 690
  • 1
  • 7
  • 13
0
votes
1 answer

SSMA for Oracle - Getting "No such host is known" when connecting to Azure SQL

I am trying to use SSMA to migrate data from Oracle to Azure SQL Server. I have everything installed, and successfully completed the steps for converting the Schema. All 145 tables have been successfully created in Azure SQL. I have successfully…
Dave
  • 1
  • 1
0
votes
2 answers

Unable to import Access DB to SQL Server Migration Assistant for Access (32 bit)

I am trying to migrate 32-bit MS Access DB to SQL Server using SQL Server Migration Assistant (SSMA) 32-bit in my 64-bit Windows machine. The addition of Access DB to the migration project always fails due to the following error. The error message…
Anson
  • 77
  • 2
  • 10
0
votes
1 answer

How to use SSMA (for Access to SQL Server) to migrate a table with different columns into a existing table?

I am currently using Microsoft SSMA to migrate tables from my old Access database into an existing SQL Server. The two databases have exactly the same tables but one of the tables has an extra column. SSMA is returning an error for one of the table…
John Yang
  • 547
  • 1
  • 8
  • 21
0
votes
0 answers

How can I configure SSMA to generate a filtered Unique index that ignores NULL?

My business logic relies on the Oracle feature that NULL is ignored in a Unique index. How can I configure SSMA to automatically generate a filtered Unique index that ignores NULL? Manually, in T-SQL, I could write CREATE UNIQUE INDEX indunique ON…
leo
  • 3,528
  • 3
  • 20
  • 19
0
votes
1 answer

how to select a bunch of objects automatically in ssma(SQL Server Migration Assistant)

I'm using ssma to migrate from oracle to SQL Server with about 1000 tables. And during the migration, about 100 tables went wrong (because of wrong type mapping) and I want to rerun only those tables. Are there any way to select them…
lidlesseye
  • 165
  • 9
0
votes
1 answer

Failure to connect to MySQL server from SQL Server Migration Assistant

I have SQL Server 2017 Developer installed. I want to use the SQL Server Migration Assistant for MySQL to migrate a MySQL database into SQL Server. But I can't get the migration assistant to connect to the MySQL server. First of all, using MySQL…
timothyjb
  • 35
  • 6
0
votes
0 answers

SQL Server Migration Assisstant (SSMA) doesn't see my schema in Oracle

I can connect to my 12c Oracle database using Oracle's Sql Developer and see my schema, but when I connect via SSMA I can't. I see a bunch of other schemas in SSMA, which I assume came with Oracle because I've only created two users on the box and…
J Brun
  • 1,246
  • 1
  • 12
  • 18
0
votes
1 answer

SSMA. Connect to Azure SQL Database Managed Instance to migrate from MySQL to Azure SQL

I just started using SSMA with the aim to migrate data from a MySQL server to my own Azure SQL database to work with the data in an Azure Logic app, which does not support MySQL very well. My idea is to run the an SSIS package to migrate data…
JohanLarsson
  • 475
  • 1
  • 8
  • 23
1 2
3
4 5