locked
Export Postgrace data to sql server 2018 RRS feed

  • Question

  • User-148788041 posted

    Hi

    I am using Postgrace software. I need to export Postgrace data to sql server 2018 by either command or stored procedure or using some other. Need help.

    Regards

    Anand

    Saturday, January 12, 2019 4:59 PM

All replies

  • User-595703101 posted

    Hello Anand,

    Do you mean Postgre database?

    Is so, you can connect from SQL Server to your Postgre database and import the data in your Postgre database

    Please refer to following article https://docs.microsoft.com/en-us/sql/integration-services/import-export-data/connect-to-a-postgresql-data-source-sql-server-import-and-export-wizard?view=sql-server-2017

    Saturday, January 12, 2019 5:08 PM
  • User-1174608757 posted

    Hi Guhananth,

    According to your description,I suggest you to use dbconfig to realize your requirement.The DBConfig tool allows users to change the user account, password, and the database name for the Control Manager database.You could follow the steps :

    1. Launch the dbconfig tool (the default location is C:\Program Files (x86)\Ipswitch\WS_FTP Server\WS_FTP Server\Utilities\dbconfig.exe). The "PostgreSQL Configuration" dialog opens.

    2. Click the Migrate button. The "Microsoft SQL Server Configuration" dialog opens.

    3. Enter the information for your SQL Server Configuration. Enter the Server Name, Port, Username, and Password in the appropriate fields.
      Note: The username must be the Microsoft SQL Server SA account (this is usually just the letters "sa") for the migration to be successful. After the migration is successful, this user can be changed to a dbowner.

    4. Click OK. The "Migrating from PostgreSQL to MS SQL Server" dialog opens. This dialog displays entries from the install log file, indicating migration progress. If the log indicates that all operations were successful, the MS SQL Server migration is complete. The migration application will restart all Ipswitch services including, but not limited to, WS_FTP Server, SSH Server, and Ipswitch Notification services.

    Here is the link I hope it can help you. 

    https://community.ipswitch.com/s/article/How-do-I-migrate-from-PostgreSQL-to-Microsoft-SQL

    http://docs.trendmicro.com/en-us/enterprise/control-manager-60/ch_ag_use_tmcm_tools/use_dbconfig.aspx

    Best Regards 

    Wei Zhang

    Monday, January 14, 2019 9:24 AM
  • User364663285 posted

    You can dynamically create "insert statement" (compatible to SQL server), within your Postgrace software. Then directly apply the statements in SQL server.

    Tuesday, January 15, 2019 4:45 AM