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
1
vote
0answers
11 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 ...
0
votes
0answers
65 views

Cannot find column “ssma_oracle” user-defined function or aggregate “ssma_oracle.db_get_next_sequence_value”. The name could also be ambiguous

We have migrated our database from Oracle to SQL Server, but when we have open any trigger we have this error in line this syntax ssma_oracle. db_get_next_sequence_value when I change with this syntax ...
0
votes
0answers
17 views

SSMA for Access - Migration Assistant Wizard remove password prompt after linking table

Hello used SSMA to create a linked table using SQL. Is there a way to remove this password prompt after opening the table in Access ? I tried adding the username and password in the connection string ...
0
votes
1answer
40 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
31 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
1k 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
369 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
112 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
786 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
215 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 ...
0
votes
0answers
792 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 ...
1
vote
0answers
86 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
4k 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 ...
2
votes
1answer
425 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
163 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 ...
0
votes
1answer
120 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
514 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
1k 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 ...
1
vote
1answer
120 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 ...