Question for developers and DB experts
Quote from dglojnar on May 13, 2019, 8:47 pmI have to migrate complete PostgreSQL database - tables, schemata, data, etc...to Microsoft SQL Server.
I don't have too much knowledge about PostgreSQL nor Microsoft SQL Server, so I have to found an easy and simple way to do this.
Can I do this with Neobook DBPro ?
Is there maybe someone ready to write a plugin for this (we can discussed details in PM)?
Or if someone have solution for that ?
Problem is - I can't use commercial third-party tools for that, just freeware/GPL/OpenSource software..and Neobook.
So, please, any idea, link, solution, with possibilities to implement in Neobook...
Cheers!
I have to migrate complete PostgreSQL database - tables, schemata, data, etc...to Microsoft SQL Server.
I don't have too much knowledge about PostgreSQL nor Microsoft SQL Server, so I have to found an easy and simple way to do this.
Can I do this with Neobook DBPro ?
Is there maybe someone ready to write a plugin for this (we can discussed details in PM)?
Or if someone have solution for that ?
Problem is - I can't use commercial third-party tools for that, just freeware/GPL/OpenSource software..and Neobook.
So, please, any idea, link, solution, with possibilities to implement in Neobook...
Cheers!
Quote from HPW on May 13, 2019, 10:05 pmHello,
Do you have ODBC-Driver Access to both databases?
Then you could use DbPro to access the data from the old database to move to the new one.
Not easy, but with good knowledge about the SQL for both databases, it might be possible.
Just an idea what I would try. I have no experience with Postgre or SQL-Server. (only Oracle/Access db)
Regards
Hello,
Do you have ODBC-Driver Access to both databases?
Then you could use DbPro to access the data from the old database to move to the new one.
Not easy, but with good knowledge about the SQL for both databases, it might be possible.
Just an idea what I would try. I have no experience with Postgre or SQL-Server. (only Oracle/Access db)
Regards
Quote from dglojnar on May 13, 2019, 10:23 pmQuote from HPW on May 13, 2019, 10:05 pmHello,
Do you have ODBC-Driver Access to both databases?
Then you could use DbPro to access the data from the old database to move to the new one.
Not easy, but with good knowledge about the SQL for both databases, it might be possible.
Just an idea what I would try. I have no experience with Postgre or SQL-Server. (only Oracle/Access db)
Regards
Yeah, I think too, must check SQL syntax for both DB...funny night:-)
Thank you, Hans, for quick response and advice:-)
Cheers!
Quote from HPW on May 13, 2019, 10:05 pmHello,
Do you have ODBC-Driver Access to both databases?
Then you could use DbPro to access the data from the old database to move to the new one.
Not easy, but with good knowledge about the SQL for both databases, it might be possible.
Just an idea what I would try. I have no experience with Postgre or SQL-Server. (only Oracle/Access db)
Regards
Yeah, I think too, must check SQL syntax for both DB...funny night:-)
Thank you, Hans, for quick response and advice:-)
Cheers!