Software

Ask something
Question Locked

sqlserver2000

0 helpful
2 replies

by nagarenuka9

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

hi,

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

2 replies

by tony hopkinson

DTS.
Querying
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.

This discussion is closed to new replies.