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

PowerShell: Invoke Backup SQL Database

Function to invoke SQL Backups on a Remote SQL Server: # invokeSqlBackup.ps1 # Version 0.0.1…

Enable Jumbo Frames on a Windows Host

Overview: Whether the engineer or sysadmin works in the realm of 'networking', 'database', or 'Windows',…

SQL: DELETE FROM Statement

DELETE FROM `Profiles` WHERE Picture = '0'--------------------------------------------------Change password to "sexcenter"UPDATE `Profiles`SET Password = '5863294bde549649adab89940c3e09ea'WHERE Password…
Other project: DragonCoin.com