Last post Jan 15, 2019 04:45 AM by wmec
Jan 12, 2019 04:59 PM|Guhananth|LINK
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.
Jan 12, 2019 05:08 PM|eralper|LINK
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
Jan 14, 2019 09:24 AM|Wei Zhang|LINK
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 :
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.
Click the Migrate button. The "Microsoft SQL Server Configuration" dialog opens.
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.
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.
Jan 15, 2019 04:45 AM|wmec|LINK
You can dynamically create "insert statement" (compatible to SQL server), within your Postgrace software. Then directly apply the statements in SQL server.