Suggestions please on the best method of transferring data

Suggestions please on the best method of transferring data

Post by Greg Hine » Fri, 19 Jan 2001 07:59:26



Hello all,

Our application was first developed using an access97 DB and has since been
upgraded to use an MSDE DB.  While the data in the DB is basically the same
the table structure in the MSDE has been normalized quite a bit and uses a
lot more smaller tables.

We now have the task of exporting the data from the access97 DB into the
newer MSDE DB so that our clients can use the new application.

What is the best method to accomplished this??  Any ideas appreciated.  I
was thinking about exporting the access97 data into a delimited file and
using BCP - Good or Bad idea??

Thanks in advance,

Greg
--

Remove NOSPAM when replying

 
 
 

1. Suggestions please on best method of transferring data

Hello all,

Our application was first developed using an access97 DB and has since been
upgraded to use an MSDE DB.  While the data in the DB is basically the same
the table structure in the MSDE has been normalized quite a bit and uses a
lot more smaller tables.

We now have the task of exporting the data from the access97 DB into the
newer MSDE DB so that our clients can use the new application.

What is the best method to accomplished this??  Any ideas appreciated.  I
was thinking about exporting the access97 data into a delimited file and
using BCP - Good or Bad idea??

Thanks in advance,

Greg

--

Remove NOSPAM when replying

2. information regarding prism tool

3. What is best data transfer method?

4. Oracle DBAs & Project Managers needed-U.S.-(Recruiter)

5. Suggestions for a good SQL book, please...

6. Can't connect from Cllient computer

7. Good Flowchart Program Suggestion Please

8. DDE Controllable, OLE client program-that-makes GIF's

9. Good Flowchart Program Suggestion Please.

10. Need some suggestions at best practices asap please...

11. Please tell me the best 815 to 816 migrate method

12. Looking for suggestions on a good data grid.

13. Need suggestion for buying a good book tolearn data base programming using visual c++