Articles filed in category 'SQL Compare'

Create Your Own SQL Compare Utility Using GetSchema()

By: Paul Sheriff

Last updated: Friday, February 24, 2023

Published in: CODE Magazine: 2023 - March/April

Learn how to use the GetSchema() method on the DbConnection class to retrieve tables, views, columns, index, stored procedures, and more from any database system. Create an instance of the SqlConnection or OracleConnection, or your own provider's implementation of the DbConnection class, and pass a valid connection string to the constructor to use the GetSchema() method.

• Data
• Data Warehousing
• Database
• SQL Compare
• SQL Server
• SQL Server 2016
• Stored Procedures
• Third-Party Tools