Posted On March 31, 2019

DB2 AS400 to Microsoft SQL Conversion

kimconnect 0 comments
blog.KimConnect.com >> Database >> DB2 AS400 to Microsoft SQL Conversion
SQL Ways Wizard:
Enter ODBC data source, username, and password >> press Next
Set Target = Microsoft SQL Server, Version 2012 >> Enter servername and “sa” credentials >> press Next
Select all objects required for migration >> press Next
choose the desired schema name, data type, object names, reserved words, etc. >> press Next
click on the “…” button to choose a temporary location for the database dump prior to importing into SQL >> press Next >> click OK

Leave a Reply

Your email address will not be published. Required fields are marked *

Related Post

Check Servers NSLookup of a Listener to Match Active Node IP

$servers="SQL01","SQL02","SQL03","SQL04" $listener="halistener01" $activeNode="10.10.10.5" # Dynamic Credential method 1 $who = whoami if ($who.Substring($who.length-2, 2)="-admin"){$username=$who;} else…

PowerShell: Graceful Shutdown of MS SQL Server

import-module sqlps CD SQLSERVER:\SQL\$env:computername $sql = (get-item .).ManagedComputer # This command stops MSSQL$instanceName, SQLSERVERAGENT, SQLAGENT$instanceName,…

MongoDB: Backup and Restore

Manual Methods:Using mongodump and mongorestoreMaking a backup using mongodump- Permissions required: grant find action, backup…