SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
507 questions
2 answers
Adding SQL2014 Sharepoint DB to Sharepoint Portal 2013
Hi all, I am having a problem while adding SQL 2014 database to Sharepoint portal 2013. Scenario is previously we are using SQL 2008 Server with Sharepoint Portal 2013, We have now upgraded SQL Server to 2014. I have multiple Sharepoint Site databases…
asked 2020-12-25T18:36:48.09+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(307.2, 53%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESA%3C/text%3E%3C/svg%3E)
Sarfraz Aslam
166
Reputation points
commented 2021-01-04T06:23:08.78+00:00
Sarfraz Aslam
166
Reputation points
2 answers
Using Azure Dms is it possible to migarte sql databse of 5Tb to azure Vm with ? What are limitations and known issues while migrating huge dbs to azure vm with azure DMS tool?
We are planning to migrate 5 Tb of sql db to azure Vm with help of azure DMS ? does dms support sql db with huge sizes like this? Azure Dms does supports only offline migration for azure vm . what is avg time taken by for migrating sql db with…
asked 2020-12-18T09:51:35.783+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(188.79999999999998, 97%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVS%3C/text%3E%3C/svg%3E)
Vishnuvardhan Settipally
1
Reputation point
commented 2020-12-30T06:09:38.497+00:00
Vishnuvardhan Settipally
1
Reputation point
4 answers
Questions about creating active active clustering server 2012 R2
Aloha All, Been a long time since I've posted in a forum, forgive my lack of etiquette if any. Here's my scenario: I have a 2012 R2 domain with two servers who's primary functions are, web-app<-(DC) and SQL database<-(member server). We are…
asked 2020-12-11T23:47:12.28+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 99%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Sperle, Raymond (CAI - Manheim Hawaii)
1
Reputation point
answered 2020-12-19T00:19:44.547+00:00
Alex Bykovskyi
1,841
Reputation points
1 answer
One of the answers was accepted by the question author.
SSMA for Sybase - Server side data migration failed
I am doing sybase ASE to SQL server 2017 data migration. I have converted schema and did synchronize. Now tables are created in SQL server. Then I have to load data from sybase for that I have changed the project settings to use server side data…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(230.39999999999998, 97%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
7 answers
Migrating Sql server DB to another Server
Hello, I am planning to migrate the some Sql server databases to another Server on same domains but some of the databases have cross connection dependency. I mean some of the database either View or Stored procedure I found that it's calling to…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 17%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
1 answer
SSMA Oracle Migration to SQL Server - Automation
Hi We're looking at using SSMA to do a regular build of a SQL Server database from an Oracle database for a client datawarehouse team. I've been able to set this up using SSMA and run it using the application. I'm now looking at automating this using…
asked 2020-11-18T21:54:26.577+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(22.400000000000002, 68%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERS%3C/text%3E%3C/svg%3E)
Rob Stevens
1
Reputation point
answered 2020-12-04T06:04:44.007+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(230.39999999999998, 65%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAI%3C/text%3E%3C/svg%3E)
Alexander Ivanov
491
Reputation points
1 answer
One of the answers was accepted by the question author.
Does SQL Server Migration Assistant (SSMA) support Sybase SQL Anywhere 16 (Sybase ASA) migration to SQL Server.
Hi, I want to migrate Sybase SQL Anywhere 16 Database to SQL Server in my current project using SSMA . I am planning to use SQL Server Migration Assistance for this. But i can see in the Microsoft documentation that it supports for Sybase ASE but not…
asked 2020-10-30T07:11:58.41+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(35.2, 83%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAH%3C/text%3E%3C/svg%3E)
Ather Hussain
26
Reputation points
accepted 2020-11-30T07:17:33.27+00:00
Ather Hussain
26
Reputation points
4 answers
SQL 2014 Migration
Hi, I am reposting as the previous thread was closed. Please clarify my list below and recommend changes Realtime Refreshes with Parallel Jobs, Equivelant to MPP (PDW, Multiple Physical Servers with VM) • Infrastructure 2 VM (Storage &…
asked 2020-11-21T21:06:48.203+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(281.6, 39%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIC%3C/text%3E%3C/svg%3E)
Ismail Cassiem
226
Reputation points
answered 2020-11-27T12:12:52.877+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(300.8, 6%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EII%3C/text%3E%3C/svg%3E)
IC IC
236
Reputation points
12 answers
One of the answers was accepted by the question author.
SQL14 Migration, Infrastructure, Software Options
Good day, i need help please! I have tried reaching out to vendors but they more keen on having their solutions within the businnes as i require infrastructure, software specifications for the next 5-7 years with improvong the analytics & speed &…
1 answer
High availability group
Hi Expert, Can you help me in explaining about High availability group in sql server database and how to find it and how it will affect to mirroring in database from sql server 2008 to sql server 2016. Any query that we can find high availability…
asked 2020-11-15T00:20:20.407+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 55.00000000000001%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
Shri
21
Reputation points
commented 2020-11-20T09:42:21.107+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 46%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
AmeliaGu-MSFT
13,966
Reputation points Microsoft Vendor
1 answer
ssmafororacleconsole - SYS_IOT_OVER warnings
Hello, folks. About a year ago we started a project for a home made ETL to migrate some Oracle into SQL Server databases. In this project we're using SSMA exclusively to perform the data copy since the database models have some specificities not…
asked 2020-11-05T14:50:15.497+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(217.60000000000002, 43%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELM%3C/text%3E%3C/svg%3E)
Leandro Martins de Lima
1
Reputation point
answered 2020-11-20T00:36:12.773+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 56.00000000000001%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EXY%3C/text%3E%3C/svg%3E)
Xiao Yu
81
Reputation points Microsoft Employee
1 answer
Migrating multiple SQL server databases to Azure
Hi All We are looking for a solution to migrate multiple databases from a local SQL server to Azure. Ideally we would like to migrate multiple databases at a time due to the number of databases involved. I have done a test migration using Data…
asked 2020-11-19T10:06:47.983+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 52%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
Hugo McDonald
1
Reputation point
answered 2020-11-19T20:15:21.74+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(41.6, 41%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3E2%3C/text%3E%3C/svg%3E)
21986829
481
Reputation points
2 answers
Oralle to SQL conversion "start with" and "connect by prior "
Hi I am currently converting Oracle database to SQL Server 2016 Sp2 database and hitting some issue with coversion on following key works "start with " "connect by prior " ++++++++++++++++++++++++++++++++++++ with equip_parent…
asked 2020-11-17T05:41:02.633+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(208, 42%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Ashwan
521
Reputation points
answered 2020-11-18T09:09:57.607+00:00
CathyJi-MSFT
21,116
Reputation points Microsoft Vendor
0 answers
All dependencies and entities on sql server
Hi Expert, I am trying to find the dependent jobs, linkked server, users,ssis packages,source target mapping,db stats,sql files, impacted files, impacted codes, ssis package variable, ssis config tables, ssis packages, sql agent schedule on sql server…
asked 2020-11-15T20:20:21.55+00:00
Shri
21
Reputation points
commented 2020-11-16T08:56:14.01+00:00
CathyJi-MSFT
21,116
Reputation points Microsoft Vendor
10 answers
One of the answers was accepted by the question author.
SQL SERVER 2012 TO 2017 data mirror
Hi Expert, How will data mirror SQL Server Application from one server to another . How to check which server machine depended on this server and how will move it from sql server 2012 to sql server 2017 with all dependency, jobs, agents etc together …
1 answer
dependency jobs on sql server
Hi Expert, How to find the dependent jobs in sql server database, I found below method .any other methods to be check to check any other server or SQL database from any other Server machine has any dependency or any ssis or any other jobs dependency…
asked 2020-11-14T23:10:26.873+00:00
Shri
21
Reputation points
answered 2020-11-15T13:24:30.403+00:00
Erland Sommarskog
105.8K
Reputation points MVP
3 answers
From SQL 2008 to SQL 2019
My organization has migrate the instance I use from SQL 2008 to SQL 2019. Since then a query I run to get the users that are using the different database in the instance just work for one of them SELECT sdes.nt_user_name as Utilizador …
asked 2020-10-30T18:13:23.3+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 23%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJO%3C/text%3E%3C/svg%3E)
João Simplicio Rodrigues
1
Reputation point
answered 2020-11-02T06:48:40.213+00:00
CathyJi-MSFT
21,116
Reputation points Microsoft Vendor
1 answer
need Microsoft.SQLSERVER.sqlclrprovider.dll version 14.0.0.0 to be in assembly
I am having missing DLL error while running an EXE. I am looking for Microsoft.SQLSERVER.sqlclrprovider.dll version 14.0.0.0 to be in my assembly. While searching I found two msi are suggested to install for it. 'SQLSysClrTypes.msi' and…
asked 2020-10-26T16:08:13.023+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(73.60000000000001, 42%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
Seuli Das Majumder
101
Reputation points
commented 2020-10-28T13:17:37.487+00:00
Seuli Das Majumder
101
Reputation points
2 answers
SQL Migration Office 365: DAO missing
Hello What I want to do: Migrate a acessdata.accdb to SQL Database 2019 with SSMA 8.14. OS, Office and SSMA are 64 bit. The error I get when loading the database: Retrieving the COM class factory for component with CLSID…
asked 2020-09-30T10:08:06.55+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(153.6, 67%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMB%3C/text%3E%3C/svg%3E)
Monika Badertscher
1
Reputation point
answered 2020-10-20T02:26:54.57+00:00
Alexander Ivanov
491
Reputation points
6 answers
Problem importing into SQL Server 2012 from AS400
Hi, We've quitted using the AS400 for a SQL Server based software. We'd like to migrate the databases from it into a server having OS Windows Server 2012 Standard and SQL Server 2012. We're talking about around 20 databases with hundreds of tables. …
asked 2020-09-25T08:35:17.457+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(22.400000000000002, 22%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESP%3C/text%3E%3C/svg%3E)
Simone Pagliani
1
Reputation point
commented 2020-10-15T14:10:06.78+00:00
Simone Pagliani
1
Reputation point