|
|
How to update tables with a newer version |
|
Author |
Message |
J4sstrom
|
Posted: Thu Mar 02 06:55:52 CST 2006 |
Top |
SQL Server >> How to update tables with a newer version
Hi all. I have that problem:
I have a database that other person is updating. I have my tables with data,
and a new version of the whole database.
Is there a way to update the tables so they reflect the changes? If not, I
should do it manually, seeing if some fields have changed, relations...
Is there a way to do it manually?
--
Regards,
Diego F.
SQL Server54
|
|
|
|
|
Uri
|
Posted: Thu Mar 02 06:55:52 CST 2006 |
Top |
SQL Server >> How to update tables with a newer version
Diego
If I understood you properly you need something like that
UPDATE TableName1 SET
Factory=t2 .factoryno,Dept=t2 .deptno
FROM TableName2 t2 INNER JOIN TableName1 t1
ON t1.Empno=t2.Employeeno AND
( t1.Factory<>t2.factoryno OR t1.Dept<>t2.deptno OR.........)
> Hi all. I have that problem:
>
> I have a database that other person is updating. I have my tables with
> data, and a new version of the whole database.
>
> Is there a way to update the tables so they reflect the changes? If not, I
> should do it manually, seeing if some fields have changed, relations...
>
> Is there a way to do it manually?
>
> --
> Regards,
>
> Diego F.
>
>
|
|
|
|
|
Diego
|
Posted: Thu Mar 02 09:19:33 CST 2006 |
Top |
SQL Server >> How to update tables with a newer version
The fact is that I have many tables, so I'm looking for a kind of wizard to
do that. Is it possible?
It is possible also to have new relationships.
--
Regards,
Diego F.
> Diego
> If I understood you properly you need something like that
>
> UPDATE TableName1 SET
> Factory=t2 .factoryno,Dept=t2 .deptno
> FROM TableName2 t2 INNER JOIN TableName1 t1
> ON t1.Empno=t2.Employeeno AND
> ( t1.Factory<>t2.factoryno OR t1.Dept<>t2.deptno OR.........)
>
>
>
>
>> Hi all. I have that problem:
>>
>> I have a database that other person is updating. I have my tables with
>> data, and a new version of the whole database.
>>
>> Is there a way to update the tables so they reflect the changes? If not,
>> I should do it manually, seeing if some fields have changed, relations...
>>
>> Is there a way to do it manually?
>>
>> --
>> Regards,
>>
>> Diego F.
>>
>>
>
>
|
|
|
|
|
Terri
|
Posted: Fri Mar 03 10:14:34 CST 2006 |
Top |
SQL Server >> How to update tables with a newer version
If I understand you correctly you have two different databases and you want
to compare and synchronize. This third party tool can do this.
http://www.red-gate.com/products/SQL_Data_Compare/index.htm
Otherwise you would have to write the code yourself.
> The fact is that I have many tables, so I'm looking for a kind of wizard
to
> do that. Is it possible?
>
> It is possible also to have new relationships.
>
> --
> Regards,
>
> Diego F.
>
>
> > Diego
> > If I understood you properly you need something like that
> >
> > UPDATE TableName1 SET
> > Factory=t2 .factoryno,Dept=t2 .deptno
> > FROM TableName2 t2 INNER JOIN TableName1 t1
> > ON t1.Empno=t2.Employeeno AND
> > ( t1.Factory<>t2.factoryno OR t1.Dept<>t2.deptno OR.........)
> >
> >
> >
> >
> >> Hi all. I have that problem:
> >>
> >> I have a database that other person is updating. I have my tables with
> >> data, and a new version of the whole database.
> >>
> >> Is there a way to update the tables so they reflect the changes? If
not,
> >> I should do it manually, seeing if some fields have changed,
relations...
> >>
> >> Is there a way to do it manually?
> >>
> >> --
> >> Regards,
> >>
> >> Diego F.
> >>
> >>
> >
> >
>
>
|
|
|
|
|
Diego
|
Posted: Fri Mar 03 11:23:36 CST 2006 |
Top |
SQL Server >> How to update tables with a newer version
I'll try to explain better.
I'm working with a large database (about 300 tables). Other person is
updating the database structure (adding some fields to tables, maybe new
relationships...) and I have a backup of that new version.
I need to upgrade my database. I discard the option of adding all that
changes manually. I ask for a tool that can update that changes without
losing the tables rows or relationships between tables.
The only thing that I can think about is creating a new database with the
backup and moving the data from one DB to the other, but I'm not sure about
how to do that.
--
Regards,
Diego F.
> If I understand you correctly you have two different databases and you
> want
> to compare and synchronize. This third party tool can do this.
> http://www.red-gate.com/products/SQL_Data_Compare/index.htm
>
> Otherwise you would have to write the code yourself.
>
>
>> The fact is that I have many tables, so I'm looking for a kind of wizard
> to
>> do that. Is it possible?
>>
>> It is possible also to have new relationships.
>>
>> --
>> Regards,
>>
>> Diego F.
>>
>>
>> > Diego
>> > If I understood you properly you need something like that
>> >
>> > UPDATE TableName1 SET
>> > Factory=t2 .factoryno,Dept=t2 .deptno
>> > FROM TableName2 t2 INNER JOIN TableName1 t1
>> > ON t1.Empno=t2.Employeeno AND
>> > ( t1.Factory<>t2.factoryno OR t1.Dept<>t2.deptno OR.........)
>> >
>> >
>> >
>> >
>> >> Hi all. I have that problem:
>> >>
>> >> I have a database that other person is updating. I have my tables with
>> >> data, and a new version of the whole database.
>> >>
>> >> Is there a way to update the tables so they reflect the changes? If
> not,
>> >> I should do it manually, seeing if some fields have changed,
> relations...
>> >>
>> >> Is there a way to do it manually?
>> >>
>> >> --
>> >> Regards,
>> >>
>> >> Diego F.
>> >>
>> >>
>> >
>> >
>>
>>
>
>
>
|
|
|
|
|
|
|