Data Imprort scripts

Hi All,
I am trying to copy data from Sql 7.0 to Sql 2005. The structures in
both the database is very different. I cannot just map the fileds from
one db.table to another db.table
I will have to write a script tha would insert data in the new
db.table.
One table in the new database will need to be mapped to multiple
tables/fields from the old database.
For eg. The users table in the new database will need to be populated
with data from users and login table from the old database.
Does anyone have sample script I can use? Or point me the right
direction?
Thanks in advance!
MumbaiChefOne approach to consider is to write views on the source server that
return result sets that match the definition of the tables on the
target server. Then you can use DTS to copy the data, reading the
views on the source and writing to the tables on the target.
Another approach would be to define the 7.0 server as a linked server
on the 2005 system. This would allow directly referencing the tables
on the source server from the target.
Roy Harvey
Beacon Falls, CT
On 2 May 2006 05:41:14 -0700, mumbaichef@.gmail.com wrote:

>Hi All,
>I am trying to copy data from Sql 7.0 to Sql 2005. The structures in
>both the database is very different. I cannot just map the fileds from
>one db.table to another db.table
>I will have to write a script tha would insert data in the new
>db.table.
>One table in the new database will need to be mapped to multiple
>tables/fields from the old database.
>For eg. The users table in the new database will need to be populated
>with data from users and login table from the old database.
>Does anyone have sample script I can use? Or point me the right
>direction?
>Thanks in advance!
>MumbaiChef|||How do I make do the linked server? Sorry, for the basic question, I am
new to this:)
I created a SSIS package and saved it in SQL Server. But I am not able
to open it or find it!!!
Any ideas?
Thanks
MumbaiChef|||I'd never set one up in 2005 before, but is seems pretty straight
forward.
In SQL Server Management Studio, under Server Objects, right click on
Linked Servers. Choose New Linked Server...
Give it the name of the 7.0 server as a SQL Server. You will also
have to tell it something under Security. I just got it to work on my
system (defind a linked 2000 server) by choosing the option that
logins not listed at the top use the login's current security context.
Once I had done that I was able to query the other server by adding
the server qualifier:
select *
from OtherServerName.master.dbo.sysobjects
Good luck!
Roy
On 2 May 2006 06:46:07 -0700, mumbaichef@.gmail.com wrote:

>How do I make do the linked server? Sorry, for the basic question, I am
>new to this:)
>I created a SSIS package and saved it in SQL Server. But I am not able
>to open it or find it!!!
>Any ideas?
>Thanks
>MumbaiChef