August 13th, 2004, 07:11 AM
|
|
Junior Usher
|
|
Join Date: Feb 2003
Posts: 35
Time spent in forums: 2 h 8 m 28 sec
Reputation Power: 6
|
|
|
Comparing table structure
I am writing an App to upload db based web Apps from one server to another. i.e Dev -> Testing -> Staging -> Production. I need to be able to compare the table structure of the source db tables to the target db tables, and the results processed in .Net.
I have access to the syscolumns object in MS SQL, but I would like some hints as to the best way to do this. I could for instance get the columns and compare them, but the question is where is the best place to do that.
__________________
"Whoever fights monsters should see to it that in the process he does not become a monster."
"Stare too long into the abyss, and the abyss will stare into you."
- Friedrich Nietzsche
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
