Migration Toolkit facilitates migration from a SQL Server database to a PostgreSQL or Advanced Server database. Migration Toolkit supports migration of the following object definitions:
• Migration Toolkit reads connection specifications for the source database from the toolkit.properties file. The connection information must include:If you are connecting to a SQL Server database, SRC_DB_URL takes the form of a JTDS URL. For example:jdbc:jtds:sqlserver://server[:port]/database_idThe protocol is always jdbc.The server type is always sqlserver.SRC_DB_USER should specify the name of a privileged SQL Server user.SRC_DB_PASSWORD must contain the password of the specified user.