Posted On March 31, 2019

DB2 AS400 to Microsoft SQL Conversion

kimconnect 0 comments
blog.KimConnect.com >> Database >> DB2 AS400 to Microsoft SQL Conversion
March 31, 2019March 31, 2019 kimconnectkimconnect 0 Comments
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
Categories:

Leave a Reply

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

Related Post

Post Image

Read More

Gallery2 Random Highlight Mod

There's a SQL technical limitation where one may not update a table based on its…
Post Image

Read More

PowerShell: Get SQL Job History

$computername='sql01' function getSqlJobHistory($sqlServerName){ try{ if(!(get-module SqlServer)){ Install-Module -Name SqlServer } Import-Module -Name SqlServer $sqlServerInstance=Get-SqlInstance -ServerInstance…
Post Image

Read More

Use PowerShell to Set Microsoft SQL Database Owner

$owner='CAP\SQL Admins' $databaseName='TestDb' $sqlServer=$env:computername function setDbOwner{ param( $principle=$env:USERDOMAIN+'\Domain Admins', $databaseName='TestDB', $sqlServer ) function includeSqlTools{ $ErrorActionPreference='stop'…