|
Home > Archive > MS SQL Server DTS > July 2005 > Tranfering tables from one database to another
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Tranfering tables from one database to another
|
|
| 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
| |
| Allan Mitchell 2005-07-28, 1:39 pm |
| The wizard will allow you to do this yes and yes it will require some
mapping on your part. The PKs etc I presume are already on the destination.
If you had said that this was a straight pick up and drop then I would have
preferred to use BACKUP and RESTORE
The wizard will allow you to point source table to destination table and do
some mappings. It is less flexible than the designer itself but to do this
in the designer would require you to setup each Data Pump yourself.
--
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know
< postings@alexshirley
.com> wrote in message
news:1122567151.019478.8180@z14g2000cwz.googlegroups.com...
> 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
>
|
|
|
|
|