The best open source tool I have seen for this task! Great work! I love how you can set different options in the configuration file (e.g. naming of columns) and it just works!
@isapir
5 жыл бұрын
Thank you, Andreas! It's great to get such feedback :)
@andreasegger7571
5 жыл бұрын
@@isapir you are welcome :)
@techsapphire
5 жыл бұрын
Hi I am getting this error Exception in thread "main" java.lang.IllegalArgumentException: Config file not found at D:\New folder\Migrate2Postgres-1.0.0-SNAPSHOT-dist\Migrate2Postgres.conf and not as a resource at /templates/Migrate2Postgres.conf.conf
@techsapphire
5 жыл бұрын
java -Dconnections.mssql.user=readonly -Dconnections.mssql.password=secret -cp "lib/*" net.twentyonesolutions.m2pg.PgMigrator MsSqlAWT2Postgres.conf Migrate2Postgres Copyright (C) 2018 Igal Sapir This program comes with ABSOLUTELY NO WARRANTY; This is free software, and you are welcome to redistribute it under certain conditions; See www.gnu.org/licenses/gpl-3.0.txt for details Available at github.com/isapir/Migrate2Postgres Exception in thread "main" java.lang.IllegalArgumentException: Config file not found at D:\New folder\Migrate2Postgres-1.0.0-SNAPSHOT-dist\Migrate2Postgres.conf and not as a resource at /templates/Migrate2Postgres.conf.conf at net.twentyonesolutions.m2pg.Config.readConfigFile(Config.java:339) at net.twentyonesolutions.m2pg.Config.fromFile(Config.java:302) at net.twentyonesolutions.m2pg.PgMigrator.main(PgMigrator.java:70)
@chiemezieukaumunna5007
4 жыл бұрын
@@techsapphire I got this same error< Did u ever resolve it ?
@mariusradu184
2 жыл бұрын
I ran the application but apparently when it creates the tables it does not know how to add a foreign key. it's that correct? or the app should know how to handle the foreign keys?
@talipozturk3072
3 жыл бұрын
Hi isapir. It is good job. Thanks. but what do you think about indexes and constrains on table? It will be better if they are created.
@kidsfightin9495
5 жыл бұрын
Thank you for the amazing tool Sir! But I have a few questions regarding the tool. How should I tweak the connection string to migrate from named sql server instance and is it not necessary to incorporate the user name and password both for SQL SERVER and Postgresql connection strings?
@hemalkapadia3829
4 жыл бұрын
This is one of the best tool i have seen for migration. btw, do you've a recommendation or surgestion for incremental load post initial migration leveraging your tool set?
@isapir
4 жыл бұрын
Thank you for your feedback. No, incremental updates is a feature that I was thinking to add but never got to it.
@guilhermealves8526
6 жыл бұрын
Man, you save my day! Thanks a lot from Brazil! Great Job, works clean!
@isapir
6 жыл бұрын
Guilherme Alves Great to hear! Thank you for the feedback.
@guilhermealves8526
6 жыл бұрын
@TwentyOneSolutions I made a script to generate pks too, please send your email to me.
@isapir
6 жыл бұрын
Please open an issue on the project page and post it there. Thank you. github.com/isapir/Migrate2Postgres
@qazisaifhussain6562
4 жыл бұрын
@@guilhermealves8526 pls share script to generate pks my email faiz.qazi0532@gmail.com
@Tobiasholmdk
2 жыл бұрын
It does not seem like to tool moves foreign/primary keys, am i using the tool wrong, or is that correct?
@isack6637
5 жыл бұрын
SQL Stored Procedure will convert as functions in PostgreSQL ?
4 жыл бұрын
No! I need a tool too like that but I couldn't find :(
@sudip3322
4 жыл бұрын
Thanks for this very useful utility !
@isapir
4 жыл бұрын
Glad it was helpful!
@blessiousphiri3109
2 ай бұрын
Its great lesson indeed, How can we get this tool?
@isapir
2 ай бұрын
github.com/isapir/Migrate2Postgres/
@mrkamranumer
5 ай бұрын
Nice and wonderful tool
@shivaorganicfarm
6 жыл бұрын
How do I convert sqlserver stored procedure? Do I need a section in Jason configuration file?
@isapir
6 жыл бұрын
Unfortunately it is very difficult to convert a stored procedure from SQL Server into PL/pgSQL, and I don't think that any tool can do that automatically. You will have to do that manually.
@kranthikumarbandela4001
3 жыл бұрын
I am getting the following error when I ran the migrate.bat ddl command. Do I need to install anything before going to this? 'java' is not recognized as an internal or external command, operable program or batch file.
@isapir
3 жыл бұрын
Yes, you need to have a Java Runtime Environment installed with the path to the java executable, e.g. %JAVA_HOME%/jre/bin, on the %PATH%
@kranthikumarbandela4001
3 жыл бұрын
@@isapir Thanks for the response sir. Can you provide me the link of it to download please. Thanks in advance
@isapir
3 жыл бұрын
@@kranthikumarbandela4001 There are different vendors, but you can use the one from www.java.com/en/download/manual.jsp
@heenafatima6288
5 жыл бұрын
How do I convert sqlserver stored procedure to function in postgresql
@beaprostore
6 жыл бұрын
thank you for your project !
@amolwarade5117
3 жыл бұрын
Can you send me sample code to migrate only Data from SQL to PostGress
@amolwarade5117
4 жыл бұрын
Does it help to Migrate Stored Procedure, Function and Views
@isapir
4 жыл бұрын
Unfortunately no. I wouldn't trust any tool that converts T-SQL to PL/pgSQL automatically.
@SalmanAhmadKhwaja
4 жыл бұрын
I have a schema in file and i want to convert it into Postgre DB. Can i run the tool on a file instead of a MS SQL connection and get output using DDL command.
@isapir
4 жыл бұрын
No, but you can easily create a SQL Server Express database from that schema, and then run the DDL command against that database
@danieledelprincipe4224
2 жыл бұрын
thanks thanks thanks
@anoopsharma3268
7 ай бұрын
facing below error after executing migrate.bat ddl Error: Could not find or load main class net.twentyonesolutions.m2pg.PgMigrator Caused by: java.lang.ClassNotFoundException: net.twentyonesolutions.m2pg.PgMigrator
Пікірлер: 43