Question

Locked

sqlserver2000

By nagarenuka9 ·
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

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

Several ways

by Tony Hopkinson In reply to sqlserver2000

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.

Back to Software Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums