The errors occur when the icons in “net/sf/jailer/ui/resource” are not on the classpath. Are you trying to build the tool yourself? If so, please make sure they are.
Error
Thanks for the answer! All the best, Ivan
The extraction model is created manually. After all, this is the means of determining exactly which data you want to extract. The exports are then carried out using this extraction model. Best regards, Ralf
Hello! We are trying to have an automated Job that would connect to a DB, export a subset of the data based on some conditions and limits, and then import it into a test DB for integration testing. I saw a similar question asked https://sourceforge.net/p/jailer/discussion/700499/thread/af0d8e6984/, but I wasn't sure I understood fully, so if you can possibly clarify - is there a way to automatically create an extraction model (.jm file) through the CLI with some parameters passed in like with the...
Hello! We are trying to have an automated Job that would connect to a DB, export a subset of the data based on some conditions and limits, and then import it into a test DB for integration testing. I saw a similar question asked https://sourceforge.net/p/jailer/discussion/700499/thread/af0d8e6984/, but I wasn't sure I understood fully, so if you can possibly clarify - is there a way to automatically create an extraction model (.jm file) through the CLI with some parameters passed in like with the...
Fixed in 16.9.2
Fix row counter sql generation
Fix in 16.9.2
Thank you very much.
commit cee86d6f0ae16b56a2c32e48e22c110a8727ac7b Author: Jean-François Veillette <jveillette@apple.com> Date: Wed Oct 1 17:15:59 2025 -0400 Fix row couter sql. diff --git a/src/main/gui/net/sf/jailer/ui/databrowser/RowCounter.java b/src/main/gui/net/sf/jailer/ui/databrowser/RowCounter.java index bd9c3089e..b8b081f46 100644 --- a/src/main/gui/net/sf/jailer/ui/databrowser/RowCounter.java +++ b/src/main/gui/net/sf/jailer/ui/databrowser/RowCounter.java @@ -251,7 +251,7 @@ public class RowCounter { if...
Fix row counter sql generation
"Order By" in Data Browser GUI
The user has rigths for all three schemas because we can see under SSMS
Allocating more memory will most likely not solve the problem. Jailer expects the statements in the file to be imported to be separated by a semicolon (‘;’, at the end of the line). If this is not the case, the entire file content is treated as a single statement, which may lead to memory problems.
you must first analyze the schema. you can also do this in the navigation view.
SQL SERVER impossible to export subset table
SQL Server java error during import
no idea, i'm not a mssql expert. You probably need a mssql user/login that has rights for all three schemas.
There is no such script feature. Such a script would have to be executed before the export. However, it is better to use filters for applications such as the one you mentioned. Among other things, this does not permanently modify the source data.
SQL Server object invisible
The goal of the update script is for example to anonymize the email column of the one table during the export AR DBA
What would be the purpose of this update script, or what should it do?
update script on export processus
Finally I tested also with : lib\sqljdbc_12.10.1.0_fra\sqljdbc_12.10\fra\jars\mssql-jdbc-12.10.1.jre11.jar but it's not working : "Cannot open database xxx requested by the login. The login failed". It's strange that it's working when the database is master
Hi, I already use the last version of JDBC : lib\mssql-jdbc-12.2.0.jre8.jar but it's not working
what exactly did you try to import? the import tool expects the input file to consist of individual SQL statements separated by “,”.
MariaDB import full .gz
the communication between jailer and the mssql database is controlled and managed by the mssql-jdbc driver. if you have problems with this, please contact the people responsible for the driver. you can find them here: https://github.com/microsoft/mssql-jdbc
Hi, Would you help me to fix it please ? Best regards AR DBA
Hi, There is something strange, On SQL Server 2019 It works on some instances, but not on others. I don't find the root cause. Would you help me to fix it please ? A R DBA
Thanks for your response. A R DBA
MongoDB is not an RDBMS, so it is not
IMPORT FULL mysql, sql server database