Episode #125 of the Stack Overflow podcast is here. We talk Tilde Club and mechanical keyboards. Listen now

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
0answers
17 views

SSMA - Sysdb - Tables Missing

Based on my test, when I use SSMA for Oracle.8.4.ExtPack.exe to install, after the installation, I can see the table ssma_oracle.bcp_migration_packages and other tables are not in the sysdb database, ...
0
votes
0answers
27 views

SSMA Migration data failed from Oracle to Azure Database

I'm having an issue with the migration between an Oracle database and an Azure Database using SSMA v7.10.0. I can connect, convert the schema and synchronize with the Azure database with no problem. ...
0
votes
0answers
76 views

SSMA Selecting Specific Trigger

We are beginning work on migrating an Oracle Database to SQL Server and I have installed the appropriate SQL Server Migration Assistant. While I am not planning to use this to build the actual ...
0
votes
1answer
22 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 ...
1
vote
0answers
29 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 ...
4
votes
1answer
820 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. ...
0
votes
0answers
251 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 ...
0
votes
2answers
106 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)
5
votes
1answer
626 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 ...
1
vote
0answers
160 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 ...
1
vote
0answers
82 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 ...
4
votes
2answers
3k 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 ...
1
vote
1answer
409 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 ...
1
vote
0answers
147 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 ...
1
vote
1answer
104 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 ...
0
votes
1answer
429 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 ...
1
vote
1answer
946 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 ...
0
votes
1answer
115 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 ...