Filter with like criteria?

judesjudes Posts: 12
edited June 15, 2006 11:02AM in SQL Compare Previous Versions
What if I know the tables that are different from one db to the next all start with a certain group of letters such as ABC%. How would I do a Sql Compare to have only these tables presented so that I could generate scripts for a select set of table objects?


  • Hi,

    Thanks for your question. I'm afraid you can't do this with the SQL Compare UI. You can do it with the SQL Compare command line, however. To only include tables that start with 'ABC' add the following switch to the command line:


    For more information on the command lines, please refer to the SQL Bundle help.


  • Ok, thanx for the help!
This discussion has been closed.