how to compare structure?

Hi,
I encounter many problems while trying to
sincronise my data in sql server. Give an example : if i
have a new scripts, how do i ensure the table generate by
this scripts will have the same as the table's structure
which currently exist in database.
another example, if i have database A and new
database B, how i ensure that table in database A has the
same structure for the table in database B. If the table
in database A is not enough, how do i update the
structure in table A so that same with database B? Can
SQL server help me to generate a scripts that alter or
create table that into database A after compare with
database B?
In summary, how to sincronize old table
structure with new table structure in two different
datable?
Thank you very much.
regards,
florencePerhaps below?
http://www.red-gate.com/SQL_Compare.htm
--
Tibor Karaszi
"florence" <florencelee@.visualsolutions.com.my> wrote in message
news:110201c3a21b$c810b260$a301280a@.phx.gbl...
> Hi,
> I encounter many problems while trying to
> sincronise my data in sql server. Give an example : if i
> have a new scripts, how do i ensure the table generate by
> this scripts will have the same as the table's structure
> which currently exist in database.
> another example, if i have database A and new
> database B, how i ensure that table in database A has the
> same structure for the table in database B. If the table
> in database A is not enough, how do i update the
> structure in table A so that same with database B? Can
> SQL server help me to generate a scripts that alter or
> create table that into database A after compare with
> database B?
> In summary, how to sincronize old table
> structure with new table structure in two different
> datable?
> Thank you very much.
> regards,
> florence|||Florence,
Please check DB Ghost at www.dbghost.com This tool has
transformed our database change control processes and is
ideal for the tasks you describe.
Thanks,
Darren Fuller MCSE
>--Original Message--
>Hi,
> I encounter many problems while trying to
>sincronise my data in sql server. Give an example : if i
>have a new scripts, how do i ensure the table generate
by
>this scripts will have the same as the table's structure
>which currently exist in database.
> another example, if i have database A and new
>database B, how i ensure that table in database A has
the
>same structure for the table in database B. If the table
>in database A is not enough, how do i update the
>structure in table A so that same with database B? Can
>SQL server help me to generate a scripts that alter or
>create table that into database A after compare with
>database B?
> In summary, how to sincronize old table
>structure with new table structure in two different
>datable?
> Thank you very much.
>regards,
>florence
>.
>