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
15
votes
4 answers

SSMA timestamp. What's it for, how is it used?

I rencently used the SQL Server Migration Assistant to import a database into SQL Server 2005. I noticed that a number of tables that were imported have been ammended with a new column called SSMA_timestamp. Can anyone tell me what this is for and…
Chris
  • 6,272
  • 9
  • 35
  • 57
14
votes
1 answer

Migrating from MySQL to SQL Server, issues with constraints

I created a web app that uses a MySQL database, but I have to migrate the database to Microsoft SQL Server 2008 R2 and I'm using the SQL Server Migration Assistant (SSMA). I'm getting errors in my report for some tables that use foreign keys. 1.…
jared_flack
  • 1,606
  • 2
  • 17
  • 24
9
votes
3 answers

SQL Server Migration Assistant (SSMA): ERROR [22018] [MySQL][ODBC 5.3(a) Driver][mysqld-5.1.51-community]

I am using SSMA for MySQL to migrate from MySQL to MSSQL and on several tables I am getting the 22018 error. After lots of mucking about I found that the error was being generated due to Russian characters being stored in these tables. For example:…
TechyGypo
  • 824
  • 1
  • 11
  • 27
6
votes
2 answers

Can I migrate tables without the triggers?

I'd like to migrate all tables, data, and indexes for a given Oracle schema (approx 2000 tables). I do want to migrate the triggers. I am looking for a way to do this without visiting each table and deselecting its triggers.
ctjrb
  • 61
  • 3
2
votes
6 answers

Migrate Access 2007 Database Application to SQL Server 2005 using SSMA - Issues

I have managed to get SQL Server 2005 Express up and running on my computer Ok in order to do some testing before trying this in the "Real World". I have a fairly large MS Access 2007 Database application I need to migrate to SQL Server retaining…
wisemonkey
  • 21
  • 1
  • 3
2
votes
0 answers

SSMA Oracle Error While Collecting Data

I am encountering an error "Error While Collecting Data" even with successful connection. How can I begin to troubleshoot this item? I am using oracle 10.2.0 What are some alternatives to using SSMA to migrate data from Oracle to SQL…
William Humphries
  • 541
  • 1
  • 10
  • 21
2
votes
0 answers

What is 'PrimaryKey' converted to by SQL Server Migration Assistant for Access/SQL Server

I've put an Access database into SQL Server Migration Assistant for Access and created a report (I haven't sent anything to the server). I'm getting the following info msg: "A2SS0029: Primary key name 'PrimaryKey' was changed during conversion." I'm…
wazz
  • 4,953
  • 5
  • 20
  • 34
2
votes
0 answers

MS-Access Add Additional Linked Tables

I have an MS-Access database that was converted to use SQL Tables using the "Microsoft SQL Server Migration Assistant 2008 for Access" (aka SSMA) and created linked tables (so the MS-Access interface still works but is linked to SQL…
ChrisHDog
  • 4,473
  • 8
  • 51
  • 77
2
votes
0 answers

SQL Server Migration Assistant (SSMA) for Access - Allow zero length issue

My Access 2013 database tables have columns of type "Long Text" that have the Required property set to 'No' and the 'Allow zero length' property set to 'Yes'. Why then the SSMA for Access is creating a check constraint on these columns as: Create…
nam
  • 21,967
  • 37
  • 158
  • 332
2
votes
1 answer

SQL Server Migration Assistant Identity Generation

I am using SSMA for migration from Oracle to SQL Server 2012. I want to migrate primary keys from Oracle as identity and primary key on SQL Server 2012. SSMA wants me to map every single primary key on source db with corresponding sequence but I…
bahadir
  • 709
  • 1
  • 11
  • 28
2
votes
3 answers

Converting plain text in SQL to hyperlink in Access

I've just started a new job my first since leaving University and as part of this my first task is to convert a wholly Access 2003 database to an Access front-end, SQL back-end. The Access database consists of a series of front end forms to add or…
manemawanna
  • 543
  • 5
  • 10
  • 29
1
vote
1 answer

SSMA - Rows counts are not matching after migration from Oracle to SQL Server

I migrated data from Oracle to SQL Server, the rows count in Oracle is around 820m rows, but when SSMA finished the migration "message said 100% successfully migrated" the rows count in SQL Server was around 745m rows. Is there a limit on the number…
Mohammed Alali
  • 7
  • 2
1
vote
1 answer

Can I overwrite the column type mapping for one single column

I am migrating an Oracle database to SQL Server. Through project settings I can change, for instance, type number to type bigint. This can also be done or overwritten at the table level. But I need to overwrite at the column level. For one column I…
JStefan
  • 149
  • 1
  • 2
  • 11
1
vote
2 answers

Is there a solution to decrease manual conversion time for migrating the Oracle database to SQL server

I am planning to migrate Oracle 11g to MS SQL Server 2016, hence I performed Pre-Migration assessment through SSMA. I received final conversion report on SSMA, But with Numerous Number of Errors.the report states that it will require 1263.6hours for…
Amit Singh
  • 11
  • 2
1
vote
1 answer

SQL Server 2008 Migration to 2019

I am trying to migrate my 2008 DB to 2019 using Data Migration Assistant. Unfortunately Ii have an Unqualified Join (Behavior Changes) in a Procedure and I can't figure out how to fix it. Here is the code: FROM Codebar INNER JOIN Codebar_IdentPag…
João Godinho
  • 45
  • 7
1
2 3 4 5