Does anyone know of some good tools to extract sqlserver schema information, including the stored procedure definitions, and output them in a form suitable for comparison (XML perhaps ). It needs to be able to run in ant or have an api to write to and extra points if it can do the diffing between extracts.
Schema extraction and comparisons
Hot Topic
- Using just stored procedures to create and delete users
- Unable to select a Single Provider in Web Site Admin Tool
- Is this possible?
- Transactional Replication sp question
- How connect SQL server 2000 with c#.net .....?
- Table partitioning with multiple keys coulmns
- Max value
- Possible Concurrency Issues.
- Installing Sql Server 2005 Trial Software From Microsoft Website - Self Extracting Executable
- connection string for xml file in ssrs
SQL Server
- Do I need DatePart or similar
- Using the same connection in multiple threads -> native exception
- AcquireConnection(txn) ???
- Report task?
- Installation of SQL Express
- combining 2 select with count and datediff into 1 select. need help.
- Unable to synchronize the row because the row was updated by a different process outside of replication.
- SQL Agent Failing when trying to run my SSIS Package
- Sql server with Source Control
- RS 2005 run on SQL Server 2000 Database?
Schema extraction and comparisons
Boris Jabes MSFT
Hello,
You may want to see Kentico Compare SQL - http://www.comparesql.com. It compares database table schemas, procedures, views and functions. It's now available for only $49!
Frank0824
Don't re-invent the wheel and use 3rd party utility to compare the structure and the data of your SQL Server databases, like ApexSQL, Red-Gate ... tool.
You can also use this free tool :
http://www.sqldbtools.com/Tools.aspx