By nagarenuka9 ·

This is Renu I am doing an telecom domain project so from this my question is ,i had data in one database and in another database there is no data so how can i connect the one database from the another database no common fields is also there how can i give me the answer

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Several ways

by Tony Hopkinson In reply to sqlserver2000

Writing a lot of code.

Step one though is a mapping. Of 'old' tables to new ones.

Personally I'd create the empty database on a server with the full one on it. Or at least some real data .

Then start testing out waht you need to do

with Insert into NewDB..NewTable Select .... From OldDB..OldTable

DTS will do a lot of that for you but you neded a clear idea of what you are going to do first.

Related Discussions

Related Forums