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?
· Share on Twitter

Comments

  • TilmanTilman Posts: 395 Bronze 2
    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:

    /include:table:^^ABC

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

    Regards,

    Tilman
    · Share on Twitter
  • judesjudes Posts: 12
    Ok, thanx for the help!
    · Share on Twitter
This discussion has been closed.