I have better info this time
-
Hey,
My company is going to add sql server and get most of the data from as/400. I believe the only way to do this is dts.
I am to research the best way to do this and I am also to create an odbc so I can retrieve data from access through sql server. Access has a lot of data in it over 50,000 records. I am not sure the easiest and smartest way to go about doing this.
Have a great day Everyone
Thanks,
Sharri
-
To answer the question I think you are asking, yes, DTS is the best way of transferring data between an AS/400 and SQL Server. Also, if you have 50,000 records in an access database, the best way of transferring it is DTS.
Basically, if you want to transfer from the AS/400, all you need to do is make sure that you have the AS/400 utilities installed on your development system and when you go to the ODBC in your Control Panel and create a connection to the AS/400. Then, after that you go into the DTS designer and add a new "Other Connection". Tell it you want to use an Existing Connection, then selec the User/System DSN and select the ODBC connection you created above. Then, you build your transfer just like you would through any other DTS packages.
We have used this extensively where I work, so I know that it works and is very rapid in doing what you want it to. If you have fast connections, it could take you less than 3 minutes to transfer all 50,000 records. We use DTS for a lot, and it is a VERY powerful utility
-
Another option is to create a linked server and use distributed queries to get the data. This is the method we use, however, if you need to transform the data as well, DTS is the way to go.
Linda
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply