What are the challenges you face when working across database platforms? Take the survey
Options

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?

Comments

  • Options
    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
  • Options
    Ok, thanx for the help!
This discussion has been closed.