Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
silas2
Yak Posting Veteran
65 Posts |
 Posted - 2005-04-26 : 13:48:54
|
| I’m a Jet/DAO developer who’s recently started to use MSDE/SQL Server – I wrote a quick utility using DAO to compare two mdbs, tables/fields/relations/indexes/etc. so that I could quickly ascertain in what way a client’s backend had become out of date - but its producing funny results against linked SQL Server tables. I’ve just switched to MSDE, is there a utility floating around that does the same thing Sqlserver-sqlserver schemas? SQLServer-mdb would be useful as well as I'm trying to maintain two different back-end db formats to the same front end. |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2005-04-26 : 16:04:58
|
| As I'm reading your post, there is this ad at the top of the page that is flashing messages about a software product from red-gate software that allows you to "compare and synchronize SQL Server databases". You might check into it.Another option would be to have a basic text-file comparison tool run a comparison of the SQL build scripts. If you have not been using scripts to build/maintain the SQL Server, first, I suggest you get into that habit and second, you can have Enterprise Manager generate a script reflecting the current schema for you.---------------------------EmeraldCityDomains.com |
 |
|
|
|
|
|
Schema Comparison Utils