How to limit a SQL Data Comparison based on the first character of the table name?
I'm creating a script to migrate the changes from one database to another one, but the database is very large. I'd like to limit the script based on the first character of the table name (Tables beginning with non-alphanumeric characters, tables that start with the letter 'a', etc.) to I can run the process as a series of smaller scripts instead of one large one. I saw in the documentation how you can limit it to include table names that contain a certain phrase, but I'm not looking to filter it by words that contain the letter 'a' for example, but by those that start with that character. The script is a Powershell script, so I would need to accomplish this with command line. How would I do this?
0 · Share on Twitter