What is best tool to compare two SQL Server databases (schema and data)? - 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/685053/what-is-best-tool-to-compare-two-sql-server-databases-schema-and-data) (https://cdn.sstatic.net/Shared/stacks.css?v=619122b796ae) (https://cdn.sstatic.net/Sites/stackoverflow/primary.css?v=90f1fc95eb69) (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%2f685053%2fwhat-is-best-tool-to-compare-two-sql-server-databases-schema-and-data) Sign up or (https://stackoverflow.com/users/login?ssrc=site_switcher&returnurl=https%3a%2f%2fstackoverflow.com%2fquestions%2f685053%2fwhat-is-best-tool-to-compare-two-sql-server-databases-schema-and-data) 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%2f685053%2fwhat-is-best-tool-to-compare-two-sql-server-databases-schema-and-data) Log in  (https://stackoverflow.com/users/signup?ssrc=head&returnurl=https%3a%2f%2fstackoverflow.com%2fquestions%2f685053%2fwhat-is-best-tool-to-compare-two-sql-server-databases-schema-and-data) 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/685053/what-is-best-tool-to-compare-two-sql-server-databases-schema-and-data) What is best tool to compare two SQL Server databases (schema and data)? [duplicate]  (/questions/ask) Ask Question     (2009-03-26 09:28:11Z) Asked 15 years, 8 months ago  Modified (?lastactivity) (2023-04-27 16:57:53Z) 1 year, 7 months ago  (Viewed 483,598 times) Viewed 484k times         This question shows research effort; it is useful and clear  (68:3:31e,16:72530468553146d9,10:1733615103,16:a9123374815f9543,6:685053,0d46b05106f443fdd230e26d4da26abddf4e83d475551a34cc7d3fbdbfedddb5) 228  (This question does not show any research effort; it is unclear or not useful)    (68:3:31e,16:abf809c6b8cd2d06,10:1733615103,16:44efe4795bbe63d3,6:685053,bfa916271f6ed455663783b61b73f752f551561cace81b60441241b072c88ec7)      Save this question.  (/posts/685053/timeline)    Show activity on this post.    This question already has answers here :     (/questions/193438/what-is-a-free-tool-to-compare-two-sql-server-databases) What is a free tool to compare two SQL Server Databases? [closed] (7 answers)   Closed (2020-01-31 06:51:44Z) 4 years ago .    I would like to compare two SQL Server databases including schema (table structure) and data in tables too. What is best tool to do this?  (/questions/tagged/sql) (show questions tagged 'sql') sql  (/questions/tagged/sql-server) (show questions tagged 'sql-server') sql-server  (/questions/tagged/database) (show questions tagged 'database') database  (/questions/tagged/compare) (show questions tagged 'compare') compare      (/q/685053) (Short permalink to this question) Share  Share a link to this question     Copy link (https://creativecommons.org/licenses/by-sa/2.5/) (The current license for this post: CC BY-SA 2.5) CC BY-SA 2.5     (/posts/685053/edit) () Improve this question  Follow (68:3:31e,16:b33bde96668bf6d8,10:1733615103,16:3a39b8d9a2524134,6:685053,c9d9ff2ca3e1546e05e0799406c7d7e9c5c5d7e143a1c4fdfa99abe54ffba197)  Follow this question to receive notifications       (/posts/685053/revisions) (show all edits to this post) edited (2017-05-23 10:31:19Z) May 23, 2017 at 10:31    (/users/-1/community) (Community's user avatar)    (/users/-1/community) Community (Community Bot — not a real person. Replies to this bot are not monitored.) Bot (reputation score) 1 (1 silver badge)  1  1 silver badge     asked (2009-03-26 09:28:11Z) Mar 26, 2009 at 9:28   (/users/38940/tom-smykowski) (Tom Smykowski's user avatar)    (/users/38940/tom-smykowski) Tom Smykowski Tom Smykowski (reputation score 26,049) 26k (57 gold badges)  57  57 gold badges (165 silver badges)  165  165 silver badges (246 bronze badges)  246  246 bronze badges        12 (number of 'useful comment' votes received) 1   yep: (http://stackoverflow.com/questions/193438/tool-to-compare-sql-server-tables) (tool to compare sql server tables) stackoverflow.com/questions/193438/…  – (/users/16076/mitch-wheat) (300,058 reputation) Mitch Wheat  Commented (2009-03-26 14:02:57Z, License: CC BY-SA 2.5) Mar 26, 2009 at 14:02        is there anything For SqlSever 2008R2 and Sql Azure ? – (/users/713208/joshua) (2,371 reputation) joshua  Commented (2012-09-10 10:58:45Z, License: CC BY-SA 3.0) Sep 10, 2012 at 10:58   (this comment was edited 2 times)        (number of 'useful comment' votes received) 30   Also not a duplicate as the other question asks for just a table compare not a db – (/users/151019/mmmmmm) (32,570 reputation) mmmmmm  Commented (2012-11-28 13:13:55Z, License: CC BY-SA 3.0) Nov 28, 2012 at 13:13      (number of 'useful comment' votes received) 2   How about xSQL's (http://www.xsql.com/products/sql_server_schema_compare/) Schema Compare and (http://www.xsql.com/products/sql_server_data_compare/) Data Compare tools. Completely free for SQL Server Express and very reasonably priced for other editions. – (/users/3066212/xsql-software) (146 reputation) xSQL Software  Commented (2013-12-04 20:30:47Z, License: CC BY-SA 3.0) Dec 4, 2013 at 20:30      (number of 'useful comment' votes received) 17   Can we get a tool to downvote the users who mark as duplicate without bothering to post the original links. At least give users opportunity to distinguish between their question, and existing questions. This is the top ranked google search wrt Comparison tools. It has merit – (/users/1514111/peter-pitlock) (1,863 reputation) Peter PitLock  Commented (2014-04-29 11:19:25Z, License: CC BY-SA 3.0) Apr 29, 2014 at 11:19        (Use comments to ask for more information or suggest improvements. Avoid answering questions in comments.)  |  (Expand to show all comments on this post) Show 7 more comments         15 Answers 15   Sorted by:  (/questions/685053/what-is-best-tool-to-compare-two-sql-server-databases-schema-and-data?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  (68:3:31e,16:18f8b04382938aab,10:1733615103,16:160e068eaf5961a7,6:685073,10e50a8e30fee25f9a19a20037b8bc72e84a7737ab67a0546fdafa8f37853e19) 251  (This answer is not useful)    (68:3:31e,16:00bf41965f81ec15,10:1733615103,16:dbdbcc19e91240c5,6:685073,f864a3c195429ee0d3361e4f00802bbdc5c2a7b551675eb675e84ea3634916f3)      Save this answer.  (Loading when this answer was accepted…)     (/posts/685073/timeline)    Show activity on this post.    I use schema and data comparison functionality built into the latest version Microsoft Visual Studio Community Edition (Free) or Professional / Premium /  Ultimate edition. Works like a charm! (img)  (http://channel9.msdn.com/Events/Visual-Studio/Launch-2013/VS108) http://channel9.msdn.com/Events/Visual-Studio/Launch-2013/VS108  Red-Gate's SQL data comparison tool is my second alternative: (https://i.sstatic.net/hHI5m.png) (img)  (source: (http://imar.spaanjaars.com/Images/Articles/NLayer45/Part10/Figure10-5_Red_Gate_SQL_Compare_Results.png) spaanjaars.com )  (http://www.red-gate.com/products/sql-development/sql-compare/) http://www.red-gate.com/products/sql-development/sql-compare/  (http://www.red-gate.com/products/sql-development/sql-data-compare/) http://www.red-gate.com/products/sql-development/sql-data-compare/     (/a/685073) (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/685073/edit) () Improve this answer  Follow (68:3:31e,16:ac8bcbd0c1ebf4ee,10:1733615103,16:1a7e0904b0cfa0c3,6:685073,b220cebccc67a72245ea898823301fab0cc77cb14e83c4709879e28c72821bdf)  Follow this answer to receive notifications       (/posts/685073/revisions) (show all edits to this post) edited (2023-04-27 16:57:53Z) Apr 27, 2023 at 16:57         answered (2009-03-26 09:34:14Z) Mar 26, 2009 at 9:34   (/users/82686/konstantin-tarkus) (Konstantin Tarkus's user avatar)    (/users/82686/konstantin-tarkus) Konstantin Tarkus Konstantin Tarkus (reputation score 38,302) 38.3k (14 gold badges)  14  14 gold badges (136 silver badges)  136  136 silver badges (121 bronze badges)  121  121 bronze badges        18 (number of 'useful comment' votes received) 7   I've had these sitting on my desktop for years and didn't even know it!  Thanks for this tip. – (/users/328968/peter) (9,712 reputation) Peter  Commented (2011-03-02 03:27:38Z, License: CC BY-SA 2.5) Mar 2, 2011 at 3:27      (number of 'useful comment' votes received) 4   I also found that Visual Studio's Data and Schema comparison tool works better than Red-Gates's one (it syncs schema more accurately) – (/users/82686/konstantin-tarkus) (38,302 reputation) Konstantin Tarkus  Commented (2011-03-04 19:39:18Z, License: CC BY-SA 2.5) Mar 4, 2011 at 19:39      (number of 'useful comment' votes received) 3   Missing data compare in VS2012?  Update from Microsoft here: (http://msdn.microsoft.com/en-us/jj650015) msdn.microsoft.com/en-us/jj650015  – (/users/19020/dan-esparza) (28,347 reputation) Dan Esparza  Commented (2013-07-18 19:28:54Z, License: CC BY-SA 3.0) Jul 18, 2013 at 19:28      (number of 'useful comment' votes received) 1   @OrionEdwards this tool is availible in vs Professional as well. have it installed and works great! – (/users/422827/arik) (336 reputation) arik  Commented (2013-12-23 11:40:43Z, License: CC BY-SA 3.0) Dec 23, 2013 at 11:40      (number of 'useful comment' votes received) 2   I have had Visual Studio 2013 crash on me multiple times while trying to use the built-in tools to sync data from our Prod database to the Test database.  It works good for small batches, but when you try to sync the entire database.....  well, good luck.  RedGate's tool has worked perfectly for me, being able to handle the heavy lifting to sync the entire DB's data.  (And it seems to be faster as well.) – (/users/940783/jason-parker) (4,984 reputation) Jason Parker  Commented (2014-06-10 13:46:39Z, License: CC BY-SA 3.0) Jun 10, 2014 at 13:46   (this comment was edited 2 times)          (Use comments to ask for more information or suggest improvements. Avoid comments like “+1” or “thanks”.)  |  (Expand to show all comments on this post) Show 13 more comments            This answer is useful  (68:3:31e,16:f71eb3242b64884a,10:1733615103,16:146258f65f4ac72d,6:685991,45ce5f33cd0e957b3743c1a928484f4ac4fa1f1f2c16ab3757a31b58b2b23dd4) 144  (This answer is not useful)    (68:3:31e,16:33d7e607b37c1b03,10:1733615103,16:9e5c619b175b0a53,6:685991,e6db7a87d53432993e02b2a3d2966624a5ce75d6d30d0780182febc8054feebe)      Save this answer.  (Loading when this answer was accepted…)     (/posts/685991/timeline)    Show activity on this post.    I like (https://github.com/OpenDBDiff/OpenDBDiff) Open DBDiff . While not the most complete tool, it works great, it's free, and it's very easy to use.    (/a/685991) (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/685991/edit) () Improve this answer  Follow (68:3:31e,16:869a3bfc6be7070c,10:1733615103,16:c239dfcf60e80276,6:685991,5d837a949a769b1299838ffe271aecf0a16ab74b0b1f4089f189f76ce79896e3)  Follow this answer to receive notifications       (/posts/685991/revisions) (show all edits to this post) edited (2020-05-15 14:58:09Z) May 15, 2020 at 14:58    (/users/11912/james-skemp) (James Skemp's user avatar)    (/users/11912/james-skemp) James Skemp (reputation score) 8,521 (9 gold badges)  9  9 gold badges (69 silver badges)  69  69 silver badges (110 bronze badges)  110  110 bronze badges     answered (2009-03-26 14:19:12Z) Mar 26, 2009 at 14:19     MauroMauro        9 (number of 'useful comment' votes received) 4   Simple, Easy and it work. My choice to replicate differencies from one database to another. – (/users/287824/eka808) (2,317 reputation) eka808  Commented (2012-04-11 11:49:53Z, License: CC BY-SA 3.0) Apr 11, 2012 at 11:49      (number of 'useful comment' votes received) 41   This does not compare DATA – (/users/165839/daveo) (19,824 reputation) Daveo  Commented (2013-03-27 04:58:40Z, License: CC BY-SA 3.0) Mar 27, 2013 at 4:58      (number of 'useful comment' votes received) 4   This is the worst database comparison tool I have come across. It does not save the preferences correctly, it often bombs out. It does not save the SQL instances you've used and then scans the network everytime for all PCs that it then lists - thus you have to copy and paste the instances every time and sit and wait until the network has been scanned before you can use it. This will probably work on very small databases but i couldn't get it to work once and a larger db. Its free, but so is malaria. – (/users/1514111/peter-pitlock) (1,863 reputation) Peter PitLock  Commented (2014-04-29 10:42:44Z, License: CC BY-SA 3.0) Apr 29, 2014 at 10:42   (this comment was edited 1 time)        (number of 'useful comment' votes received) 3   Note that it CAN compare data, but only for single tables. I personally found this useful, but if you need to diff many tables or large tables it probably is not sufficient. – (/users/606108/thomas-n) (418 reputation) Thomas N  Commented (2014-12-23 13:23:13Z, License: CC BY-SA 3.0) Dec 23, 2014 at 13:23   (this comment was edited 1 time)        (number of 'useful comment' votes received) 2   It doesn't work ok in sql server 2014 – (/users/944592/yakya) (5,150 reputation) yakya  Commented (2015-07-21 15:02:03Z, License: CC BY-SA 3.0) Jul 21, 2015 at 15:02        (Use comments to ask for more information or suggest improvements. Avoid comments like “+1” or “thanks”.)  |  (Expand to show all comments on this post) Show 4 more comments         This answer is useful  (68:3:31e,16:e14b12b3fd983f85,10:1733615103,16:6376aee2e92c6adc,6:685064,224f977e57fe70c3ee91e16d1dc41846791f2b92829fb4249ba3266b94fddf5c) 90  (This answer is not useful)    (68:3:31e,16:84b877eda48eff81,10:1733615103,16:c0e7536e040f2a2d,6:685064,684e9358726ae117be0b2c0b9f533e2e3b96a2393b7b1e4395191ba74dc286a2)      Save this answer.  (Loading when this answer was accepted…)     (/posts/685064/timeline)    Show activity on this post.    I am using Red-Gate's software: (http://www.red-gate.com/) http://www.red-gate.com    (/a/685064) (Short permalink to this answer) Share  Share a link to this answer     Copy link (https://creativecommons.org/licenses/by-sa/2.5/) (The current license for this post: CC BY-SA 2.5) CC BY-SA 2.5     (/posts/685064/edit) () Improve this answer  Follow (68:3:31e,16:1c6e6354d19d0c6b,10:1733615103,16:6d0382af4647a697,6:685064,34d83b036b488bbf2e95141f28cc19d27367b0c9e4e1e0f3d79ca2a0ac20255d)  Follow this answer to receive notifications       answered (2009-03-26 09:31:23Z) Mar 26, 2009 at 9:31   (/users/74678/joakim-backman) (Joakim Backman's user avatar)    (/users/74678/joakim-backman) Joakim Backman Joakim Backman (reputation score) 1,897 (13 silver badges)  13  13 silver badges (12 bronze badges)  12  12 bronze badges        8 (number of 'useful comment' votes received) 1   Yes - SQL Compare and SQL Data Compare are absolutely essential to our business - good stuff. – (/users/15592/mark-brittingham) (28,855 reputation) Mark Brittingham  Commented (2009-03-26 12:23:24Z, License: CC BY-SA 2.5) Mar 26, 2009 at 12:23      (number of 'useful comment' votes received) 13   Expensive?  $300 for something that can save you dozens of hours per year.  Even at the lowest global developer rates this is a bargain. – (/users/257954/beep-beep) (19,121 reputation) Beep beep  Commented (2010-11-11 07:32:38Z, License: CC BY-SA 2.5) Nov 11, 2010 at 7:32   (this comment was edited 1 time)        (number of 'useful comment' votes received) 1   SQL Compare has become a much better product over the years but still not the best one. I tried many of these tools over the last 10 years and the best one is SQL Delta with its superbly accurate script generator, the second is AdeptSql (only because its data compare tool does not work properly when there is a lot of referential integ. constraints), red gate is a distant 3rd along with many other tools – (/users/202630/kemal-erdogan) (1,080 reputation) Kemal Erdogan  Commented (2012-08-29 08:16:41Z, License: CC BY-SA 3.0) Aug 29, 2012 at 8:16      (number of 'useful comment' votes received) 1   The tool is really good - but as it was told earlier very expensive. I've choosen the alternative - dbForge Data Compare for SQL Server from Devart. The functionality is almost the same. It suits all my needs and is much cheaper. – user1773378  Commented (2013-05-23 11:03:13Z, License: CC BY-SA 3.0) May 23, 2013 at 11:03      (number of 'useful comment' votes received) 3   As mentioned in the answer this question duplicates, this functionality is built into SQL Server as TableDiff.exe. It's worth trying the built in tools first before paying for a licences. – (/users/600517/chip-mccormick) (744 reputation) Chip McCormick  Commented (2013-09-11 15:49:25Z, License: CC BY-SA 3.0) Sep 11, 2013 at 15:49        (Use comments to ask for more information or suggest improvements. Avoid comments like “+1” or “thanks”.)  |  (Expand to show all comments on this post) Show 3 more comments            This answer is useful  (69:3:31e,16:289a5614010968fd,10:1733615103,16:c1a6f10ec1ad31b1,7:6651360,a4812adc721cf3e715ffef6d6be63670af3edac51405384ea4e12ecb483a3261) 76  (This answer is not useful)    (69:3:31e,16:e6f85247a7364bcb,10:1733615103,16:834baf839d1cfe66,7:6651360,d0eb746bd47c256ceac5ba892a24dcf8e540a59b7ac5551473597db4c7479d37)      Save this answer.  (Loading when this answer was accepted…)     (/posts/6651360/timeline)    Show activity on this post.    SQL Admin Studio from (http://www.simego.com/Products/SQL-Admin-Studio) http://www.simego.com/Products/SQL-Admin-Studio is now free, lets you manage your SQL Database, SQL Compare and Synchronise , Data Compare and Synchronise and much more. Also supports SQL Azure and some MySQL Support too. [UPDATE: Yes I am the Author of the above program, as it's now Free I just wanted to Share it with the community]   (/a/6651360) (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/6651360/edit) () Improve this answer  Follow (69:3:31e,16:21a36a604e6980e4,10:1733615103,16:f7218340f32cc577,7:6651360,ea1851c448c4c01bded11032a10b25f1a305b66b565d6628d4000755ea2c9929)  Follow this answer to receive notifications       (/posts/6651360/revisions) (show all edits to this post) edited (2011-07-15 09:39:15Z) Jul 15, 2011 at 9:39         answered (2011-07-11 14:08:42Z) Jul 11, 2011 at 14:08   (/users/839031/sean-cleaver) (Sean Cleaver's user avatar)    (/users/839031/sean-cleaver) Sean Cleaver Sean Cleaver (reputation score) 825 (6 silver badges)  6  6 silver badges (4 bronze badges)  4  4 bronze badges        10 (number of 'useful comment' votes received) 4   It's a little rough about the edges compared to some of the pay offerings, but it does work, and a good bit cheaper (as it's free) +1. – user166390  Commented (2012-02-11 01:35:08Z, License: CC BY-SA 3.0) Feb 11, 2012 at 1:35   (this comment was edited 2 times)        (number of 'useful comment' votes received) 8   Data Sync Studio doesn't seem to be free anymore. – (/users/11980/adriano-machado) (232 reputation) Adriano Machado  Commented (2012-11-09 21:29:53Z, License: CC BY-SA 3.0) Nov 9, 2012 at 21:29      (number of 'useful comment' votes received) 1   This does not work with sqlite as an FYI to anyone – (/users/1549747/lyricalpanda) (1,414 reputation) LyricalPanda  Commented (2014-05-19 19:59:06Z, License: CC BY-SA 3.0) May 19, 2014 at 19:59      (number of 'useful comment' votes received) 7   (https://www.simego.com/install/sql-tools) simego.com/install/sql-tools not found – (/users/206730/kiquenet) (14,956 reputation) Kiquenet  Commented (2018-04-26 07:39:25Z, License: CC BY-SA 3.0) Apr 26, 2018 at 7:39      (number of 'useful comment' votes received) 2   I got the software from (https://download.cnet.com/SQL-Admin-Studio-64-Bit/3000-10254_4-75700837.html) download.cnet.com/SQL-Admin-Studio-64-Bit/…  – (/users/215401/maksymilian-mulawa) (277 reputation) Maksymilian Mulawa  Commented (2020-06-08 11:52:00Z, License: CC BY-SA 4.0) Jun 8, 2020 at 11:52        (Use comments to ask for more information or suggest improvements. Avoid comments like “+1” or “thanks”.)  |  (Expand to show all comments on this post) Show 5 more comments         This answer is useful  (68:3:31e,16:7beb51adfab2409e,10:1733615103,16:de8f2c4b75c8bc84,6:685914,26fc3f2f5296cd97330db4c07897e6f6c17701640a3bbb4c7232073a5c7fdbd6) 13  (This answer is not useful)    (68:3:31e,16:b56d7dff3404fa96,10:1733615103,16:422d32279e96bcfa,6:685914,933a3e1951c8202eb9da37d7822a3c2260340ef564301a61ff3ab02d67a8ffed)      Save this answer.  (Loading when this answer was accepted…)     (/posts/685914/timeline)    Show activity on this post.    I'm partial to (http://www.adeptsql.com/) AdeptSQL .  It's clean and intuitive and it DOESN'T have the one feature that scares the hell out of me on a lot of similar programs.  One giant button that it you push it will automatically synchronize EVERYTHING without so much as a by-your-leave.  If you want to sync the changes you have to do it yourself and I like that.   (/a/685914) (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/685914/edit) () Improve this answer  Follow (68:3:31e,16:d5576ae0c92b22ad,10:1733615103,16:100ca197de8fa932,6:685914,fb212059521cee3e6a222ba7bc5c507c421fd438a480dc77d6017fa14c722fee)  Follow this answer to receive notifications       (/posts/685914/revisions) (show all edits to this post) edited (2018-10-26 23:33:04Z) Oct 26, 2018 at 23:33    (/users/933198/lee-taylor) (Lee Taylor's user avatar)    (/users/933198/lee-taylor) Lee Taylor (reputation score) 7,968 (16 gold badges)  16  16 gold badges (37 silver badges)  37  37 silver badges (53 bronze badges)  53  53 bronze badges     answered (2009-03-26 13:57:24Z) Mar 26, 2009 at 13:57   (/users/17632/christopher-klein) (Christopher Klein's user avatar)    (/users/17632/christopher-klein) Christopher Klein Christopher Klein (reputation score) 2,793 (5 gold badges)  5  5 gold badges (39 silver badges)  39  39 silver badges (65 bronze badges)  65  65 bronze badges        4 (number of 'useful comment' votes received) 5   +1 Adept SQL Diff is a superb piece of software and relatively cheap – (/users/68262/steve-weet) (28,352 reputation) Steve Weet  Commented (2009-04-08 21:56:52Z, License: CC BY-SA 2.5) Apr 8, 2009 at 21:56        I do agree. It's very fast and reliable at a very convenient cost. We use it at work. – (/users/203991/max-rios) (2,246 reputation) Max Rios  Commented (2013-08-28 15:19:13Z, License: CC BY-SA 3.0) Aug 28, 2013 at 15:19        Lol I know - in the Visual Studio tool the button to sync is right next to the generate script button. I haven't clicked either yet but still scared! – (/users/16940/simon-weaver) (145,610 reputation) Simon_Weaver  Commented (2019-04-30 06:21:33Z, License: CC BY-SA 4.0) Apr 30, 2019 at 6:21        This is one of the best tools... but is no longer available and is now unable to connect to some SQL servers. – (/users/32429/glen-little) (7,108 reputation) Glen Little  Commented (2019-06-12 23:18:15Z, License: CC BY-SA 4.0) Jun 12, 2019 at 23:18        (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:18797b6c00324402,10:1733615103,16:a0f1dd1fae9a717f,8:13601332,c18138cba31345e5ee145d835d67b299753786eb7ab5c476cd87e888cd11539e) 8  (This answer is not useful)    (70:3:31e,16:9ec6cabf2d0b67ab,10:1733615103,16:ed060c3eafb8272f,8:13601332,7e4ed0e3491a01d89d84e1a780e94d283ef97a557da5984e74c0dfb07b1d0b90)      Save this answer.  (Loading when this answer was accepted…)     (/posts/13601332/timeline)    Show activity on this post.    There is one tool with source code available at (http://www.codeproject.com/Articles/205011/SQL-Server-Database-Comparison-Tool) http://www.codeproject.com/Articles/205011/SQL-Server-Database-Comparison-Tool  That should give flexibility  as code is available.    (/a/13601332) (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/13601332/edit) () Improve this answer  Follow (70:3:31e,16:3bb8b91ed8988876,10:1733615103,16:00bb31ca29c672e5,8:13601332,0911fd7ee7930bc1cffac3d9ff4b2f40fcb3985af6b9d1a3f991514cc26bfde7)  Follow this answer to receive notifications       answered (2012-11-28 09:02:09Z) Nov 28, 2012 at 9:02   (/users/1680392/milind-thakkar) (Milind Thakkar's user avatar)    (/users/1680392/milind-thakkar) Milind Thakkar Milind Thakkar (reputation score) 980 (2 gold badges)  2  2 gold badges (13 silver badges)  13  13 silver badges (21 bronze badges)  21  21 bronze badges        0   (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  (68:3:31e,16:9962c959a5026dc7,10:1733615103,16:4427d1b229e530cf,6:685515,353d7c3021699118ac21ce627643694c03b89d907b243be0eb2758a9756e54f2) 6  (This answer is not useful)    (68:3:31e,16:9d22821181931a8b,10:1733615103,16:1884f61db7d1050a,6:685515,21372e0685a25957ba0464363b8e1381924ccf49569fbb29ae75a7af326c767c)      Save this answer.  (Loading when this answer was accepted…)     (/posts/685515/timeline)    Show activity on this post.    (http://www.innovartis.co.uk/) dbghost is the best i have used to date.  one of the best features i have seen is that it will generate SQL code to go between versions of a database based on the SQL you keep in source control, as well as a database.  simple and easy to use.   (/a/685515) (Short permalink to this answer) Share  Share a link to this answer     Copy link (https://creativecommons.org/licenses/by-sa/2.5/) (The current license for this post: CC BY-SA 2.5) CC BY-SA 2.5     (/posts/685515/edit) () Improve this answer  Follow (68:3:31e,16:2eafb44cd94a8eb2,10:1733615103,16:b69014f5382a1c44,6:685515,18c01b37a03fed928d0891d94ddf0d450e98fc66b04842180c3b23f9e693f322)  Follow this answer to receive notifications       answered (2009-03-26 12:17:53Z) Mar 26, 2009 at 12:17   (/users/81044/bluephlame) (Bluephlame's user avatar)    (/users/81044/bluephlame) Bluephlame Bluephlame (reputation score) 3,959 (4 gold badges)  4  4 gold badges (37 silver badges)  37  37 silver badges (51 bronze badges)  51  51 bronze badges        1 (number of 'useful comment' votes received) 1   I've used DbGhost for 10 years and it's never let me down. The support they provide is second to none – (/users/32027/penderi) (9,043 reputation) penderi  Commented (2010-02-21 10:31:08Z, License: CC BY-SA 2.5) Feb 21, 2010 at 10:31        (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  (68:3:31e,16:d248f78c077fd081,10:1733615103,16:e71e303f645b7780,6:685087,9a51d07541ec94d8da153bf22a2accf61c79af384f897f1ec46468a0b4c998e7) 4  (This answer is not useful)    (68:3:31e,16:93ac8802eeddae77,10:1733615103,16:6e9927bf8a2f1215,6:685087,62ef65bdb2784980ef3bc50a14378dca6b3e4cd5ebd41b9ff16ab93f30f45d8f)      Save this answer.  (Loading when this answer was accepted…)     (/posts/685087/timeline)    Show activity on this post.    I've used SQL Delta before ((http://www.sqldelta.com/) http://www.sqldelta.com/ ), it's really good. Not free however, not sure how prices compare to Red-Gates   (/a/685087) (Short permalink to this answer) Share  Share a link to this answer     Copy link (https://creativecommons.org/licenses/by-sa/2.5/) (The current license for this post: CC BY-SA 2.5) CC BY-SA 2.5     (/posts/685087/edit) () Improve this answer  Follow (68:3:31e,16:6c93f58a0c4811c2,10:1733615103,16:ec0ce3f77a8581b6,6:685087,5af7399b717695cb8037591423d1eb0ee0586a1b5cd1c0e9aab2bef6ca13a62f)  Follow this answer to receive notifications       answered (2009-03-26 09:38:12Z) Mar 26, 2009 at 9:38   (/users/76056/jonow) (JonoW's user avatar)    (/users/76056/jonow) JonoW JonoW (reputation score 14,199) 14.2k (3 gold badges)  3  3 gold badges (34 silver badges)  34  34 silver badges (32 bronze badges)  32  32 bronze badges        1   Solid product, used it for a few years.  Nice interface and doesn't add install a whole other bunch of junk that you may not want.  Price is reasonable (single license for $370) – (/users/2343/sameer-alibhai) (3,158 reputation) Sameer Alibhai  Commented (2015-04-02 15:54:05Z, License: CC BY-SA 3.0) Apr 2, 2015 at 15:54        (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  (69:3:31e,16:903a0ea41192d22d,10:1733615103,16:517585d16970984e,7:8908223,610995ae811f5c794f201c8286f8c8109e0dbc289536705120f222cfb0bff349) 4  (This answer is not useful)    (69:3:31e,16:4b8985e486f0d7c8,10:1733615103,16:1d06f4fda623ab90,7:8908223,17c2c7c57561a5edb4eb5e6252d2511bf783982452350f7235b8412e2b2d0735)      Save this answer.  (Loading when this answer was accepted…)     (/posts/8908223/timeline)    Show activity on this post.    Try DBComparer, it's free and fast: (http://dbcomparer.com/) http://dbcomparer.com/    (/a/8908223) (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/8908223/edit) () Improve this answer  Follow (69:3:31e,16:3f475fc79c3c6ad3,10:1733615103,16:1e1d4d56c22b5672,7:8908223,21eb53ced816dec9250b96eaa80ea954ab758a2b3963a5f481602c5ad0c6e457)  Follow this answer to receive notifications       answered (2012-01-18 09:59:29Z) Jan 18, 2012 at 9:59   (/users/1155903/melad) (Melad's user avatar)    (/users/1155903/melad) Melad Melad (reputation score) 925 (12 silver badges)  12  12 silver badges (14 bronze badges)  14  14 bronze badges        4 (number of 'useful comment' votes received) 2   This tool is very iffy. For example, it does a reverse engineer of both databases and then it throws up many tables and views that it claims are different.  However, what is actually different is the way the CREATE scripts look.    For example, it says a view is different because the one comes up as: CREATE VIEW dbo.ViewName  and the other db comes up as  CREATE VIEW [dbo].[ViewName] – (/users/481509/ozzy) (974 reputation) Ozzy  Commented (2012-05-18 09:59:23Z, License: CC BY-SA 3.0) May 18, 2012 at 9:59   (this comment was edited 1 time)          Couldn't get this to work at all. Literally took hours to compare a DB, even after deselecting most options that it needs to compare. – (/users/1514111/peter-pitlock) (1,863 reputation) Peter PitLock  Commented (2014-04-29 11:34:30Z, License: CC BY-SA 3.0) Apr 29, 2014 at 11:34        Doesn't work with SQL Server 2000. – (/users/874366/kasim-husaini) (412 reputation) Kasim Husaini  Commented (2017-01-04 06:21:01Z, License: CC BY-SA 3.0) Jan 4, 2017 at 6:21      (number of 'useful comment' votes received) 1   Not comparing data – (/users/415078/angularconsulting-au) (28,149 reputation) angularconsulting.au  Commented (2017-03-07 22:13:34Z, License: CC BY-SA 3.0) Mar 7, 2017 at 22:13        (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  (68:3:31e,16:4b7deec0c0b47d83,10:1733615103,16:dd5319a97f739007,6:732025,02743c4a1b57c7a0d683f29592aa90b8df07aaf67290e1a337b340de18e86563) 3  (This answer is not useful)    (68:3:31e,16:b593b705734f05b3,10:1733615103,16:b039c72693584096,6:732025,f8e5c9bff4e1a978bf4434697ac4c37b4cc1b82f85a6dd8f2d2737fc1693698d)      Save this answer.  (Loading when this answer was accepted…)     (/posts/732025/timeline)    Show activity on this post.    Database Workbench can made it too (http://www.upscene.com/products.dbw.index.php) http://www.upscene.com/products.dbw.index.php  Cross database development Use the Schema Compare and Migration
  Tools to compare testing and deployed
  databases, migrate existing databases
  to different database systems.  you can also made it with database Comparer (http://www.clevercomponents.com/products/dbcomparer/dbcomparer.asp) http://www.clevercomponents.com/products/dbcomparer/dbcomparer.asp  I use it for Firebird and it works well.   (/a/732025) (Short permalink to this answer) Share  Share a link to this answer     Copy link (https://creativecommons.org/licenses/by-sa/2.5/) (The current license for this post: CC BY-SA 2.5) CC BY-SA 2.5     (/posts/732025/edit) () Improve this answer  Follow (68:3:31e,16:f9cb2d3f22c9af66,10:1733615103,16:8354ad570bb6d8f2,6:732025,fb5b8763334e132bd7a4553c9b764c7eed395e7b3e824b854e134c4839027ed0)  Follow this answer to receive notifications       answered (2009-04-08 21:52:06Z) Apr 8, 2009 at 21:52   (/users/87736/hugues-van-landeghem) (Hugues Van Landeghem's user avatar)    (/users/87736/hugues-van-landeghem) Hugues Van Landeghem Hugues Van Landeghem (reputation score) 6,783 (4 gold badges)  4  4 gold badges (36 silver badges)  36  36 silver badges (61 bronze badges)  61  61 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)          This answer is useful  (69:3:31e,16:400798ce61938a96,10:1733615103,16:27495515ebce3b8e,7:2606946,b20406b243fbd75dc717af1993ce7af26e06b5c68546919bfb626d59c908416c) 3  (This answer is not useful)    (69:3:31e,16:d9d5a7e42b49ed7b,10:1733615103,16:570a56428a21cdd7,7:2606946,2ee8d08541a5bb152f8bd43381df03fdb3a4e098744f98f98b4bbaf4d53469c4)      Save this answer.  (Loading when this answer was accepted…)     (/posts/2606946/timeline)    Show activity on this post.    Try (http://www.devart.com/dbforge/sql/) dbForge Data Compare for SQL Server . It can compare and sync any databases, even very large ones. Quick, easy, always delivers a correct result.
Try it on your database and comment upon the product.  We can recommend you a reliable SQL comparison tool that offer 3 time’s faster comparison and synchronization of table data in your SQL Server databases. It's (http://www.devart.com/dbforge/sql/datacompare/) dbForge Data Compare for SQL Server and (http://www.devart.com/dbforge/sql/schemacompare/) dbForge Schema Compare for SQL Server  Main advantages: Speedier comparison and synchronization of large databases Support of native SQL Server backups Custom mapping of tables, columns, and schemas Multiple options to tune your comparison and synchronization Generating comparison and synchronization reports  Plus free 30-day trial and risk-free purchase with 30-day money back guarantee.   (/a/2606946) (Short permalink to this answer) Share  Share a link to this answer     Copy link (https://creativecommons.org/licenses/by-sa/2.5/) (The current license for this post: CC BY-SA 2.5) CC BY-SA 2.5     (/posts/2606946/edit) () Improve this answer  Follow (69:3:31e,16:955e304cab9ae8ff,10:1733615103,16:50664d591012c9cd,7:2606946,e4f37d7131b841c8d8f375d5dd5b455ac9a266719a1e98db4be29641c92c077f)  Follow this answer to receive notifications       answered (2010-04-09 11:24:56Z) Apr 9, 2010 at 11:24   (/users/135566/devart) (Devart's user avatar)    (/users/135566/devart) Devart Devart (reputation score 121,652) 122k (23 gold badges)  23  23 gold badges (169 silver badges)  169  169 silver badges (189 bronze badges)  189  189 bronze badges        4 (number of 'useful comment' votes received) 17   Please add "a full disclosure". (Devart makes dbForge.) – user166390  Commented (2012-02-11 01:36:26Z, License: CC BY-SA 3.0) Feb 11, 2012 at 1:36   (this comment was edited 1 time)        (number of 'useful comment' votes received) 1   My choice is Devart's SQL Data and Schema Compare tools. Red Gate products are good too, but Devart's are much cheaper and also very professional. Thank you guys! – user1773378  Commented (2013-05-22 12:22:02Z, License: CC BY-SA 3.0) May 22, 2013 at 12:22   (this comment was edited 1 time)          I have used this and it worked great for me. So far I am a fan. It's not free at all, but rather, a free trial. – (/users/710768/camille-s%c3%a9vigny) (5,133 reputation) Camille Sévigny  Commented (2016-01-29 18:11:57Z, License: CC BY-SA 3.0) Jan 29, 2016 at 18:11        can attest, really good. – (/users/437979/anar-khalilov) (17,468 reputation) anar khalilov  Commented (2018-01-03 07:11:42Z, License: CC BY-SA 3.0) Jan 3, 2018 at 7:11        (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  (68:3:31e,16:1fe997707ffef538,10:1733615103,16:b855996c50386dbc,6:685168,b8da5c375f4fe20891f32371ce6fad23ad42d01bcc63f5ffbe10c4c7ea154f8a) 2  (This answer is not useful)    (68:3:31e,16:b7c6458645182123,10:1733615103,16:5328b08db01d7810,6:685168,fb056b44dc45c68546ccd01d68558a60a426b131b0ea2e120efedf04e2c50193)      Save this answer.  (Loading when this answer was accepted…)     (/posts/685168/timeline)    Show activity on this post.    I've used Red Gate's tools and they are superb.
However, if you can't spend any money you could try (http://opendbiff.codeplex.com/) Open DBDiff to compare schemas.   (/a/685168) (Short permalink to this answer) Share  Share a link to this answer     Copy link (https://creativecommons.org/licenses/by-sa/2.5/) (The current license for this post: CC BY-SA 2.5) CC BY-SA 2.5     (/posts/685168/edit) () Improve this answer  Follow (68:3:31e,16:9ca0c7f13571aef0,10:1733615103,16:58c764c11154c696,6:685168,f408685a7f940a47a200fdf8ada6ad3fc165cbca7d90c693f3b1829979278928)  Follow this answer to receive notifications       answered (2009-03-26 10:15:53Z) Mar 26, 2009 at 10:15   (/users/6547/santiago-cepas) (Santiago Cepas's user avatar)    (/users/6547/santiago-cepas) Santiago Cepas Santiago Cepas (reputation score) 4,094 (2 gold badges)  2  2 gold badges (27 silver badges)  27  27 silver badges (31 bronze badges)  31  31 bronze badges        2 (number of 'useful comment' votes received) 1   dead link. please provide another link. – (/users/1084742/toha) (5,490 reputation) toha  Commented (2018-07-30 08:07:20Z, License: CC BY-SA 4.0) Jul 30, 2018 at 8:07      (number of 'useful comment' votes received) 1   This seems to be it: (https://github.com/OpenDBDiff/OpenDBDiff) github.com/OpenDBDiff/OpenDBDiff  – (/users/32429/glen-little) (7,108 reputation) Glen Little  Commented (2019-06-13 00:26:43Z, License: CC BY-SA 4.0) Jun 13, 2019 at 0:26        (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  (68:3:31e,16:57042b07eb6a3067,10:1733615103,16:8acb5bd07693c4ee,6:685083,61d6b74cb9910ba5e1d0a029e24c9f141cf9d525493310e89ee4666f80d22e29) 1  (This answer is not useful)    (68:3:31e,16:46bb0cb2deae469a,10:1733615103,16:2547e584dc6aff92,6:685083,4cb968c13a34006ad265adc0bee25ece25a72bfb3f9d236a9f08b9d25a4f1c5c)      Save this answer.  (Loading when this answer was accepted…)     (/posts/685083/timeline)    Show activity on this post.    We are using an inhouse developed solution that is basicly a procedure with arguments of what you want included in the comparision (SP's, Full SP code, table structure, defaults, indices, triggers.. etc) Depending on your needs and budget, it might be a good way to go for you as well. It is quite easily developed as well, then we just redirect output of procedure to textfiles and do text comparisions between the files. One good thing about it is that its possible to save the output in source control. /B   (/a/685083) (Short permalink to this answer) Share  Share a link to this answer     Copy link (https://creativecommons.org/licenses/by-sa/2.5/) (The current license for this post: CC BY-SA 2.5) CC BY-SA 2.5     (/posts/685083/edit) () Improve this answer  Follow (68:3:31e,16:96709177941b411d,10:1733615103,16:1d9fc467352da938,6:685083,513a8298c8231916c54494028e27869d0d4a29366df1963919390a3f4f75d6d7)  Follow this answer to receive notifications       answered (2009-03-26 09:36:47Z) Mar 26, 2009 at 9:36   (/users/74343/brimstedt) (Brimstedt's user avatar)    (/users/74343/brimstedt) Brimstedt Brimstedt (reputation score) 3,120 (26 silver badges)  26  26 silver badges (32 bronze badges)  32  32 bronze badges        0   (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  (69:3:31e,16:fb59720e70cf7c34,10:1733615103,16:f4e13fcfa25b785c,7:2506534,d753ee19f86cc67b6e9c19793ef171b445008361dfbdbc61e54e55654dc67bcc) 1  (This answer is not useful)    (69:3:31e,16:ef5ee7ea5aadb6d9,10:1733615103,16:db459a77a7590068,7:2506534,c507b75935b352ce7a27c6cf737f957d6071adfe34326f115dd584f21136ce7a)      Save this answer.  (Loading when this answer was accepted…)     (/posts/2506534/timeline)    Show activity on this post.    I would definitely go with AdeptSQL if you're using MSSQL. It's the least good looking but the most talented db compare tool amongst the ones I've tried. It can compare both the structure and the data. It tells you which tables exist on one db but does not exist on the other, compares the structure and data of the common ones and it can produce the script to synchronize the two. It's not free but has a 30 day trial (as far as I can remember)   (/a/2506534) (Short permalink to this answer) Share  Share a link to this answer     Copy link (https://creativecommons.org/licenses/by-sa/2.5/) (The current license for this post: CC BY-SA 2.5) CC BY-SA 2.5     (/posts/2506534/edit) () Improve this answer  Follow (69:3:31e,16:3536431ccd75846f,10:1733615103,16:abc7059c623b1758,7:2506534,800ae7ce51fb7649a1a856d3d1f0ac33dad64f3f0688365f78c275d534234e06)  Follow this answer to receive notifications       answered (2010-03-24 09:31:57Z) Mar 24, 2010 at 9:31   (/users/106303/asl%c4%b1) (aslı's user avatar)    (/users/106303/asl%c4%b1) aslı aslı (reputation score) 8,904 (11 gold badges)  11  11 gold badges (60 silver badges)  60  60 silver badges (80 bronze badges)  80  80 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)          This answer is useful  (70:3:31e,16:c0343d3b6971c2d0,10:1733615103,16:da7caaccaf3a41b6,8:10602738,34e094280809026e6ef24e8fe5a7e958d4829d8563ec1f5b9ee21764f921fc26) 1  (This answer is not useful)    (70:3:31e,16:d04f02915f841843,10:1733615103,16:762bd6698d9e6c6a,8:10602738,3f58887ec9faea8351da935f1ce2ecbec13f4b500c9ef74450846180edd61469)      Save this answer.  (Loading when this answer was accepted…)     (/posts/10602738/timeline)    Show activity on this post.    I tried (http://www.ginktage.com/2012/04/open-dbdiff-for-sql-server-2008/) OpenDiff Tool . Great tool that is free and easy to use .   (/a/10602738) (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/10602738/edit) () Improve this answer  Follow (70:3:31e,16:c519d3c214a40727,10:1733615103,16:4ac947d2fb208525,8:10602738,4ebff5c10d468d06835368e5695fc59db6ee9fa4848be637e3753c17a53daffa)  Follow this answer to receive notifications       answered (2012-05-15 14:17:30Z) May 15, 2012 at 14:17   (/users/236750/senthil-kumar-b) (Senthil Kumar B's user avatar)    (/users/236750/senthil-kumar-b) Senthil Kumar B Senthil Kumar B (reputation score) 936 (6 silver badges)  6  6 silver badges (13 bronze badges)  13  13 bronze badges        1   Realy Open DBDiff is  Great tool, Correct link is: (https://github.com/OpenDBDiff/OpenDBDiff) github.com/OpenDBDiff/OpenDBDiff  – (/users/2155778/zolfaghari) (1,313 reputation) Zolfaghari  Commented (2024-10-13 15:04:49Z, License: CC BY-SA 4.0) Oct 13 at 15:04        (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)      Not the answer you're looking for? Browse other questions tagged (/questions/tagged/sql) (show questions tagged 'sql') sql  (/questions/tagged/sql-server) (show questions tagged 'sql-server') sql-server  (/questions/tagged/database) (show questions tagged 'database') database  (/questions/tagged/compare) (show questions tagged 'compare') compare   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            (https://chat.stackoverflow.com/) (7 users active in 10 rooms the last 60 minutes) 7 people chatting    Linked (https://stackoverflow.com/q/193438?lq=1) (Question score (upvotes - downvotes)) 56  (https://stackoverflow.com/questions/193438/what-is-a-free-tool-to-compare-two-sql-server-databases?noredirect=1&lq=1) What is a free tool to compare two SQL Server Databases?  (https://stackoverflow.com/q/175415?lq=1) (Question score (upvotes - downvotes)) 1113  (https://stackoverflow.com/questions/175415/how-do-i-get-list-of-all-tables-in-a-database-using-tsql?noredirect=1&lq=1) How do I get list of all tables in a database using TSQL?  (https://stackoverflow.com/q/5475306?lq=1) (Question score (upvotes - downvotes)) 242  (https://stackoverflow.com/questions/5475306/how-do-i-copy-sql-azure-database-to-my-local-development-server?noredirect=1&lq=1) How do I copy SQL Azure database to my local development server?  (https://stackoverflow.com/q/11560713?lq=1) (Question score (upvotes - downvotes)) 72  (https://stackoverflow.com/questions/11560713/generate-insert-script-for-selected-records?noredirect=1&lq=1) Generate insert script for selected records?  (https://stackoverflow.com/q/3719623?lq=1) (Question score (upvotes - downvotes)) 83  (https://stackoverflow.com/questions/3719623/how-do-i-obtain-a-list-of-all-schemas-in-a-sql-server-database?noredirect=1&lq=1) How do I obtain a list of all schemas in a Sql Server database  (https://stackoverflow.com/q/1266960?lq=1) (Question score (upvotes - downvotes)) 46  (https://stackoverflow.com/questions/1266960/sql-query-to-search-schema-of-all-tables?noredirect=1&lq=1) SQL Query to search schema of all tables  (https://stackoverflow.com/q/33024913?lq=1) (Question score (upvotes - downvotes)) 4  (https://stackoverflow.com/questions/33024913/how-to-find-any-missing-columns-constraints-indexes-on-a-database-as-compared?noredirect=1&lq=1) How to find any missing columns, constraints, indexes on a database as compared to another one  (https://stackoverflow.com/q/11666770?lq=1) (Question score (upvotes - downvotes)) 3  (https://stackoverflow.com/questions/11666770/compare-sql-server-db-schema-data-at-the-same-time-and-generate-scripts?noredirect=1&lq=1) Compare SQL Server DB schema & data (at the same time) and generate scripts  (https://stackoverflow.com/q/34304664?lq=1) (Question score (upvotes - downvotes)) 4  (https://stackoverflow.com/questions/34304664/can-i-use-sql-server-project-to-compare-differences-only-in-certain-stored-proce?noredirect=1&lq=1) Can I use SQL Server Project to compare differences ONLY in certain stored procedures?  (https://stackoverflow.com/q/24375679?lq=1) (Question score (upvotes - downvotes)) 0  (https://stackoverflow.com/questions/24375679/sql-comparing-two-stored-procedures-between-databases?noredirect=1&lq=1) SQL Comparing two Stored procedures between databases  (https://stackoverflow.com/questions/linked/685053?lq=1) See more linked questions    Related (https://stackoverflow.com/q/2334712?rq=1) (Question score (upvotes - downvotes)) 4312  (https://stackoverflow.com/questions/2334712/how-do-i-update-from-a-select-in-sql-server?rq=1) How do I UPDATE from a SELECT in SQL Server?  (https://stackoverflow.com/q/25969?rq=1) (Question score (upvotes - downvotes)) 1877  (https://stackoverflow.com/questions/25969/insert-into-values-select-from?rq=1) Insert into ... values ( SELECT ... FROM ... )  (https://stackoverflow.com/q/1293330?rq=1) (Question score (upvotes - downvotes)) 1667  (https://stackoverflow.com/questions/1293330/how-can-i-do-an-update-statement-with-join-in-sql-server?rq=1) How can I do an UPDATE statement with JOIN in SQL Server?  (https://stackoverflow.com/q/60174?rq=1) (Question score (upvotes - downvotes)) 2769  (https://stackoverflow.com/questions/60174/how-can-i-prevent-sql-injection-in-php?rq=1) How can I prevent SQL injection in PHP?  (https://stackoverflow.com/q/167576?rq=1) (Question score (upvotes - downvotes)) 1453  (https://stackoverflow.com/questions/167576/check-if-table-exists-in-sql-server?rq=1) Check if table exists in SQL Server  (https://stackoverflow.com/q/7892334?rq=1) (Question score (upvotes - downvotes)) 1722  (https://stackoverflow.com/questions/7892334/get-size-of-all-tables-in-database?rq=1) Get size of all tables in database  (https://stackoverflow.com/q/653714?rq=1) (Question score (upvotes - downvotes)) 1853  (https://stackoverflow.com/questions/653714/insert-results-of-a-stored-procedure-into-a-temporary-table?rq=1) Insert results of a stored procedure into a temporary table  (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/1586560?rq=1) (Question score (upvotes - downvotes)) 1409  (https://stackoverflow.com/questions/1586560/how-do-i-escape-a-single-quote-in-sql-server?rq=1) How do I escape a single quote in SQL Server?  (https://stackoverflow.com/q/982568?rq=1) (Question score (upvotes - downvotes)) 777  (https://stackoverflow.com/questions/982568/what-is-the-best-way-to-auto-generate-insert-statements-for-a-sql-server-table?rq=1) What is the best way to auto-generate INSERT statements for a SQL Server table?    (https://stackexchange.com/questions?tab=hot) Hot Network Questions   (Politics Stack Exchange)  (https://politics.stackexchange.com/questions/90042/did-the-text-or-terms-of-hunter-bidens-pardon-differ-from-those-previously-issu) Did the text or terms of Hunter Biden's pardon differ from those previously issued by US Presidents? How?   (Japanese Language Stack Exchange)  (https://japanese.stackexchange.com/questions/106569/at-what-age-do-you-start-addressing-people-by-family-names) At what age do you start addressing people by family names   (Law Stack Exchange)  (https://law.stackexchange.com/questions/106316/can-you-be-convicted-of-an-attempted-crime-by-making-an-omission) Can you be convicted of an attempted crime by making an omission?   (Mathematics Educators Stack Exchange)  (https://matheducators.stackexchange.com/questions/28313/list-of-statistics-questions) List of statistics questions   (Earth Science Stack Exchange)  (https://earthscience.stackexchange.com/questions/26707/is-the-southern-hemisphere-colder-than-the-northern-one-or-is-it-just-me) Is the southern hemisphere colder than the northern one or is it just me?   (Science Fiction & Fantasy Stack Exchange)  (https://scifi.stackexchange.com/questions/293449/what-is-in-the-background-of-father-william-balancing-an-eel-on-his-nose) What is in the background of Father William balancing an eel on his nose?   (Science Fiction & Fantasy Stack Exchange)  (https://scifi.stackexchange.com/questions/293401/is-the-doctors-number-ever-mentioned-within-doctor-who) Is the Doctor's number ever mentioned within "Doctor Who"?   (Physics Stack Exchange)  (https://physics.stackexchange.com/questions/836404/how-can-we-neglect-fluctuations-in-the-ising-model-with-mean-field-approximation) How can we neglect fluctuations in the Ising model with mean field approximation?   (Bitcoin Stack Exchange)  (https://bitcoin.stackexchange.com/questions/124950/what-is-the-actual-weight-of-the-bitcoin-blockchain) What is the actual weight of the bitcoin blockchain?   (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   (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?   (TeX - LaTeX Stack Exchange)  (https://tex.stackexchange.com/questions/732379/trim-spaces-off-end-of-a-tex-command-argument) Trim spaces off end of a TeX command argument   (Home Improvement Stack Exchange)  (https://diy.stackexchange.com/questions/311129/why-is-my-sink-draining-slowly) Why is my sink draining slowly?   (English Language & Usage Stack Exchange)  (https://english.stackexchange.com/questions/627826/is-there-really-any-positive-use-of-abet-if-so-when-and-how-did-it-develop) Is there really any positive use of "abet"? If so, when and how did it develop?   (Open Source Stack Exchange)  (https://opensource.stackexchange.com/questions/15245/how-technically-and-legally-sell-foss-software-with-commercial-license) How technically and legally sell FOSS software with commercial license?   (Physics Stack Exchange)  (https://physics.stackexchange.com/questions/836230/what-is-the-meaning-of-universal-speed-limit) What is the meaning of universal speed limit?   (English Language & Usage Stack Exchange)  (https://english.stackexchange.com/questions/627801/single-noun-for-what-is-being-emphasised) Single noun for what is being emphasised?   (MathOverflow)  (https://mathoverflow.net/questions/483687/is-the-set-of-generalized-fermat-triples-computable) Is the set of generalized Fermat triples computable?   (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?   (Seasoned Advice)  (https://cooking.stackexchange.com/questions/129721/what-happened-to-my-croissant-dough-when-i-left-it-in-the-fridge-overnight) What happened to my croissant dough when I left it in the fridge overnight?   (Skeptics Stack Exchange)  (https://skeptics.stackexchange.com/questions/57525/do-all-the-li-ion-batteries-in-the-world-have-just-enough-power-to-meet-peak-dem) Do all the Li-ion batteries in the world have just enough power to meet peak demand in the U.S.?   (Puzzling Stack Exchange)  (https://puzzling.stackexchange.com/questions/129561/pse-advent-calendar-2024-day-6-colorful-gifts) PSE Advent Calendar 2024 (Day 6): Colorful Gifts   (Worldbuilding Stack Exchange)  (https://worldbuilding.stackexchange.com/questions/263375/how-to-map-small-and-dense-floating-islands) How to map small and dense floating islands?   (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"?       ()   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