data extraction/mapping between two databases

Hi ,
just wondering, whats the easiest way to map about 10000 rows from database
a (old) to database b.
the complexity is that the structure is completely different, database b is
more normalized. has relationships maintained..where as database a has
everything in one table ..So I have to map one column (choose distinct rows)
and move to datbase b.new table...
I did try DTS for couple of them..but seems tedious and never ending..
Whats the easiest way to do this? any OR tools ' anything ...
Thanks,I'd just understand the data, and then populate tables manually, using
INSERT statements, to populate the primary key and foreign key tables.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Mani" <mani@.spamthis@.evikasystems.com> wrote in message
news:eACFDzamEHA.1904@.TK2MSFTNGP09.phx.gbl...
Hi ,
just wondering, whats the easiest way to map about 10000 rows from database
a (old) to database b.
the complexity is that the structure is completely different, database b is
more normalized. has relationships maintained..where as database a has
everything in one table ..So I have to map one column (choose distinct rows)
and move to datbase b.new table...
I did try DTS for couple of them..but seems tedious and never ending..
Whats the easiest way to do this? any OR tools ' anything ...
Thanks,

data extraction/mapping between two databases

Hi ,
just wondering, whats the easiest way to map about 10000 rows from database
a (old) to database b.
the complexity is that the structure is completely different, database b is
more normalized. has relationships maintained..where as database a has
everything in one table ..So I have to map one column (choose distinct rows)
and move to datbase b.new table...
I did try DTS for couple of them..but seems tedious and never ending..
Whats the easiest way to do this? any OR tools ? anything ...
Thanks,
I'd just understand the data, and then populate tables manually, using
INSERT statements, to populate the primary key and foreign key tables.
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Mani" <mani@.spamthis@.evikasystems.com> wrote in message
news:eACFDzamEHA.1904@.TK2MSFTNGP09.phx.gbl...
Hi ,
just wondering, whats the easiest way to map about 10000 rows from database
a (old) to database b.
the complexity is that the structure is completely different, database b is
more normalized. has relationships maintained..where as database a has
everything in one table ..So I have to map one column (choose distinct rows)
and move to datbase b.new table...
I did try DTS for couple of them..but seems tedious and never ending..
Whats the easiest way to do this? any OR tools ? anything ...
Thanks,

Daily Backups SQL 2005 Standard Edition

With SQL 2000 I was backing up to a NAS server by mapping a drive share to
Z. Is there a reason that I cannot do this in SQL 2005 now or should I be
focused on a networking issue?
Thanks!
ChrisBackups are always done with the privileges of the account SQL Server is
running under. Does this account have access to that share? You never want
to use mapped drives. Use UNC pathing instead.
Andrew J. Kelly SQL MVP
"Chris Marsh" <cmarsh@.synergy-intl.com> wrote in message
news:eRk0J22LGHA.420@.tk2msftngp13.phx.gbl...
> With SQL 2000 I was backing up to a NAS server by mapping a drive share to
> Z. Is there a reason that I cannot do this in SQL 2005 now or should I be
> focused on a networking issue?
> Thanks!
> Chris
>

Daily Backups SQL 2005 Standard Edition

With SQL 2000 I was backing up to a NAS server by mapping a drive share to
Z. Is there a reason that I cannot do this in SQL 2005 now or should I be
focused on a networking issue?
Thanks!
Chris
Backups are always done with the privileges of the account SQL Server is
running under. Does this account have access to that share? You never want
to use mapped drives. Use UNC pathing instead.
Andrew J. Kelly SQL MVP
"Chris Marsh" <cmarsh@.synergy-intl.com> wrote in message
news:eRk0J22LGHA.420@.tk2msftngp13.phx.gbl...
> With SQL 2000 I was backing up to a NAS server by mapping a drive share to
> Z. Is there a reason that I cannot do this in SQL 2005 now or should I be
> focused on a networking issue?
> Thanks!
> Chris
>

Daily Backups SQL 2005 Standard Edition

With SQL 2000 I was backing up to a NAS server by mapping a drive share to
Z. Is there a reason that I cannot do this in SQL 2005 now or should I be
focused on a networking issue?
Thanks!
ChrisBackups are always done with the privileges of the account SQL Server is
running under. Does this account have access to that share? You never want
to use mapped drives. Use UNC pathing instead.
--
Andrew J. Kelly SQL MVP
"Chris Marsh" <cmarsh@.synergy-intl.com> wrote in message
news:eRk0J22LGHA.420@.tk2msftngp13.phx.gbl...
> With SQL 2000 I was backing up to a NAS server by mapping a drive share to
> Z. Is there a reason that I cannot do this in SQL 2005 now or should I be
> focused on a networking issue?
> Thanks!
> Chris
>