Comparing 2 SQLite databases - Stack Overflow (https://cdn.sstatic.net/Sites/stackoverflow/Img/favicon.ico?v=ec617d715196) (https://cdn.sstatic.net/Sites/stackoverflow/Img/apple-touch-icon.png?v=c78bd457575a) (https://cdn.sstatic.net/Sites/stackoverflow/Img/apple-touch-icon.png?v=c78bd457575a) (Stack Overflow) (/opensearch.xml) (https://stackoverflow.com/questions/37195819/comparing-2-sqlite-databases) (https://cdn.sstatic.net/Shared/stacks.css?v=619122b796ae) (https://cdn.sstatic.net/Sites/stackoverflow/primary.css?v=90f1fc95eb69) (Feed for question 'Comparing 2 SQLite databases') (/feeds/question/37195819) (https://cdn.sstatic.net/Shared/Channels/channels.css?v=5981bb1a5bd7)  (https://accounts.google.com/gsi/style)  (site logo) Join Stack Overflow    By clicking “Sign up”, you agree to our (/legal/terms-of-service/public) terms of service and acknowledge you have read our (/legal/privacy-policy) privacy policy .  (ff4fcbca636af5643780aa05a86f0e563b8bc2dc422ecaeccada21e777c0440b) (1) (undefined) (2.0)      Sign up with Google    Sign up with GitHub     OR (ff4fcbca636af5643780aa05a86f0e563b8bc2dc422ecaeccada21e777c0440b) (1) () () () () () () Email   Password (8+ characters (at least 1 letter & 1 number))      Sign up      Already have an account? (/users/login) Log in   X     (ff4fcbca636af5643780aa05a86f0e563b8bc2dc422ecaeccada21e777c0440b) ()     Skip to main content     (https://stackoverflow.com) Stack Overflow  (https://stackoverflow.co/) About  Products   (https://stackoverflow.co/teams/ai/?utm_medium=referral&utm_source=stackoverflow-community&utm_campaign=top-nav-bar&utm_content=overflowai) OverflowAI    (https://stackoverflow.co/teams/?utm_medium=referral&utm_source=stackoverflow-community&utm_campaign=top-nav&utm_content=stack-overflow-for-teams) Stack Overflow for Teams Where developers & technologists share private knowledge with coworkers   (https://stackoverflow.co/advertising/?utm_medium=referral&utm_source=stackoverflow-community&utm_campaign=top-nav&utm_content=stack-overflow-advertising) Advertising & Talent Reach devs & technologists worldwide about your product, service or employer brand   (https://stackoverflow.co/teams/ai/?utm_medium=referral&utm_source=stackoverflow-community&utm_campaign=top-nav&utm_content=overflow-ai) OverflowAI GenAI features for Teams   (https://stackoverflow.co/api-solutions/?utm_medium=referral&utm_source=stackoverflow-community&utm_campaign=top-nav&utm_content=overflow-api) OverflowAPI Train & fine-tune LLMs   (https://stackoverflow.co/labs/?utm_medium=referral&utm_source=stackoverflow-community&utm_campaign=top-nav&utm_content=labs) Labs The future of collective knowledge sharing   (https://stackoverflow.co/?utm_medium=referral&utm_source=stackoverflow-community&utm_campaign=top-nav&utm_content=about-the-company) About the company (https://stackoverflow.blog/?utm_medium=referral&utm_source=stackoverflow-community&utm_campaign=top-nav&utm_content=blog) Visit the blog    (Search…) ()    Loading…          (https://stackoverflow.com) current community        (https://stackoverflow.com) (Stack Overflow)  Stack Overflow    (https://stackoverflow.com/help) help (https://chat.stackoverflow.com/?tab=site&host=stackoverflow.com) chat     (https://meta.stackoverflow.com) (Meta Stack Overflow)  Meta Stack Overflow      your communities   (https://stackoverflow.com/users/signup?ssrc=site_switcher&returnurl=https%3a%2f%2fstackoverflow.com%2fquestions%2f37195819%2fcomparing-2-sqlite-databases) Sign up or (https://stackoverflow.com/users/login?ssrc=site_switcher&returnurl=https%3a%2f%2fstackoverflow.com%2fquestions%2f37195819%2fcomparing-2-sqlite-databases) log in to customize your list.   (https://stackexchange.com/sites) more stack exchange communities  (https://stackoverflow.blog) company blog      (Click to show search)     (https://stackoverflow.com/users/login?ssrc=head&returnurl=https%3a%2f%2fstackoverflow.com%2fquestions%2f37195819%2fcomparing-2-sqlite-databases) Log in  (https://stackoverflow.com/users/signup?ssrc=head&returnurl=https%3a%2f%2fstackoverflow.com%2fquestions%2f37195819%2fcomparing-2-sqlite-databases) Sign up        Just browsing Stack Overflow? Help us improve your experience.  (https://research.rallyuxr.com/stack_overflow/lp/sobanner?channel=app) Sign up for research  (dismiss)      Let's set up your homepage Select a few topics you're interested in:   python  javascript  c#  reactjs  java  android  html  flutter  c++  node.js  typescript  css  r  php  angular  next.js  spring-boot  machine-learning  sql  excel  ios  azure  docker   Or search from our full list:    (Search)        javascript  python  java  c#  php  android  html  jquery  c++  css  ios  sql  mysql  r  reactjs  node.js  arrays  c  asp.net  json  python-3.x  .net  ruby-on-rails  sql-server  swift  django  angular  objective-c  excel  pandas  angularjs  regex  typescript  ruby  linux  ajax  iphone  vba  xml  laravel  spring  asp.net-mvc  database  wordpress  string  flutter  postgresql  mongodb  wpf  windows  amazon-web-services  xcode  bash  git  oracle-database  spring-boot  dataframe  firebase  azure  list  multithreading  vb.net  docker  react-native  eclipse  algorithm  powershell  macos  visual-studio  numpy  image  forms  scala  function  vue.js  twitter-bootstrap  performance  selenium  winforms  kotlin  loops  express  hibernate  dart  sqlite  matlab  python-2.7  shell  rest  apache  api  entity-framework  android-studio  csv  maven  linq  qt  dictionary  unit-testing  facebook  asp.net-core  tensorflow  apache-spark  file  swing  class  unity-game-engine  sorting  date  authentication  symfony  go  opencv  t-sql  .htaccess  matplotlib  google-chrome  for-loop  datetime  codeigniter  http  perl  validation  sockets  google-maps  object  uitableview  xaml  oop  if-statement  cordova  visual-studio-code  ubuntu  web-services  email  android-layout  github  spring-mvc  elasticsearch  kubernetes  selenium-webdriver  ms-access  user-interface  parsing  ggplot2  pointers  c++11  security  machine-learning  google-sheets  flask  ruby-on-rails-3  nginx  google-apps-script  templates  variables  exception  sql-server-2008  gradle  debugging  tkinter  listview  delphi  jpa  asynchronous  pdf  web-scraping  jsp  haskell  ssl  amazon-s3  google-cloud-platform  jenkins  xamarin  testing  wcf  npm  batch-file  generics  ionic-framework  network-programming  unix  recursion  google-app-engine  mongoose  visual-studio-2010  .net-core  android-fragments  assembly  animation  math  session  hadoop  svg  next.js  intellij-idea  curl  django-models  join  laravel-5  heroku  url  winapi  http-redirect  tomcat  google-cloud-firestore  web  rust  inheritance  webpack  keras  image-processing  asp.net-mvc-4  gcc  logging  dom  matrix  pyspark  actionscript-3  swiftui  button  post  firebase-realtime-database  optimization  jquery-ui  cocoa  iis  xpath  d3.js  firefox  internet-explorer  javafx  xslt  caching  select  asp.net-mvc-3  opengl  events  asp.net-web-api  plot  dplyr  magento  encryption  search  stored-procedures  amazon-ec2  ruby-on-rails-4  memory  canvas  audio  multidimensional-array  jsf  random  redux  vector  cookies  facebook-graph-api  input  flash  xamarin.forms  arraylist  indexing  ipad  cocoa-touch  data-structures  video  model-view-controller  apache-kafka  serialization  jdbc  woocommerce  routes  razor  awk  servlets  mod-rewrite  azure-devops  beautifulsoup  iframe  filter  docker-compose  excel-formula  aws-lambda  design-patterns  django-rest-framework  text  visual-c++  cakephp  mobile  android-intent  react-hooks  struct  methods  groovy  mvvm  ssh  lambda  checkbox  ecmascript-6  google-chrome-extension  time  grails  installation  sharepoint  shiny  spring-security  cmake  jakarta-ee  android-recyclerview  core-data  plsql  meteor  types  android-activity  sed  bootstrap-4  websocket  activerecord  graph  replace  scikit-learn  file-upload  group-by  vim  junit  boost  deep-learning  import  sass  memory-management  error-handling  async-await  dynamic  eloquent  soap  silverlight  charts  dependency-injection  apache-spark-sql  layout  deployment  browser  gridview  svn  while-loop  google-bigquery  vuejs2  highcharts  ffmpeg  dll  view  foreach  c#-4.0  plugins  redis  makefile  reporting-services  jupyter-notebook  server  merge  https  unicode  reflection  google-maps-api-3  twitter  extjs  oauth-2.0  axios  pytorch  terminal  split  mysqli  pip  django-views  cmd  encoding  netbeans  database-design  collections  hash  automation  ember.js  data-binding  tcp  build  pdo  sqlalchemy  apache-flex  command-line  printing  spring-data-jpa  entity-framework-core  concurrency  java-8  react-redux  jestjs  service  html-table  neo4j  ansible  lua  parameters  material-ui  visual-studio-2012  module  enums  promise  flexbox  outlook  webview  web-applications  firebase-authentication  uwp  jquery-mobile  utf-8  datatable  python-requests  drop-down-menu  scroll  colors  parallel-processing  hive  tfs  scipy  count  syntax  ms-word  twitter-bootstrap-3  ssis  google-analytics  fonts  three.js  graphql  constructor  file-io  rxjs  paypal  powerbi  discord  cassandra  socket.io  graphics  gwt  compiler-errors  nlp  react-router  backbone.js  url-rewriting  solr  datatables  memory-leaks  datagridview  oauth  oracle11g  drupal  zend-framework  neural-network  knockout.js  terraform  django-forms  interface  triggers  google-api  casting  angular-material  linked-list  jmeter  proxy  path  timer  django-templates  directory  orm  parse-platform  visual-studio-2015  cron  windows-phone-7  arduino  push-notification  conditional-statements  primefaces  functional-programming  pagination  model  jar  xamarin.android  hyperlink  uiview  visual-studio-2013  vbscript  gitlab  google-cloud-functions  azure-active-directory  download  jwt  swift3  sql-server-2005  process  rspec  configuration  properties  callback  combobox  pygame  windows-phone-8  safari  permissions  scrapy  linux-kernel  scripting  raspberry-pi  emacs  clojure  scope  io  x86  mongodb-query  angularjs-directive  nhibernate  responsive-design  compilation  request  dns  bluetooth  3d  binding  reference  discord.js  architecture  playframework  version-control  pyqt  doctrine-orm  package  pycharm  azure-functions  expo  get  sql-server-2012  rubygems  f#  autocomplete  datepicker  kendo-ui  openssl  tree  jackson  yii  controller  xamarin.ios  grep  nested  static  statistics  datagrid  null  active-directory  dockerfile  transactions  uiviewcontroller  phpmyadmin  webforms  discord.py  notifications  sas  computer-vision  duplicates  youtube  mocking  nullpointerexception  menu  yaml  bitmap  sum  asp.net-mvc-5  visual-studio-2008  electron  jsf-2  yii2  time-series  android-listview  stream  stl  css-selectors  floating-point  ant  cryptography  character-encoding  hashmap  msbuild  sdk  blazor  selenium-chromedriver  jboss  google-drive-api  asp.net-core-mvc  frontend  joomla  devise  navigation  anaconda  cors  background  binary  camera  pyqt5  multiprocessing  linq-to-sql  cuda  iterator  onclick  ios7  mariadb  plotly  rabbitmq  android-asynctask  laravel-4  tabs  insert  uicollectionview  amazon-dynamodb  environment-variables  microsoft-graph-api  linker  console  coldfusion  upload  xsd  android-jetpack-compose  ftp  continuous-integration  textview  opengl-es  operating-system  localization  xml-parsing  mockito  formatting  kivy  json.net  macros  vuejs3  type-conversion  data.table  timestamp  calendar  integer  segmentation-fault  android-ndk  drag-and-drop  prolog  char  crash  jasmine  automated-tests  dependencies  itext  header  android-gradle-plugin  firebase-cloud-messaging  geometry  sprite-kit  mfc  fortran  nosql  attributes  nuxt.js  format  nestjs  jquery-plugins  odoo  db2  leaflet  jenkins-pipeline  event-handling  flutter-layout  postman  annotations  azure-pipelines  julia  keyboard  textbox  arm  visual-studio-2017  gulp  libgdx  xampp  synchronization  crystal-reports  stripe-payments  dom-events  timezone  wso2  sequelize.js  android-emulator  swagger  azure-web-app-service  uiscrollview  uikit  aggregation-framework  namespaces  jvm  chart.js  com  webdriver  centos  geolocation  subprocess  google-sheets-formula  html5-canvas  widget  dialog  garbage-collection  numbers  concatenation  sql-update  mapreduce  qml  windows-10  set  ionic2  tuples  smtp  rotation  android-edittext  modal-dialog  http-headers  snowflake-cloud-data-platform  spring-data  doctrine  radio-button  nuget  grid  sonarqube  xmlhttprequest  lucene  java-stream  listbox  internationalization  components  switch-statement  initialization  google-play  apache-camel  boolean  serial-port  ldap  ios5  youtube-api  return  eclipse-plugin  pivot  latex  gdb  frameworks  tags  containers  dataset  asp-classic  foreign-keys  subquery  label  uinavigationcontroller  copy  delegates  google-cloud-storage  struts2  github-actions  migration  base64  protractor  c++17  sql-server-2008-r2  find  queue  uibutton  arguments  append  composer-php  jaxb  embedded  zip  stack  cucumber  autolayout  ide  entity-framework-6  popup  windows-7  iteration  r-markdown  vb6  airflow  ssl-certificate  gmail  jqgrid  hover  android-viewpager  passwords  udp         Next You’ll be prompted to create an account to view your personalized homepage.   X      (/)   Home    (/questions)   Questions    (/tags)    Tags     (/users)   Users    (https://stackoverflow.com/jobs/companies?so_medium=stackoverflow&so_source=SiteNav)   Companies    Labs      (/jobs?source=so-left-nav)   Jobs    (/beta/discussions)   Discussions    Collectives       Communities for your favorite technologies. (/collectives-all) Explore all Collectives     Teams () Ask questions, find answers and collaborate at work with Stack Overflow for Teams.  (https://stackoverflowteams.com/teams/create/free/?utm_medium=referral&utm_source=stackoverflow-community&utm_campaign=side-bar&utm_content=explore-teams) Try Teams for free (https://stackoverflow.co/teams/?utm_medium=referral&utm_source=stackoverflow-community&utm_campaign=side-bar&utm_content=explore-teams) Explore Teams   Teams      Ask questions, find answers and collaborate at work with Stack Overflow for Teams. (https://stackoverflow.co/teams/?utm_medium=referral&utm_source=stackoverflow-community&utm_campaign=side-bar&utm_content=explore-teams-compact) Explore Teams          Collectives™ on Stack Overflow Find centralized, trusted content and collaborate around the technologies you use most. (/collectives) Learn more about Collectives     Teams  Q&A for work Connect and share knowledge within a single location that is structured and easy to search. (https://stackoverflow.co/teams/) Learn more about Teams             Get early access and see previews of new features. (https://stackoverflow.co/labs/)   Learn more about Labs   (https://cdn.sstatic.net/Sites/stackoverflow/Img/apple-touch-icon.png?v=c78bd457575a) (/questions/37195819/comparing-2-sqlite-databases) Comparing 2 SQLite databases  (/questions/ask) Ask Question     (2016-05-12 19:27:09Z) Asked 8 years, 7 months ago  Modified (?lastactivity) (2023-02-07 15:55:09Z) 1 year, 10 months ago  (Viewed 9,149 times) Viewed 9k times         This question shows research effort; it is useful and clear  (70:3:31e,16:f2d1ed509a18c136,10:1733615190,16:5c6277fa5965c039,8:37195819,9fb1b256900bc81463e9a94c88d0f98452a7d895b47b8debaa8855b7ab143323) 5  (This question does not show any research effort; it is unclear or not useful)    (70:3:31e,16:9098dd587975a875,10:1733615190,16:992e78c4f98f0b80,8:37195819,e1d9c3ee95c8b7442c98d7658cf77fe56bc992f3dcc32a21409ccc8290a8547d)      Save this question.  (/posts/37195819/timeline)    Show activity on this post.    I would like to compare 2 SQLite databases in order to check whether it needs to be updated on the client computer. I am not really sure how I should do this. 
Whether I should make an internal version ID or compare the file size (which probally is not a good idea because I think the file size doesn't change anytime I edit the database). Does anybody know a good way to do what I need to do? Thank you!  (/questions/tagged/sqlite) (show questions tagged 'sqlite') sqlite      (/q/37195819) (Short permalink to this question) Share  Share a link to this question     Copy link (https://creativecommons.org/licenses/by-sa/3.0/) (The current license for this post: CC BY-SA 3.0) CC BY-SA 3.0     (/posts/37195819/edit) () Improve this question  Follow (70:3:31e,16:1e91defe78c37868,10:1733615190,16:3c69d7e9093cfb0a,8:37195819,3e6e193fc0bdb742de8013fb8e465301f0d5a98cac0617963563165cf284f0a3)  Follow this question to receive notifications       asked (2016-05-12 19:27:09Z) May 12, 2016 at 19:27   (/users/5734977/maiken-roskilde) (Maiken Roskilde's user avatar)    (/users/5734977/maiken-roskilde) Maiken Roskilde Maiken Roskilde (reputation score) 467 (4 silver badges)  4  4 silver badges (15 bronze badges)  15  15 bronze badges        2   Is this a "one off" type of comparison, or something you need to do regularly? – (/users/2836621/mark-setchell) (206,417 reputation) Mark Setchell  Commented (2016-05-12 20:45:08Z, License: CC BY-SA 3.0) May 12, 2016 at 20:45        Can there be changes made on both computers? If yes, you always have to compare all the contents. – (/users/11654/cl) (179,562 reputation) CL.  Commented (2016-05-13 07:51:20Z, License: CC BY-SA 3.0) May 13, 2016 at 7:51   (this comment was edited 1 time)          (Use comments to ask for more information or suggest improvements. Avoid answering questions in comments.) Add a comment |  (Expand to show all comments on this post)          3 Answers 3   Sorted by:  (/questions/37195819/comparing-2-sqlite-databases?answertab=scoredesc#tab-top) Reset to default   (scoredesc) Highest score (default)  (trending) Trending (recent votes count more)  (modifieddesc) Date modified (newest first)  (createdasc) Date created (oldest first)            This answer is useful  (70:3:31e,16:cfbc0040dc7f4bb1,10:1733615190,16:a9f479a85b11e319,8:37196549,b81489b0392b12e5784e18409044bf758eb415da9eef91477c4d8be707044a93) 8  (This answer is not useful)    (70:3:31e,16:2b6de449128da3bf,10:1733615190,16:31126d717387c3b1,8:37196549,cf7bb170204cb94071541b4789ca65037fbca4ba073952a5c7bbdb884da72374)      Save this answer.  (Loading when this answer was accepted…)     (/posts/37196549/timeline)    Show activity on this post.    You might try dumping each SQLite database, using SQLite's .dump command: $ sqlite3 / path/ to / database1 .dump > database1.sql
$ sqlite3 / path/ to / database2 .dump > database2.sql   And then comparing the generated files.  If your two databases are quite similar, a simple diff might work to show any differences, e.g. : $ diff - u database1.sql database2.sql   Hope this helps!   (/a/37196549) (Short permalink to this answer) Share  Share a link to this answer     Copy link (https://creativecommons.org/licenses/by-sa/3.0/) (The current license for this post: CC BY-SA 3.0) CC BY-SA 3.0     (/posts/37196549/edit) () Improve this answer  Follow (70:3:31e,16:980f44d2fffbd354,10:1733615190,16:311f63e4fa12959e,8:37196549,acc70fa03c8488cc190d7f50754eb5854d0552c6ef2b14e8c877e99a89705e4c)  Follow this answer to receive notifications       answered (2016-05-12 20:11:43Z) May 12, 2016 at 20:11   (/users/4072843/castaglia) (Castaglia's user avatar)    (/users/4072843/castaglia) Castaglia Castaglia (reputation score) 3,079 (5 gold badges)  5  5 gold badges (30 silver badges)  30  30 silver badges (50 bronze badges)  50  50 bronze badges        3   I never did that. How do you compare the dump files? By file length? – (/users/5734977/maiken-roskilde) (467 reputation) Maiken Roskilde  Commented (2016-05-12 20:31:34Z, License: CC BY-SA 3.0) May 12, 2016 at 20:31      (number of 'useful comment' votes received) 1   The dump files are textual; you could compare them by length for a simple comparison, or use the diff command to see what the specific differences might be.  If nothing else, just looking through those dump files might be useful/helpful. – (/users/4072843/castaglia) (3,079 reputation) Castaglia  Commented (2016-05-12 20:43:47Z, License: CC BY-SA 3.0) May 12, 2016 at 20:43        Thanks a lot. You saved a lot of time. – (/users/3057215/prasad) (139 reputation) Prasad  Commented (2023-04-26 15:38:22Z, License: CC BY-SA 4.0) Apr 26, 2023 at 15:38        (Use comments to ask for more information or suggest improvements. Avoid comments like “+1” or “thanks”.) Add a comment |  (Expand to show all comments on this post)             This answer is useful  (70:3:31e,16:22d31401382f009e,10:1733615190,16:ddb42ad568d4ff97,8:65294705,f865fc90b3265547dfb36a799b6acd61522104b8e56aefa536be951ab1569446) 7  (This answer is not useful)    (70:3:31e,16:b62ea3f47ab7bf43,10:1733615190,16:a580f367f08d34ef,8:65294705,6a550d84f0d249b3c053e296ad48a5ffb50d4575ceaa6a6249b21514df46b5f5)      Save this answer.  (Loading when this answer was accepted…)     (/posts/65294705/timeline)    Show activity on this post.    A bit late for original question but may be will be helpful for others. On Windows you can use (https://ksdbmerge.tools/sqlite-diff-merge-overview.html) KS DB Merge Tools for SQLite . I am the author of this tool. Compares both DB object definitions and data. Free version available and pretty functional for diff/compare needs. EDIT 2022-06-29
I've made the web wasm-based diff-only version of this tool: (https://ksdbmerge.tools/for-sqlite-online) https://ksdbmerge.tools/for-sqlite-online  EDIT 2022-02-21:
Accepted .dump answer is good for many cases, but it can report false-positive changes. Here is dump result for (https://stackoverflow.com/q/70460111) this question: (https://i.sstatic.net/hRcjp.png) (enter image description here)  Both columns are part of the primary key, so from the point of data model data is the same but dumps are different. My tool is using primary key to compare data so no changes would be reported for such case.   (/a/65294705) (Short permalink to this answer) Share  Share a link to this answer     Copy link (https://creativecommons.org/licenses/by-sa/4.0/) (The current license for this post: CC BY-SA 4.0) CC BY-SA 4.0     (/posts/65294705/edit) () Improve this answer  Follow (70:3:31e,16:9f76e4f0ca85b39a,10:1733615190,16:f83f16592914c367,8:65294705,3a8fe51500c02102e19a02fd7aa4784bfee68cddba4ceb6580c2d1b819dbf451)  Follow this answer to receive notifications       (/posts/65294705/revisions) (show all edits to this post) edited (2023-02-07 15:55:09Z) Feb 7, 2023 at 15:55         answered (2020-12-14 18:45:06Z) Dec 14, 2020 at 18:45   (/users/282694/sarh) (sarh's user avatar)    (/users/282694/sarh) sarh sarh (reputation score) 6,577 (4 gold badges)  4  4 gold badges (26 silver badges)  26  26 silver badges (34 bronze badges)  34  34 bronze badges        1 (number of 'useful comment' votes received) 1   Didn't try it, but the website looks promising. Thanks for providing a free version - upvote deserved. – (/users/3239842/binarus) (4,345 reputation) Binarus  Commented (2021-01-31 15:23:58Z, License: CC BY-SA 4.0) Jan 31, 2021 at 15:23   (this comment was edited 1 time)          (Use comments to ask for more information or suggest improvements. Avoid comments like “+1” or “thanks”.) Add a comment |  (Expand to show all comments on this post)          This answer is useful  (70:3:31e,16:92700b7735dec7ba,10:1733615190,16:10cd694dfcc7fd2d,8:65256833,04c0fa5eeeb566781c1a7f9be5189258a8ad6d9a89f5f88446911c8e7ca03c9d) 3  (This answer is not useful)    (70:3:31e,16:fd39782a7fda4a3f,10:1733615190,16:8e0e552f436a9c92,8:65256833,e847bdcdff8c1bed235c6e80c70c1c7a81d19dc850a7a738e6296d8e00b9bfd0)      Save this answer.  (Loading when this answer was accepted…)     (/posts/65256833/timeline)    Show activity on this post.    You could use (https://sqlite.org/sqldiff.html) sqldiff . On Debian or Debian-based systems (and possibly other Linux systems) it is installed by default when installing sqlite3: apt install sqlite3  On MacOS, it can be installed with Homebrew : brew install sqldiff    (/a/65256833) (Short permalink to this answer) Share  Share a link to this answer     Copy link (https://creativecommons.org/licenses/by-sa/4.0/) (The current license for this post: CC BY-SA 4.0) CC BY-SA 4.0     (/posts/65256833/edit) () Improve this answer  Follow (70:3:31e,16:862ab5b97e28d58d,10:1733615190,16:9cc80a734bd8f78e,8:65256833,77b41d934dcb5c606ea0221acabf4e50373b311a61d565893fc945524011f7e6)  Follow this answer to receive notifications       answered (2020-12-11 18:36:27Z) Dec 11, 2020 at 18:36   (/users/111036/mivk) (mivk's user avatar)    (/users/111036/mivk) mivk mivk (reputation score 14,704) 14.7k (5 gold badges)  5  5 gold badges (83 silver badges)  83  83 silver badges (74 bronze badges)  74  74 bronze badges           (Use comments to ask for more information or suggest improvements. Avoid comments like “+1” or “thanks”.) Add a comment |  (Expand to show all comments on this post)       (37195819) (false) () Your Answer                                 Reminder: Answers generated by artificial intelligence tools are not allowed on Stack Overflow. (/help/gen-ai-policy) Learn more       (true)       Thanks for contributing an answer to Stack Overflow! Please be sure to answer the question . Provide details and share your research!  But avoid … Asking for help, clarification, or responding to other answers. Making statements based on opinion; back them up with references or personal experience.  To learn more, see our (/help/how-to-answer) tips on writing great answers .      Draft saved Draft discarded    (ff4fcbca636af5643780aa05a86f0e563b8bc2dc422ecaeccada21e777c0440b)   Sign up or (/users/login?ssrc=question_page&returnurl=https%3a%2f%2fstackoverflow.com%2fquestions%2f37195819%2fcomparing-2-sqlite-databases%23new-answer) log in       Sign up using Google     Sign up using Email and Password   (false) (false) Submit Post as a guest Name () ()    Email Required, but never shown   () ()       Post as a guest Name () ()     Email Required, but never shown   () ()       Post Your Answer  Discard  By clicking “Post Your Answer”, you agree to our (https://stackoverflow.com/legal/terms-of-service/public) terms of service and acknowledge you have read our (https://stackoverflow.com/legal/privacy-policy) privacy policy .(1)     Not the answer you're looking for? Browse other questions tagged (/questions/tagged/sqlite) (show questions tagged 'sqlite') sqlite   or (/questions/ask) ask your own question .     The Overflow Blog      (https://stackoverflow.blog/2024/12/05/four-approaches-to-creating-a-specialized-llm/?cb=1) Four approaches to creating a specialized LLM       (https://stackoverflow.blog/2024/12/06/from-bugs-to-performance-to-perfection-pushing-code-quality-in-mobile-apps/?cb=1) From bugs to performance to perfection: pushing code quality in mobile apps   Featured on Meta  (Meta Stack Exchange)   (https://meta.stackexchange.com/questions/404231/we-re-finally-going-to-the-cloud?cb=1) We’re (finally!) going to the cloud!   (Meta Stack Exchange)   (https://meta.stackexchange.com/questions/404724/updates-to-the-upcoming-community-asks-sprint?cb=1) Updates to the upcoming Community Asks Sprint            Linked (https://stackoverflow.com/q/70460111?lq=1) (Question score (upvotes - downvotes)) 1  (https://stackoverflow.com/questions/70460111/show-diff-of-two-sqlite-databases-ignoring-rowid?noredirect=1&lq=1) Show diff of two SQLite databases ignoring rowid    Related (https://stackoverflow.com/q/1711631?rq=1) (Question score (upvotes - downvotes)) 3395  (https://stackoverflow.com/questions/1711631/improve-insert-per-second-performance-of-sqlite?rq=1) Improve INSERT-per-second performance of SQLite  (https://stackoverflow.com/q/1601151?rq=1) (Question score (upvotes - downvotes)) 1126  (https://stackoverflow.com/questions/1601151/how-do-i-check-in-sqlite-whether-a-table-exists?rq=1) How do I check in SQLite whether a table exists?  (https://stackoverflow.com/q/82875?rq=1) (Question score (upvotes - downvotes)) 1416  (https://stackoverflow.com/questions/82875/how-can-i-list-the-tables-in-a-sqlite-database-file-that-was-opened-with-attach?rq=1) How can I list the tables in a SQLite database file that was opened with ATTACH?  (https://stackoverflow.com/q/418898?rq=1) (Question score (upvotes - downvotes)) 629  (https://stackoverflow.com/questions/418898/upsert-not-insert-or-replace?rq=1) UPSERT *not* INSERT or REPLACE  (https://stackoverflow.com/q/6824717?rq=1) (Question score (upvotes - downvotes)) 131  (https://stackoverflow.com/questions/6824717/sqlite-how-do-you-join-tables-from-different-databases?rq=1) SQLite - How do you join tables from different databases?  (https://stackoverflow.com/q/734689?rq=1) (Question score (upvotes - downvotes)) 765  (https://stackoverflow.com/questions/734689/sqlite-primary-key-on-multiple-columns?rq=1) SQLite primary key on multiple columns  (https://stackoverflow.com/q/2493331?rq=1) (Question score (upvotes - downvotes)) 727  (https://stackoverflow.com/questions/2493331/how-can-i-avoid-concurrency-problems-when-using-sqlite-on-android?rq=1) How can I avoid concurrency problems when using SQLite on Android?  (https://stackoverflow.com/q/1609637?rq=1) (Question score (upvotes - downvotes)) 677  (https://stackoverflow.com/questions/1609637/how-to-insert-multiple-rows-in-sqlite?rq=1) How to insert multiple rows in SQLite?  (https://stackoverflow.com/q/35718616?rq=1) (Question score (upvotes - downvotes)) 2  (https://stackoverflow.com/questions/35718616/comparing-two-sqlite-databases-in-c?rq=1) Comparing two SQLite databases in C++    (https://stackexchange.com/questions?tab=hot) Hot Network Questions   (Amateur Radio Stack Exchange)  (https://ham.stackexchange.com/questions/23249/turning-a-microwave-into-a-transceiver) Turning a microwave into a transceiver   (Philosophy Stack Exchange)  (https://philosophy.stackexchange.com/questions/120001/do-you-need-to-know-the-exact-definition-of-a-word-to-correctly-apply-it) Do you need to know the exact definition of a word to correctly apply it?   (Software Engineering Stack Exchange)  (https://softwareengineering.stackexchange.com/questions/455944/when-is-it-acceptable-to-commit-directly-to-main-master) When is it acceptable to commit directly to main/master?   (Home Improvement Stack Exchange)  (https://diy.stackexchange.com/questions/311085/are-uncovered-cord-plugs-safe-to-use-in-the-snow) Are uncovered cord plugs safe to use in the snow?   (MathOverflow)  (https://mathoverflow.net/questions/483687/is-the-set-of-generalized-fermat-triples-computable) Is the set of generalized Fermat triples computable?   (English Language & Usage Stack Exchange)  (https://english.stackexchange.com/questions/627832/word-meaning-to-do-something-without-really-doing-anything) Word meaning "to do something without really doing anything"   (Mathematics Stack Exchange)  (https://math.stackexchange.com/questions/5008404/homeomorphism-between-topological-manifolds-invariance-of-domain) homeomorphism between topological manifolds. Invariance of domain.   (Puzzling Stack Exchange)  (https://puzzling.stackexchange.com/questions/129549/6-sided-cross-burr-puzzle) 6 Sided Cross Burr Puzzle   (Theoretical Computer Science Stack Exchange)  (https://cstheory.stackexchange.com/questions/54899/how-are-theoretical-computer-science-journals-ranked-within-the-community) How are theoretical computer science journals ranked within the community?   (Information Security Stack Exchange)  (https://security.stackexchange.com/questions/279749/of-the-cookies-created-by-other-websites-which-ones-would-the-browser-allow-a-w) of the cookies created by OTHER websites, which ones would the browser allow a website to access?   (Software Engineering Stack Exchange)  (https://softwareengineering.stackexchange.com/questions/455956/testing-for-non-existence-of-a-method-in-api) Testing for non-existence of a method in API   (Blender Stack Exchange)  (https://blender.stackexchange.com/questions/328166/face-selection-issue-in-geometry-nodes-for-odd-grid-x-y-inputs) Face Selection Issue in Geometry Nodes for odd Grid X & Y inputs   (Retrocomputing Stack Exchange)  (https://retrocomputing.stackexchange.com/questions/31009/were-any-full-screen-programs-sold-for-commodore-64-cp-m) Were any full-screen programs sold for Commodore 64 CP/M?   (Quantum Computing Stack Exchange)  (https://quantumcomputing.stackexchange.com/questions/40608/does-the-matrix-representation-of-quantum-gates-depend-on-the-basis) Does the matrix representation of quantum gates depend on the basis?   (Christianity Stack Exchange)  (https://christianity.stackexchange.com/questions/104188/is-there-a-comprehensive-list-of-arguments-for-christian-theism) Is there a comprehensive list of arguments for Christian theism?   (Space Exploration Stack Exchange)  (https://space.stackexchange.com/questions/67454/why-doesnt-spacex-use-solid-rocket-fuel) Why doesn't SpaceX use solid rocket fuel?   (Information Security Stack Exchange)  (https://security.stackexchange.com/questions/279770/oauth2-authorization-code-grant-how-does-redirection-work-for-mobile-applicatio) OAuth2 authorization code grant: how does redirection work for mobile applications?   (Literature Stack Exchange)  (https://literature.stackexchange.com/questions/28285/what-is-the-strife-that-makes-a-city-strong-in-oedipus) What is the "strife" that makes a city strong in "Oedipus"?   (MathOverflow)  (https://mathoverflow.net/questions/483730/how-to-verify-if-sets-satisfying-cardinality-condition-exist) How to verify if sets satisfying cardinality condition exist?   (Space Exploration Stack Exchange)  (https://space.stackexchange.com/questions/67465/every-day-how-much-speed-does-voyager-lose-due-to-the-suns-gravity) Every day, how much speed does Voyager lose due to the sun's gravity?   (Unix & Linux Stack Exchange)  (https://unix.stackexchange.com/questions/787780/why-are-ascii-escape-sequences-for-treated-differently-in-grep-sed-awk) Why are ASCII escape sequences for ' treated differently in grep/sed/awk?   (Travel Stack Exchange)  (https://travel.stackexchange.com/questions/192543/can-you-typically-get-prescriptions-fulfilled-internationally-specifically-ger) Can you typically get prescriptions fulfilled internationally? [Specifically Germany / UK]   (Home Improvement Stack Exchange)  (https://diy.stackexchange.com/questions/311169/what-is-this-fastener-and-how-is-it-used) What Is This Fastener And How Is It Used?   (Worldbuilding Stack Exchange)  (https://worldbuilding.stackexchange.com/questions/263368/what-materials-are-industrially-useful-stored-in-barrels-and-explosive) What materials are industrially useful, stored in barrels, and explosive?     (/feeds/question/37195819) (Feed of this question and its answers)   Question feed   Subscribe to RSS  Question feed To subscribe to this RSS feed, copy and paste this URL into your RSS reader.   (https://stackoverflow.com/feeds/question/37195819)            ()   lang-sql    (https://stackoverflow.com)      (https://stackoverflow.com) Stack Overflow  (/questions) Questions  (/help) Help  (https://chat.stackoverflow.com/?tab=site&host=stackoverflow.com) Chat    (https://stackoverflow.co/) Products  (https://stackoverflow.co/teams/?utm_medium=referral&utm_source=stackoverflow-community&utm_campaign=footer&utm_content=teams) Teams  (https://stackoverflow.co/advertising/?utm_medium=referral&utm_source=stackoverflow-community&utm_campaign=footer&utm_content=advertising) Advertising  (https://stackoverflow.co/advertising/employer-branding/?utm_medium=referral&utm_source=stackoverflow-community&utm_campaign=footer&utm_content=talent) Talent    (https://stackoverflow.co/) Company  (https://stackoverflow.co/) About  (https://stackoverflow.co/company/press/) Press  (https://stackoverflow.co/company/work-here/) Work Here  (https://stackoverflow.com/legal) Legal  (https://stackoverflow.com/legal/privacy-policy) Privacy Policy  (https://stackoverflow.com/legal/terms-of-service/public) Terms of Service  (/contact) Contact Us  Cookie Settings  (https://stackoverflow.com/legal/cookie-policy) Cookie Policy    (https://stackexchange.com) Stack Exchange Network  (https://stackexchange.com/sites#technology) Technology   (https://stackexchange.com/sites#culturerecreation) Culture & recreation   (https://stackexchange.com/sites#lifearts) Life & arts   (https://stackexchange.com/sites#science) Science   (https://stackexchange.com/sites#professional) Professional   (https://stackexchange.com/sites#business) Business   (https://api.stackexchange.com/) API   (https://data.stackexchange.com/) Data       (https://stackoverflow.blog?blb=1) Blog  (https://www.facebook.com/officialstackoverflow/) Facebook  (https://twitter.com/stackoverflow) Twitter  (https://linkedin.com/company/stack-overflow) LinkedIn  (https://www.instagram.com/thestackoverflow) Instagram   Site design / logo © 2024 Stack Exchange Inc;  user contributions licensed under  (https://stackoverflow.com/help/licensing) CC BY-SA .  rev 2024.12.6.19891