Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [ssma]

SQL Server Migration Assistant (SSMA) is a Microsoft tool for migrating MySQL, Oracle, MS Access and Sybase database objects and data to SQL Server.

20 questions
6
votes
2 answers

SSMA for Access - Migration Assistant Wizard fails at link tables

When using SQL Server Migration Assistant for Access with the Migration Wizard, all goes well converting an Access (2016) database to SQL Server Express (2017) until I get to the Link Tables step. Here the SQL Server connection dialogue appears: I…
Chris Purves
  • 191
  • 1
  • 7
5
votes
1 answer

Oracle to SQL Server migration

We have a very big Oracle db and want to archive whole of the oracle db to SQL Server. We are trying to weigh between SSIS v/s SSMA. Can the complete migration be achieved using SSMA? We do not have any schema/tables setup in sql. We need to migrate…
akshatha
  • 51
  • 1
5
votes
2 answers

Why SQL Server Migration Assistant keeps crashing on the 'Migrate Data' step?

I'm trying to migrate a MySQL database to SQL Server using the SQL Server Migration Assistant for MySQL. Converting the schema and synchronizing with SQL Server works fine. However, after clicking the Migrate Data button, SSMA crashes after a few…
Physikbuddha
  • 201
  • 2
  • 8
3
votes
1 answer

Table names when migrating MySQL to Microsoft SQL Server

I've just migrated a MySQL database over to Microsoft SQL Server using Microsoft SQL Server Migration Assistant for MySQL. For some reason the table names in SQL Server are not named the same way as in MySQL. If my table is named accounts in MySQL,…
Mads
  • 133
  • 1
  • 5
2
votes
1 answer

Missing Oracle Schema in SSMA Object Explorer

We are currently working on a project to move all of our disparate DBs (MySQL, Oracle, older versions of MS SQL) to SQL Server 2014. So far, pretty much everything has gone smoothly, however, there is one Oracle Database (10g 10.2.0.5), which we're…
Francois
  • 96
  • 4
1
vote
1 answer

Don't delete exist data with SSMA

I'm trying to use Microsoft's SQL Server Migration Assistant for Sybase 5.3 ('SSMA') to migrate multiple Sybase databases (that have the same schema) to a single MSSQL database. The first database migrated fine. But when I try to migrate data from…
Cocowalla
  • 191
  • 1
  • 11
1
vote
1 answer

Extra column when migrating Sybase databases to single SQL Server database

I'm trying to use Microsoft's SQL Server Migration Assistant for Sybase ('SSMA') to migrate multiple Sybase databases (that have the same schema) to a single SQL Server database. All of the tables in the new SQL Server database will have an extra…
Cocowalla
  • 191
  • 1
  • 11
1
vote
0 answers

Transaction log file - Migration SSMA

I'm attempting to migrate a relatively large Oracle DB to MSSQL using SSMA however due to disk space constraints, I had to stop the full migration last night when it was 50% of the way through. Upon investigating disk space usage, I've found that…
Mark Treanor
  • 11
  • 1
1
vote
0 answers

UPSIZING ACCESS 2010 to SQL Server 2014

When I run the upsizing module it goes through the motions but the report at the end says "table was skipped or export failed" for each of the tables. I can't find a solution for this. I can't figure out why this is?
Deana
  • 11
  • 1
  • 1
  • 5
1
vote
0 answers

Access linked to SQL with SSMA slow performance

I'm working on migrating a legacy application's DB (in Access 2003 format) to a SQL Server 2008 back-end (This will be upgraded later on). We are close to hitting the 2GB size limit in Access and performance is starting to degrade, even with up to…
wgallon
  • 11
  • 2
1
vote
0 answers

Mysql to MS SQL Migration and synchronization

Database migration from MySQL to MS SQL using SSMA tool is very nifty, however, I have one question around this. I have 2 MySQL Db's want to migrate to MS SQL, one sizes around 850 GB and another one around 450 GB, there are few tables have…
Indra
  • 36
  • 3
1
vote
0 answers

Oracle migration to SQL Server: SQL Server Equivalent to Oracle Global variables

I am working in a Oracle 11g database migration to SQL Server 2012, I did the migration using SSMA v5.3 and all works fine. However, I did re-write code in some objects like triggers and stored procedures because the SSMA did a standard migration.…
Data Slugger
  • 359
  • 1
  • 5
  • 12
0
votes
1 answer

MS Migration Assistant (SSMA) index renamed

I am using Microsoft SQL Server Migration Assistant v6 (aka SSMA) to update a database from Access to SQL Server. I am getting informational messages that say "A2SS0029: Index name 'Name' was changed during conversion.". As these are just index…
jmoreno
  • 1,097
  • 1
  • 7
  • 24
0
votes
1 answer

How to compress data in SQL Server? The data warehouse raw data is times bigger than the MySQL OLTP database for the same tables

For reporting purposes, we have a DWH (data warehouse) doing ETLs (extract-transform-load) to retrieve data from selected tables in a production OLTP (on-line transaction processing) database. The ETL extracts data with incremental manner, so it…
James
  • 149
  • 1
  • 6
0
votes
1 answer

SSMA error "Assembly 'SSMA4OracleSQLServerExtensions.NET' was not found in the SQL catalog"

everyone. I am attempting to do a simple test migration of a table with 4 columns and 1 row from Oracle to SQL using SSMA. Brand new VM with Windows Server 2019 Datacenter and brand new SQL 2019 Dev ver 15.0.4083.2. Installed SSMA for Oracle 8.18.0…
Alex M
  • 1
  • 2
1
2