Skip to content

Commit 0c78775

Browse files
nahk-ivanovnahk-ivanov
committed
Update installation instructions for SSMA.
I also noticed that Azure MI include was not working properly when used within a quote. This turned out to be due to the header being present in the include file. I removed it and problem was resolved.
1 parent 1806ad3 commit 0c78775

9 files changed

Lines changed: 451 additions & 500 deletions

‎docs/includes/ssazuremi_md.md‎

Lines changed: 0 additions & 8 deletions
Original file line numberDiff line numberDiff line change
@@ -1,9 +1 @@
1-
---
2-
author: MikeRayMSFT
3-
ms.service: sql
4-
ms.topic: include
5-
ms.date: 06/11/2020
6-
ms.author: mikeray
7-
---
8-
91
Azure SQL Managed Instance

‎docs/ssma/access/installing-sql-server-migration-assistant-for-access-accesstosql.md‎

Lines changed: 55 additions & 62 deletions
Original file line numberDiff line numberDiff line change
@@ -3,7 +3,7 @@ title: "Installing SQL Server Migration Assistant for Access (AccessToSQL) | Mic
33
description: Learn about installation prerequisites for SQL Server Migration Assistant (SSMA) for Access and how to install, license, upgrade, and uninstall.
44
ms.prod: sql
55
ms.custom: ""
6-
ms.date: "08/15/2017"
6+
ms.date: "07/14/2020"
77
ms.reviewer: ""
88
ms.technology: ssma
99
ms.topic: conceptual
@@ -21,69 +21,62 @@ helpviewer_keywords:
2121
- "uninstalling SSMA"
2222
- "upgrading SSMA"
2323
ms.assetid: dd50eebd-75df-4e0d-8c4d-88b511aae4c7
24-
author: "Shamikg"
25-
ms.author: "Shamikg"
24+
author: "nahk-ivanov"
25+
ms.author: "alexiva"
2626
---
27+
2728
# Installing SQL Server Migration Assistant for Access (AccessToSQL)
28-
[!INCLUDE[msCoName](../../includes/msconame_md.md)] [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Migration Assistant (SSMA) for Access is installed by using a Windows Installer-based wizard. This topic provides information about installation prerequisites, a link to the latest version of SSMA, and instructions for installing, licensing, uninstalling, and upgrading SSMA.
29-
30-
## Prerequisites
31-
Before you install SSMA, make sure that your system meets the following requirements:
32-
33-
- Windows 7 or a later version, or Windows Server 2008 or a later version.
34-
35-
- [!INCLUDE[msCoName](../../includes/msconame_md.md)] Windows Installer 3.1 or a later version.
36-
37-
- The [!INCLUDE[msCoName](../../includes/msconame_md.md)] .NET Framework version 4.0 or a later version. The .NET Framework version 4.0 is available on the [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] product disc, and by using information in the [Microsoft .NET Guide](https://docs.microsoft.com/dotnet/framework/).
38-
39-
- Access to and sufficient permissions on the computer that hosts the target instance of [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)]/SQL Azure DB to which you will be migrating database objects and data.
40-
41-
- Microsoft Data Access Object (DAO) provider version 12.0 or 14.0. You can install DAO provider from Microsoft Office 2010/2007 product or download it from Microsoft web site.
42-
43-
- The SQL Server Native Access Client (SNAC) version 10.5 and above for migration to SQL Azure. You can obtain the latest version of SNAC from [Microsoft® SQL Server® 2008 R2 Feature Pack](https://www.microsoft.com/download/details.aspx?id=44272)
44-
45-
- 4 GB RAM (recommended).
46-
47-
## Installing SSMA
48-
SSMA is a Web download. To download the latest version, see the [SQL Server Migration Assistant download page](https://aka.ms/ssmaforaccess).
49-
50-
After you download the latest version, you must extract the installation files from before you can install SSMA.
5129

52-
> [!IMPORTANT]
53-
> - Please uninstall all prior versions of SSMA for Access before installing the new version.
54-
55-
**To install SSMA**
56-
57-
1. Double-click SSMA for Access *n*.msi, where *n* is the build number.
58-
59-
2. On the Welcome page, click **Next**.
60-
61-
If you do not have the prerequisites installed, a message appears that indicates that you must first install required components. Make sure that you have installed all prerequisites, and then run the installation program again.
62-
63-
3. Read the End-User License Agreement; if you agree, select **I accept the agreement**, and then click **Next**.
64-
65-
4. On the Choose Setup Type page, click **Typical**.
66-
67-
5. Click **Install**.
68-
69-
The default installation location is C:\Program Files\Microsoft SQL Server Migration Assistant for Access.
70-
71-
## Uninstalling SSMA for Access
72-
Uninstall SSMA by using **Add or Remove Programs** in Control Panel. Be aware that uninstalling the program does not delete SSMA project files or log files.
73-
74-
**To uninstall SSMA**
75-
76-
1. Click **Start**, click **Control Panel**, and then click **Add or Remove Programs**.
77-
78-
2. Select **Microsoft SQL Server Migration Assistant for Access**, and then click **Remove**.
79-
80-
## Upgrading to a later version
81-
If you want to upgrade to a later version of SSMA for Access, you must first uninstall SSMA for Access and then install the newer version. Follow the instructions in the Uninstalling SSMA for Access section to complete this process.
82-
83-
If you open a project created in an earlier version of SSMA for Access, SSMA asks if you want to convert the project to the newer version. Click **Yes** to work with the project in the newer version of SSMA.
30+
[!INCLUDE[msCoName](../../includes/msconame_md.md)] [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Migration Assistant (SSMA) for Access is installed by using a Windows Installer-based wizard. This topic provides information about installation prerequisites, a link to the latest version of SSMA, and instructions for installing, licensing, uninstalling, and upgrading SSMA.
31+
32+
## Prerequisites
33+
34+
Before you install SSMA, make sure that your system meets the following requirements:
35+
36+
- Windows 7 or a later version, or Windows Server 2008 or a later version.
37+
- [!INCLUDE[msCoName](../../includes/msconame_md.md)] Windows Installer 3.1 or a later version.
38+
- The [!INCLUDE[msCoName](../../includes/msconame_md.md)] .NET Framework version 4.7.2 or a later version. The .NET Framework is available at [Microsoft .NET Guide](https://docs.microsoft.com/dotnet/framework/).
39+
- Access to and sufficient permissions on the computer that hosts the target instance of [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] or [!INCLUDE[ssAzure](../../includes/ssazure_md.md)] to which you will be migrating database objects and data.
40+
- Microsoft Data Access Object (DAO) provider version 12.0 or 14.0. You can install DAO provider from Microsoft Office 2010/2007 product or download it from Microsoft web site.
41+
- 4 GB RAM (recommended).
42+
43+
## Installing SSMA
44+
45+
SSMA is a Web download. To download the latest version, see the [SQL Server Migration Assistant download page](https://aka.ms/ssmaforaccess).
46+
47+
> [!IMPORTANT]
48+
> Please uninstall all prior versions of SSMA for Access before installing the new version.
49+
50+
To install SSMA:
8451

85-
## See also
86-
[Preparing Access Databases for Migration](preparing-access-databases-for-migration-accesstosql.md)
87-
[Migrating Access Databases to SQL Server](migrating-access-databases-to-sql-server-azure-sql-db-accesstosql.md)
88-
[Linking Access Applications to SQL Server](linking-access-applications-to-sql-server-azure-sql-db-accesstosql.md)
52+
1. Double-click **SSMAforAccess_*n*.msi**, where *n* is the build number.
53+
2. On the Welcome page, click **Next**.
54+
55+
If you do not have the prerequisites installed, a message appears that indicates that you must first install required components. Make sure that you have installed all prerequisites, and then run the installation program again.
56+
57+
3. Read the End-User License Agreement; if you agree, select **I accept the agreement**, and then click **Next**.
58+
4. On the **Choose Setup Type** page, click **Typical**.
59+
5. On the **Ready to Install** page you can enable or disable telemetry and automatic update checks every time the tool starts. Click **Install** to start the installation.
8960

61+
The default installation location is `C:\Program Files\Microsoft SQL Server Migration Assistant for Access`.
62+
63+
## Uninstalling SSMA for Access
64+
65+
Uninstall SSMA by using **Add or Remove Programs** in Control Panel. Be aware that uninstalling the program does not delete SSMA project files or log files.
66+
67+
To uninstall SSMA:
68+
69+
1. Click **Start**, click **Control Panel**, and then click **Add or Remove Programs**.
70+
2. Select **Microsoft SQL Server Migration Assistant for Access**, and then click **Remove**.
71+
72+
## Upgrading to a later version
73+
74+
If you want to upgrade to a later version of SSMA for Access, you must first uninstall SSMA for Access and then install the newer version. Follow the instructions in the Uninstalling SSMA for Access section to complete this process.
75+
76+
If you open a project created in an earlier version of SSMA for Access, SSMA may ask if you want to convert the project to the newer version. Click **Yes** to work with the project in the newer version of SSMA.
77+
78+
## See also
79+
80+
- [Preparing Access Databases for Migration](preparing-access-databases-for-migration-accesstosql.md)
81+
- [Migrating Access Databases to SQL Server](migrating-access-databases-to-sql-server-azure-sql-db-accesstosql.md)
82+
- [Linking Access Applications to SQL Server](linking-access-applications-to-sql-server-azure-sql-db-accesstosql.md)

‎docs/ssma/db2/installing-ssma-for-db2-client-db2tosql.md‎

Lines changed: 10 additions & 12 deletions
Original file line numberDiff line numberDiff line change
@@ -32,36 +32,34 @@ Before you install SSMA, make sure that the computer meets the following require
3232

3333
- Windows 7 or later versions, or Windows Server 2008 or later versions.
3434
- [!INCLUDE[msCoName](../../includes/msconame_md.md)] Windows Installer 3.1 or later versions.
35-
- The [!INCLUDE[msCoName](../../includes/msconame_md.md)] [!INCLUDE[dnprdnshort](../../includes/dnprdnshort_md.md)] version 4.0 or a later version. The [!INCLUDE[dnprdnshort](../../includes/dnprdnshort_md.md)] version 4.0 is available on the [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] product media. You can also obtain it from the [.NET Framework Developer Center](https://go.microsoft.com/fwlink/?LinkId=48882).
36-
- Microsoft OLEDB Provider for DB2 version 5 or a later version, and connectivity to the DB2 databases that you want to migrate.
35+
- The [!INCLUDE[msCoName](../../includes/msconame_md.md)] [!INCLUDE[dnprdnshort](../../includes/dnprdnshort_md.md)] version 4.7.2 or a later version. You can obtain it from the [.NET Framework Developer Center](https://go.microsoft.com/fwlink/?LinkId=48882).
36+
- Microsoft OLE DB Provider for DB2 version 5 or a later version, and connectivity to the DB2 databases that you want to migrate.
3737
- Access to and sufficient permissions on the computer that hosts the target instance of [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] or Azure SQL DB where you will be migrating database objects and data. For more information, see [Connecting to SQL Server (DB2eToSQL)](../../ssma/db2/connecting-to-sql-server-db2etosql.md).
3838
- 4 GB RAM recommended.
3939

40-
## Microsoft OLEDB Provider for DB2
40+
## Microsoft OLE DB Provider for DB2
4141

42-
To download the OLEDB provider for DB2 version 6.0, go to [Microsoft® SQL Server® 2017 Feature Pack](https://www.microsoft.com/download/details.aspx?id=55992).
42+
To download the OLE DB provider for DB2 version 6.0, go to [Microsoft® SQL Server® 2017 Feature Pack](https://www.microsoft.com/download/details.aspx?id=55992).
4343

4444
SSMA is a Web download. To download the latest version, see the [SQL Server Migration Assistant download page](https://aka.ms/ssmafordb2).
4545

46-
After you download the latest version, extract the installation files so you can install SSMA.
47-
4846
To install the SSMA client:
4947

50-
1. Double-click SSMAforDB2_*n*.exe, where *n* is the build number.
48+
1. Double-click **SSMAforDB2_*n*.msi**, where *n* is the build number.
5149
2. On the **Welcome** page, select **Next**.
5250

5351
If you don't have the prerequisites installed, a message will appear indicating that you must first install required components. Make sure that you've installed all prerequisites, and then run the installation program again.
5452

55-
3. Read the End User License Agreement. If you agree, select **I accept the terms in the license agreement**, and then select **Next**.
53+
3. Read the End-User License Agreement. If you agree, select **I accept the agreement**, and then select **Next**.
5654
4. On the **Choose Setup Type** page, select **Typical**.
57-
5. Select **Install**.
55+
5. On the **Ready to Install** page you can enable or disable telemetry and automatic update checks every time the tool starts. Click **Install** to start the installation.
5856

5957
> [!IMPORTANT]
6058
> Please uninstall all prior versions of SSMA for DB2 before installing the new version.
6159
62-
The default installation location is C:\Program Files\Microsoft SQL Server Migration Assistant for DB2.
60+
The default installation location is `C:\Program Files\Microsoft SQL Server Migration Assistant for DB2`.
6361

6462
## See also
6563

66-
- [Installing SSMA Components on SQL Server (DB2ToSQL)](../../ssma/db2/installing-ssma-components-on-sql-server-db2tosql.md)
67-
- [Migrating DB2 Databases to SQL Server (DB2ToSQL)](../../ssma/db2/migrating-db2-databases-to-sql-server-db2tosql.md)
64+
- [Installing SSMA Components on SQL Server](../../ssma/db2/installing-ssma-components-on-sql-server-db2tosql.md)
65+
- [Migrating DB2 Databases to SQL Server](../../ssma/db2/migrating-db2-databases-to-sql-server-db2tosql.md)

0 commit comments

Comments
 (0)