Skip to main content
Share Your Experience: Take the 2024 Developer Survey

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.

Filter by
Sorted by
Tagged with
0 votes
1 answer
125 views

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 ...
James's user avatar
  • 149
3 votes
1 answer
923 views

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 ...
Mads's user avatar
  • 143
0 votes
1 answer
1k views

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 ...
Alex M's user avatar
  • 1
1 vote
0 answers
57 views

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 ...
Mark Treanor's user avatar
0 votes
1 answer
186 views

SSMA from oracle xe to sql server express PK violation

I'm using SSMA for the first time trying to migrate an Oracle XE schema to SQL Server Express. The majority of the tables get created and their data migrated just fine. There are a handful of tables ...
user441521's user avatar
1 vote
0 answers
36 views

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 ...
Deana's user avatar
  • 11
6 votes
2 answers
3k views

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. ...
Chris Purves's user avatar
0 votes
0 answers
573 views

Migrating Access 97 to Sql Server - Version Error

I have Sql Server Migration Assistant for Access v2.7, running on Windows Server 2016. On the same server I have 64bit version of Access 2016 and a 32bit version (I assume) of Access 97. I am able ...
Rob Bowman's user avatar
0 votes
2 answers
135 views

Microsoft access to Sql Server Data Migration [closed]

I need to migrate some old MS Access data to a SQL Server Database. Which tool is easier for a newbie to work with: SQL Server Import/Export or Migration assistant for access(SSMA)
SqlNovice's user avatar
  • 634
5 votes
1 answer
950 views

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 ...
akshatha's user avatar
1 vote
0 answers
317 views

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 ...
wgallon's user avatar
  • 11
0 votes
0 answers
975 views

Migrating database from Oracle to SQL Server [closed]

I need to migrate an Oracle database in which there is more than one table. I created new SSMA project and grant all privileges to my Oracle user, but still an error occurs: User does not have ...
user avatar
1 vote
0 answers
99 views

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 ...
Indra's user avatar
  • 36
5 votes
2 answers
6k views

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 ...
Physikbuddha's user avatar
2 votes
1 answer
636 views

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 ...
Francois's user avatar
1 vote
0 answers
271 views

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 ...
Data Slugger's user avatar
0 votes
1 answer
130 views

Access Data stored in SQL Server

I'm currently working on a project to convert our Access Apps to store the table data in SQL Server. Using SSMA to migrate the data results in the foreign keys and Look-ups work as expected in ...
Bryan Smith's user avatar
0 votes
1 answer
897 views

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 ...
jmoreno's user avatar
  • 1,065
1 vote
1 answer
2k views

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 ...
Cocowalla's user avatar
  • 191
1 vote
1 answer
192 views

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 ...
Cocowalla's user avatar
  • 191