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
1
vote
3 answers

Convert Raw[16](Guid) in Oracle to uniqueidentifier in SQL Server by SSMA

I have dealt with the problem that I need to convert data from the Oracle database to the SQL Server database and there is no way except SQL Server Migration Assistant. In SSMA there is a TypeMapping which allows you to define types you want to…
Sasan
  • 644
  • 9
  • 29
1
vote
0 answers

SQL Server Migration Asistant (SSMA) doesn't recognise MySQL Columns

I am trying to migrate my MySQL DB to MsSQL.However, as you can see in the picture SQL Server Management Assistant cant recognise MySQL table columns. alternative link https://ibb.co/HXxKMBx
abdulkerim saltuk buğra
  • 101
  • 2
  • 2
1
vote
1 answer

MS Access: Substitutes for Upsizing Wizard (SSMA?)

Our team has been using Microsoft Access 2010 as a frontend for an SQL Server 2014, and are dependent on the Upsizing Wizard in Access to migrate tables from Access to SQL. For example, if there is an SQL database named papers, our team has an…
SindreKjr
  • 249
  • 2
  • 17
1
vote
4 answers

Most Efficient Way to Migrate Un-Normalized Data in an Access Database to a Normalized Form in a SQL Server Database

I've been doing some research on this topic for a while now and can't seem to find a similar instance to my issue. I will try and explain everything as best I can, as simply as I can. The problem is in the title; I am trying to migrate data from an…
LionOrion
  • 95
  • 1
  • 11
1
vote
2 answers

Migrating data from Oracle to SQL Server error: The value is Null

I have been getting a strange error since today when trying to migrate data from an Oracle DB Server to SQL Server 2017 Express using the latest SQL Server Migration Assistant for Oracle v7.5 The error affects certain tables only and read simply:…
DoomerDGR8
  • 4,840
  • 6
  • 43
  • 91
1
vote
1 answer

SSMA for Oracle "Connect to Oracle" error

i tried to connect to Oracle using Sql server migration assistant for oracle(SSMA for oracle). and specified parameters like this provider: Oracle Client Provider mode: standard mode and connection info(servername, port ...) but i got a error…
이미진
  • 11
  • 1
  • 3
1
vote
1 answer

SSMA "Required mdb-file $accessFileName is not loaded"

Hello Stackoverflow this is my first time here so please be easy on me. I am trying to use a SSMA (SQL Server Migration Assistant) to import a .accdb Microsoft access file type to a SQL server. However when I try to import the file I get an error…
Khila
  • 21
  • 9
1
vote
1 answer

SQL Server Full Migration

Now i need to move my database from one server to another server. I tested in my test system yes data and database are moving without trouble with backup - restore processes. But logins, db links etc.. ? Logins are coming under of…
user7139872
1
vote
1 answer

Migrate Oracle partitioned tables to SQL Server

I need to migrate about 700 Oracle partitioned tables (RANGE and LIST partitioning) to SQL Server. Turns out the SSMA (SQL Server Migration Assistant) does not handle Oracle partitioned tables (this is the official answer I got from Microsoft). Any…
user5372615
  • 35
  • 6
1
vote
0 answers

Getting Access 2016 (Data and Forms) into SQL Server

How do I export: Data Tables Query tables Forms from Access 2016 [the file type/extension of this version seems different than older versions - hence the difficulties] into SQL Server? [ preferably SQL Server 2016 (LocalDb)] When I try using…
Anthony Jackson
  • 11
  • 3
1
vote
1 answer

Error: The module depends on the missing object 'sysdb.ssma_oracle.db_check_init_package'

i migrated an entire oracle Database to SQL Server 2014 Database using SSMA. (SQL Server Migration assistant) The migration resulted in introduction of multiple Execution calls in my stored procedures (like below): The module…
Sana.91
  • 1,999
  • 4
  • 33
  • 52
1
vote
1 answer

SSMA console for Access: load only certain objects?

All, I am using the SSMA console to migrate certain objects from an Access DB to SQL Server. By default, the console LOADS all objects, but in fact I do not require all of them to be loaded, nor do they need to be converted and migrated. I was…
Kris Van den Bergh
  • 1,102
  • 4
  • 18
  • 31
1
vote
1 answer

SQL Server Migration Assistant issue

I'll start off by saying I'm in no way a PL/SQL or T-SQL expert and I only really know the basics but I have been asked to undergo a project to migrate about 1,700 PL/SQL procedure packages to T-SQL. Even if I knew PL/SQL the best way is using an…
Ben
  • 2,518
  • 4
  • 18
  • 31
1
vote
2 answers

Can SSMA for migrating Access databases to SQL Server 2005 be automated?

I need to migrate Access databases to SQL Server 2005. Since this needs to be done from within a setup so that a customers' installation is transparently migrated to SQL Server 2005, I wonder if it is possible to automate the SSMA toolkit from…
Mephisztoe
  • 3,276
  • 7
  • 34
  • 48
1
vote
1 answer

SSMA upgrade makes forms read-only?

I have a database that I have recently upgraded via SSMA to use SQL Server 2005. If I open a form that is bound to a table, it will display the data from the table; however, I am unable to edit the form and save the information. Simply typing in a…
gregcruce
  • 21
  • 4
1
2
3 4 5