MSSQL database migration to another database server

When a database is migrated to another server by copying the database file or restoring it from a backup file, the original database user account references are also carried with it. Those accounts contain the account IDs specific to the original database server. To provide access to the restored database on the new database server […]

Microsoft SQL Server clients

To connect to an MSSQL database on Macintosh Install the Azure Data Studio Download it from Download and install Azure Data Studio on Windows Install SSMS (SQL Server Management Studio Download it from Download SQL Server Management Studio (SSMS) Install the Azure Data Studio Download it from Download and install Azure Data Studio

Migrate databases to and from AWS RDS instances

Amazon Web Services do not provide tools to migrate data to, from and between AWS RDS instances. There is a free utility that can do the job. SQL Server Management Studio (SSMS) Install Microsoft SQL Server Management Studio (SSMS), because the utility uses libraries from it. Download the installer for free from https://msdn.microsoft.com/en-us/library/mt238290.aspx SQL Azure Migration […]