Re: Comparing table structures between databases
From: Michael W (MrNoSpam_at_yashoo.com)
Date: 09/02/04
- Next message: DeeJay Puar: "Problem with Index Tuning Wizard"
- Previous message: Keith Kratochvil: "Re: How to retrieve sa password on Win98?"
- In reply to: Peter The Spate: "Comparing table structures between databases"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 2 Sep 2004 14:23:35 +0100
Thanks, Peter.
That looks like it will do all I need and more.
Regards,
Mike
"Peter The Spate" <anonymous@discussions.microsoft.com> wrote in message
news:4bbe01c490da$17ef8560$a601280a@phx.gbl...
> Unfortunatly no there isn't an easy way.
>
> If you have connection to the internet log on to the site
> http://www.adeptsql.com/download.htm and download AdeptSQL
> Diff ver 1.6.
>
> We have used that for all our server and works very well.
>
> N.B. You can program it yourself in SQL but will take a
> bit of time, and this will hi-light every difference.
>
> Peter
>
> "What makes him think a middle aged actor [Clint
> Eastwood], who's played with a chimp, could have a future
> in politics?"
> Ronald Reagan
>
>
> >-----Original Message-----
> >What is the easiest way to compare the table structure of
> two databases?
> >
> >I have inherited a project and have found a couple of
> undocumented
> >inconsistencies between the development and production
> databases.
> >
> >Is there an in-built function or a utility that can help
> with this?
> >
> >Thanks,
> >
> >Mike
> >
> >
> >.
> >
- Next message: DeeJay Puar: "Problem with Index Tuning Wizard"
- Previous message: Keith Kratochvil: "Re: How to retrieve sa password on Win98?"
- In reply to: Peter The Spate: "Comparing table structures between databases"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
