| postings@alexshirley.com 2005-07-28, 11:36 am |
| Hi there
Please forgive the very basic question.
I have two SQL Server 2000 databases.
The source database contains data I need to port, and the destination
database is a mere shell of tables ready to accept the data. Once
it's all in my new ASP.NET should be up and ready to run with live
data.
All I need to do is copy the data across, table by table I guess. I
must have the primary keys ported across. Also some columns may be
named differently or be in a different order, and some may be the same
(so I guess some mapping has to happen).
Could somebody give me some advice here, or pointers to some
documentation? I guess I should be using the DTS Export wizard. I
really need to keep things as simple as possible. Are there some cheap
third party packages that do a better job? Note I understand enough
about referential integrity to work out which table gets copied over
first.
It's a tall order, and it has to be ready by Monday!
Many thanks
Alex
|