diff --git a/.ansible-collection-microsoft-sql.metadata b/.ansible-collection-microsoft-sql.metadata
new file mode 100644
index 0000000..e8ea9c3
--- /dev/null
+++ b/.ansible-collection-microsoft-sql.metadata
@@ -0,0 +1,2 @@
+99df2e20aff7ec8c244218a45bbcd3d68b791311 SOURCES/auto-maintenance-cdc706f14614ef5e80bbce8db10beb369e889df9.tar.gz
+6fd1a1faa5e3c0108b1cbc7a031b6e3e5dde76e0 SOURCES/mssql-78ea547ef9e23e20015794a1e48c7d6d21229293.tar.gz
diff --git a/.gitignore b/.gitignore
new file mode 100644
index 0000000..4ab0844
--- /dev/null
+++ b/.gitignore
@@ -0,0 +1,2 @@
+SOURCES/auto-maintenance-cdc706f14614ef5e80bbce8db10beb369e889df9.tar.gz
+SOURCES/mssql-78ea547ef9e23e20015794a1e48c7d6d21229293.tar.gz
diff --git a/SPECS/ansible-collection-microsoft-sql.spec b/SPECS/ansible-collection-microsoft-sql.spec
new file mode 100644
index 0000000..37cac0c
--- /dev/null
+++ b/SPECS/ansible-collection-microsoft-sql.spec
@@ -0,0 +1,432 @@
+%if 0%{?rhel} && ! 0%{?epel}
+%bcond_with ansible
+%else
+%bcond_without ansible
+%endif
+
+%bcond_with collection_artifact
+
+# Do not convert .md to .html on RHEL 7 because tools the conversion are not available
+%if 0%{?fedora} || 0%{?rhel} >= 8
+%bcond_without html
+%else
+%bcond_with html
+%endif
+
+Name: ansible-collection-microsoft-sql
+Url: https://github.com/linux-system-roles/mssql
+Summary: The Ansible collection for Microsoft SQL Server management
+Version: 1.1.0
+Release: 1%{?dist}
+
+#Group: Development/Libraries
+License: MIT
+%global installbase %{_datadir}/microsoft
+%global _pkglicensedir %{_licensedir}/%{name}
+
+%global collection_namespace microsoft
+%global collection_name sql
+
+%global collection_version %{version}
+
+# Helper macros originally from macros.ansible by Igor Raits <ignatenkobrain>
+# Not available on RHEL, so we must define those macros locally here without using ansible-galaxy
+
+# Not used (yet). Could be made to point to AH in RHEL - but what about CentOS Stream?
+#%%{!?ansible_collection_url:%%define ansible_collection_url() https://galaxy.ansible.com/%%{collection_namespace}/%%{collection_name}}
+
+%if 0%{?fedora} || 0%{?rhel} >= 8
+%{!?ansible_collection_files:%define ansible_collection_files %{_datadir}/ansible/collections/ansible_collections/%{collection_namespace}/}
+%else
+# Define undefined macro using "!?ansible_collection_files:..." does not work for rhel-7
+%if %{?ansible_collection_files:0}%{!?ansible_collection_files:1}
+%define ansible_collection_files %{_datadir}/ansible/collections/ansible_collections/%{collection_namespace}/
+%endif
+%endif
+
+%if %{with ansible}
+BuildRequires: ansible >= 2.9.10
+%endif
+
+%if %{without ansible}
+# We don't have ansible-galaxy.
+# Simply copy everything instead of galaxy-installing the built artifact.
+%define ansible_collection_build_install() tar -cf %{_tmppath}/%{collection_namespace}-%{collection_name}-%{version}.tar.gz .; mkdir -p %{buildroot}%{ansible_collection_files}%{collection_name}; (cd %{buildroot}%{ansible_collection_files}%{collection_name}; tar -xf %{_tmppath}/%{collection_namespace}-%{collection_name}-%{version}.tar.gz)
+%else
+%define ansible_collection_build_install() ansible-galaxy collection build; ansible-galaxy collection install -n -p %{buildroot}%{_datadir}/ansible/collections %{collection_namespace}-%{collection_name}-%{version}.tar.gz
+%endif
+
+# For each role, call defcommit() and the point to it with SourceN: %{archiveurlN}.
+%global archiveext tar.gz
+# list of source role names
+%global rolenames %nil
+# list of assignments that can be used to populate a bash associative array variable
+%global rolestodir %nil
+# list of target rolenames to copy the roles to
+%global target_rolenames %nil
+# list of collection rolenames to convert the roles to
+%global collection_rolenames %nil
+
+%define getarchivedir() %(p=%{basename:%{S:%{1}}}; echo ${p%%.%{archiveext}})
+
+%global parenturl https://github.com/linux-system-roles
+
+%define defcommit() %{expand:%%global ref%{1} %{2}
+%%global shortcommit%{1} %%(c=%%{ref%{1}}; echo ${c:0:7})
+%%global extractdir%{1} %%{expand:%%getarchivedir %{1}}
+%%global archiveurl%{1} %%{parenturl}/%%{rolename%{1}}/archive/%%{ref%{1}}/%%{rolename%{1}}-%%{ref%{1}}.tar.gz
+%%global rolenames %%{?rolenames} %%{rolename%{1}}
+%%global roletodir%{1} [%{rolename%{1}}]="%{extractdir%{1}}"
+%%global rolestodir %%{?rolestodir} %{roletodir%{1}}
+%%{!?target_rolename%{1}:%%global target_rolename%{1} %%{rolename%{1}}}
+%%global target_rolenames %%{?target_rolenames} [%{rolename%{1}}]="%{target_rolename%{1}}"
+%%{!?collection_rolename%{1}:%%global collection_rolename%{1} %%{rolename%{1}}}
+%%global collection_rolenames %%{?collection_rolenames} [%{rolename%{1}}]="%{collection_rolename%{1}}"
+}
+
+%defcommit 1 78ea547ef9e23e20015794a1e48c7d6d21229293
+%global rolename1 mssql
+%global target_rolename1 sql-server
+%global collection_rolename1 server
+
+%global mainid cdc706f14614ef5e80bbce8db10beb369e889df9
+Source: %{parenturl}/auto-maintenance/archive/%{mainid}/auto-maintenance-%{mainid}.tar.gz
+Source1: %{archiveurl1}
+
+BuildArch: noarch
+
+%if %{with html}
+# Requirements for md2html.sh to build the documentation
+%if 0%{?fedora} || 0%{?rhel} >= 9
+BuildRequires: rubygem-kramdown-parser-gfm
+%else
+BuildRequires: pandoc
+BuildRequires: asciidoc
+BuildRequires: highlight
+%endif
+%endif
+
+# Requirements for galaxy_transform.py
+BuildRequires: python3
+%if 0%{?fedora} || 0%{?rhel} >= 8
+BuildRequires: python3dist(ruamel.yaml)
+%else
+BuildRequires: python3-ruamel-yaml
+%endif
+
+%if %{undefined __ansible_provides}
+Provides: ansible-collection(%{collection_namespace}.%{collection_name}) = %{collection_version}
+%endif
+# be compatible with the usual Fedora Provides:
+Provides: ansible-collection-%{collection_namespace}-%{collection_name} = %{version}-%{release}
+
+%description
+This RPM installs the Ansible collection for Microsoft SQL Server management
+microsoft.sql. This RPM also installs the roles provided by the collection in
+the legacy roles format for users of Ansible < 2.9.
+
+%if %{with collection_artifact}
+%package collection-artifact
+Summary: Collection artifact to import to Automation Hub / Ansible Galaxy
+
+%description collection-artifact
+Collection artifact for %{name}. This package contains %{collection_namespace}-%{collection_name}-%{version}.tar.gz
+%endif
+
+%prep
+%setup -q -a1 -n %{getarchivedir 0}
+
+# Declare the array containing names of directories to copy roles to for prep
+declare -A ROLESTODIR=(%{rolestodir})
+for rolename in %{rolenames}; do
+    mv "${ROLESTODIR[${rolename}]}" ${rolename}
+done
+
+# Removing symlinks in tests/roles
+for rolename in %{rolenames}; do
+    if [ -d ${rolename}/tests/roles ]; then
+        find ${rolename}/tests/roles -type l -exec rm {} \;
+        if [ -d ${rolename}/tests/roles/linux-system-roles.${rolename} ]; then
+            rm -r ${rolename}/tests/roles/linux-system-roles.${rolename}
+        fi
+    fi
+done
+
+# transform ambiguous #!/usr/bin/env python shebangs to python3 to stop brp-mangle-shebangs complaining
+find -type f -executable -name '*.py' -exec \
+     sed -i -r -e '1s@^(#! */usr/bin/env python)(\s|$)@#\13\2@' '{}' +
+
+%build
+%if %{with html}
+# Convert README.md to README.html in the source roles
+readmes=""
+for rolename in %{rolenames}; do
+    readmes="${readmes} $rolename/README.md"
+done
+sh md2html.sh $readmes
+%endif
+
+mkdir .collections
+# Copy README.md for the collection build
+cp %{rolename1}/.collection/README.md lsr_role2collection/collection_readme.md
+# Copy galaxy.yml for the collection build
+cp %{rolename1}/.collection/galaxy.yml ./
+# Ensure the correct entries in galaxy.yml
+./galaxy_transform.py "%{collection_namespace}" "%{collection_name}" "%{collection_version}" "Ansible collection for Microsoft SQL Server management" > galaxy.yml.tmp
+mv galaxy.yml.tmp galaxy.yml
+
+# Declare the array containing collection rolenames to convert roles to
+declare -A COLLECTION_ROLENAMES=(%{collection_rolenames})
+
+# Convert roles to the collection format
+for rolename in %{rolenames}; do
+    python3 lsr_role2collection.py --role "$rolename" \
+        --src-path "$rolename" \
+        --src-owner linux-system-roles \
+        --dest-path .collections \
+        --readme lsr_role2collection/collection_readme.md \
+        --namespace %{collection_namespace} --collection %{collection_name} \
+        --new-role "${COLLECTION_ROLENAMES[${rolename}]}" \
+        --meta-runtime lsr_role2collection/runtime.yml
+done
+
+# removing dot files/dirs
+rm -r .collections/ansible_collections/%{collection_namespace}/%{collection_name}/.[A-Za-z]*
+
+# Copy galaxy.yml to the collection directory
+cp -p galaxy.yml .collections/ansible_collections/%{collection_namespace}/%{collection_name}
+
+%install
+mkdir -p $RPM_BUILD_ROOT%{installbase}
+mkdir -p $RPM_BUILD_ROOT%{_datadir}/ansible/roles
+
+# Declare the array containing target rolenames to copy roles to
+declare -A TARGET_ROLENAMES=(%{target_rolenames})
+
+# Copy roles to the target directory within the microsoft directory and rename
+for rolename in %{rolenames}; do
+    cp -pR "$rolename" "$RPM_BUILD_ROOT%{installbase}/${TARGET_ROLENAMES[${rolename}]}"
+    sed -i "s/linux-system-roles\.$rolename/microsoft\.${TARGET_ROLENAMES[${rolename}]}/g" \
+      $RPM_BUILD_ROOT%{installbase}/${TARGET_ROLENAMES[${rolename}]}/tests/*.yml
+done
+
+# Generate symlinks for roles in /usr/share/ansible/roles
+for rolename in %{rolenames}; do
+    ln -s "%{installbase}/${TARGET_ROLENAMES[${rolename}]}" "$RPM_BUILD_ROOT%{_datadir}/ansible/roles/microsoft.${TARGET_ROLENAMES[${rolename}]}"
+done
+
+# Copy README, COPYING, and LICENSE files to the corresponding directories
+mkdir -p $RPM_BUILD_ROOT%{_pkglicensedir}
+for rolename in %{rolenames}; do
+    mkdir -p "$RPM_BUILD_ROOT%{_pkgdocdir}/${TARGET_ROLENAMES[${rolename}]}"
+    cp -p "$RPM_BUILD_ROOT%{installbase}/${TARGET_ROLENAMES[${rolename}]}/README.md" \
+       "$RPM_BUILD_ROOT%{_pkgdocdir}/${TARGET_ROLENAMES[${rolename}]}"
+%if %{with html}
+    cp -p "$RPM_BUILD_ROOT%{installbase}/${TARGET_ROLENAMES[${rolename}]}/README.html" \
+       "$RPM_BUILD_ROOT%{_pkgdocdir}/${TARGET_ROLENAMES[${rolename}]}"
+%endif
+    if [ -f "$RPM_BUILD_ROOT%{installbase}/${TARGET_ROLENAMES[${rolename}]}/COPYING" ]; then
+        cp -p "$RPM_BUILD_ROOT%{installbase}/${TARGET_ROLENAMES[${rolename}]}/COPYING" \
+           "$RPM_BUILD_ROOT%{_pkglicensedir}/${TARGET_ROLENAMES[${rolename}]}.COPYING"
+    fi
+    if [ -f "$RPM_BUILD_ROOT%{installbase}/${TARGET_ROLENAMES[${rolename}]}/LICENSE" ]; then
+        cp -p "$RPM_BUILD_ROOT%{installbase}/${TARGET_ROLENAMES[${rolename}]}/LICENSE" \
+           "$RPM_BUILD_ROOT%{_pkglicensedir}/${TARGET_ROLENAMES[${rolename}]}.LICENSE"
+    fi
+done
+
+# Remove dot files
+rm -r $RPM_BUILD_ROOT%{installbase}/*/.[A-Za-z]*
+
+# Remove the molecule directory
+rm -r $RPM_BUILD_ROOT%{installbase}/*/molecule
+
+pushd .collections/ansible_collections/%{collection_namespace}/%{collection_name}/
+%ansible_collection_build_install
+popd
+
+mkdir -p $RPM_BUILD_ROOT%{_pkgdocdir}/collection
+mkdir -p $RPM_BUILD_ROOT%{_pkgdocdir}/collection/roles
+
+# Copy the collection README files to the collection
+cp -p %{buildroot}%{ansible_collection_files}%{collection_name}/README.md \
+   $RPM_BUILD_ROOT%{_pkgdocdir}/collection
+
+# Declare the array containing collection rolenames to convert roles to
+declare -A COLLECTION_ROLENAMES=(%{collection_rolenames})
+
+for rolename in %{rolenames}; do
+  if [ -f "%{buildroot}%{ansible_collection_files}%{collection_name}/roles/${COLLECTION_ROLENAMES[${rolename}]}/README.md" ]; then
+    mkdir -p $RPM_BUILD_ROOT%{_pkgdocdir}/collection/roles/${COLLECTION_ROLENAMES[${rolename}]}
+    cp -p %{buildroot}%{ansible_collection_files}%{collection_name}/roles/${COLLECTION_ROLENAMES[${rolename}]}/README.md \
+        $RPM_BUILD_ROOT%{_pkgdocdir}/collection/roles/${COLLECTION_ROLENAMES[${rolename}]}
+  fi
+done
+
+%if %{with html}
+# converting README.md to README.html for collection in $RPM_BUILD_ROOT%{_pkgdocdir}/collection
+readmes="$RPM_BUILD_ROOT%{_pkgdocdir}/collection/README.md"
+for rolename in %{rolenames}; do
+    readmes="${readmes} $RPM_BUILD_ROOT%{_pkgdocdir}/collection/roles/${COLLECTION_ROLENAMES[${rolename}]}/README.md"
+done
+sh md2html.sh $readmes
+%endif
+
+%if %{with collection_artifact}
+# Copy collection artifact to /usr/share/ansible/collections/ for collection-artifact
+pushd .collections/ansible_collections/%{collection_namespace}/%{collection_name}/
+if [ -f %{collection_namespace}-%{collection_name}-%{version}.tar.gz ]; then
+    mv %{collection_namespace}-%{collection_name}-%{version}.tar.gz \
+       $RPM_BUILD_ROOT%{_datadir}/ansible/collections/
+fi
+popd
+%endif
+
+# generate the %files section in the file files_section.txt
+format_item_for_files() {
+    # $1 is directory or file name in buildroot
+    # $2 - if true, and item is a directory, use %dir
+    local item
+    local files_item
+    item="$1"
+    files_item=${item##"%{buildroot}"}
+    if [ -L "$item" ]; then
+        echo "$files_item"
+    elif [ -d "$item" ]; then
+        if [[ "$item" == */doc* ]]; then
+            echo "%doc $files_item"
+        elif [ "${2:-false}" = true ]; then
+            echo "%dir $files_item"
+        else
+            echo "$files_item"
+        fi
+    elif [[ "$item" == */README.md ]] || [[ "$item" == */README.html ]]; then
+        if [[ "$item" == */private_* ]]; then
+            # mark as regular file, not %doc
+            echo "$files_item"
+        else
+            echo "%doc $files_item"
+        fi
+    elif [[ "$item" != */COPYING* ]] && [[ "$item" != */LICENSE* ]]; then
+        # Avoid dynamically using the license macro since the license macro
+        # is replaced with the value of License directive in the older rpmbuild.
+        echo "$files_item"
+    fi
+}
+
+files_section=files_section.txt
+rm -f $files_section
+touch $files_section
+%if %{without ansible}
+echo '%dir %{_datadir}/ansible' >> $files_section
+echo '%dir %{_datadir}/ansible/roles' >> $files_section
+%endif
+%if "%{installbase}" != "%{_datadir}/ansible/roles"
+echo '%dir %{installbase}' >> $files_section
+%endif
+echo '%dir %{ansible_collection_files}' >> $files_section
+echo '%dir %{ansible_collection_files}%{collection_name}' >> $files_section
+find %{buildroot}%{ansible_collection_files}%{collection_name} -mindepth 1 -maxdepth 1 | \
+    while read item; do
+        if [[ "$item" == */roles ]]; then
+            format_item_for_files "$item" true >> $files_section
+            find "$item" -mindepth 1 -maxdepth 1 | while read roles_dir; do
+                format_item_for_files "$roles_dir" true >> $files_section
+                find "$roles_dir" -mindepth 1 -maxdepth 1 | while read roles_item; do
+                    format_item_for_files "$roles_item" >> $files_section
+                done
+            done
+        else
+            format_item_for_files "$item" >> $files_section
+        fi
+    done
+
+find %{buildroot}%{installbase} -mindepth 1 -maxdepth 1 | \
+    while read item; do
+        if [ -d "$item" ]; then
+            format_item_for_files "$item" true >> $files_section
+            find "$item" -mindepth 1 -maxdepth 1 | while read roles_item; do
+                format_item_for_files "$roles_item" >> $files_section
+            done
+        else
+            format_item_for_files "$item" >> $files_section
+        fi
+    done
+if [ "%{installbase}" != "%{_datadir}/ansible/roles" ]; then
+    find %{buildroot}%{_datadir}/ansible/roles -mindepth 1 -maxdepth 1 | \
+        while read item; do
+            if [ -d "$item" ]; then
+                format_item_for_files "$item" true >> $files_section
+                find "$item" -mindepth 1 -maxdepth 1 | while read roles_item; do
+                    format_item_for_files "$roles_item" >> $files_section
+                done
+            else
+                format_item_for_files "$item" >> $files_section
+            fi
+        done
+fi
+# cat files_section.txt
+# done with files_section.txt generation
+
+%files -f files_section.txt
+%{_pkgdocdir}/*/README.md
+%{_pkgdocdir}/collection/roles/*/README.md
+%if %{with html}
+%{_pkgdocdir}/*/README.html
+%{_pkgdocdir}/collection/roles/*/README.html
+%endif
+%license %{_pkglicensedir}/*
+%license %{installbase}/*/LICENSE*
+%license %{ansible_collection_files}/%{collection_name}/LICENSE*
+
+%if %{with collection_artifact}
+%files collection-artifact
+%{_datadir}/ansible/collections/%{collection_namespace}-%{collection_name}-%{version}.tar.gz
+%endif
+
+%changelog
+* Wed Jul 21 2021 Sergei Petrosian <spetrosi@redhat.com> - 1.1.0-1
+- Add support for Microsoft SQL Server 2017
+
+* Mon Jul 19 2021 Sergei Petrosian <spetrosi@redhat.com> - 1.0.12-2
+- Copy fix for RHEL 7 builds from rhel-system-roles
+  Link to the original fix:
+  https://src.fedoraproject.org/rpms/linux-system-roles/c/093981119f99ac51a6e06a2714b587e4e2fe287c
+
+* Tue Jul 13 2021 Sergei Petrosian <spetrosi@redhat.com> - 1.0.12-1
+- Add the meta-runtime option from the latest auto-maintenance
+- Use the latest mssql that ships fixes for issues #24,#25,#26,#27,#28,35
+
+* Tue Jun 29 2021 Sergei Petrosian <spetrosi@redhat.com> - 1.0.11-3
+- Add a missing slash at the {ansible_collection_files} definition for rhel 7
+
+* Thu Jun 17 2021 Sergei Petrosian <spetrosi@redhat.com> - 1.0.11-2
+- Make the ansible_collection_files macro defined in Fedora automatically and
+  in RHEL manually consistent - having slash at the end to clean double-slashes
+
+* Thu Jun 17 2021 Sergei Petrosian <spetrosi@redhat.com> - 1.0.11-1
+- Update the version to be consistent with the Galaxy collection at
+  https://galaxy.ansible.com/microsoft/sql
+
+* Wed Jun 16 2021 Sergei Petrosian <spetrosi@redhat.com> - 0.0.1-5
+- Update commit hash for mssql
+
+* Wed Jun 16 2021 Sergei Petrosian <spetrosi@redhat.com> - 0.0.1-4
+- Generate symlinks for roles in /usr/share/ansible/roles
+
+* Wed Jun 16 2021 Sergei Petrosian <spetrosi@redhat.com> - 0.0.1-3
+- Copy changes made to linux-system-roles in this PR:
+  https://src.fedoraproject.org/rpms/linux-system-roles/pull-request/13#
+- Make spec file available for older versions of OSes.
+- Drop python3-six dependency which was used by lsr_role2collection.py.
+- Drop html files from rpm if the version has no markdown parser.
+- Drop unnecessary python scripts which include python3 only code, e.g.,
+  f-strings.
+  Resolves rhbz#1970165
+
+* Mon Jun 14 2021 Sergei Petrosian <spetrosi@redhat.com> - 0.0.1-2
+- Fix long description lines
+- Fix incorrect role includes in microsoft/sql-server/tests/
+
+* Thu Jun 3 2021 Sergei Petrosian <spetrosi@redhat.com> - 0.0.1-1
+- Initial release