Welcome to postgresql-to-mssql Discussions!

[sanamhub]

👋 Welcome!

We’re using Discussions as a place to connect with other members of our community. We hope that you:

• Ask questions you’re wondering about.
• Share ideas.
• Engage with other community members.
• Welcome others and are open-minded. Remember that this is a community we
  build together 💪.

To get started, comment below with an introduction of yourself and tell us about what you do with this community.

[Sybrand055]

Good day, I was trying out your program postgresql-to-mssql. I am having problems getting the PostgreSQL connection string right. I am copying the connection string out of postgres but I have no luck. (I add the password where the xxxxx are)


Thanks, will await your reply.

[Sybrand055]

Thanks for you feedback much appreciated, I will try.

[Sybrand055]

Hi @sanamhub I did try the connection string as suggested but it did not work either I will try it on a different DB as well do you know if you need to add connections by adding an entry to the pg_hba.conf? This is just a local install on windows to test but that might be the issue. Will check it later and let you know.

thanks have great day.

I have actually come to realise I am able to connect through PGADMIN so it's not a restriction problem.

[sanamhub]

Hi @Sybrand055, Thanks for digging.

I did try and it's working perfectly, please let me know if you're still unable.

FIY: Get updated code with using .NET 8 by pulling latest changes from main branch.

This is little bit messy for a while, I need to cleanup and release an executable.

Please file and issue if any.

Have a great day!

[Sybrand055]

Thanks for this will test tomorrow.

[Sybrand055]

Hi @sanamhub I was able to run the program without glitches. I had to uninstall my Postgres and reinstall I think there was something wrong with the installation and that was causing my Issues.
Just a suggestion to make this app robust you should consider it to migrate the following as well in your app, stored procedures, functions, packages, views, and triggers.

Thank you so much for your help, and I think this app is a great idea, I will watch out for any future changes you might make to it and good luck,