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