DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: Upsizing from access 97 to sql server 7

Hybrid View

  1. #1
    John Wood Guest

    Upsizing from access 97 to sql server 7

    Do you have any experience with this? I have a access 97 db (tables
    only) that I want to upsize. I tried to pull it from the sql server side
    using the data transformation services export feature in Enterprise
    Manager but lost keys and indexes. I re-established the keys. I could
    read from the db using vb and ado butcould not figure out how to write
    to it.

    I then tried to push the db from the access side using the access
    upsizing tool (which is very poorly documented by the way) with no luck
    so far. I have checked the MSDN site for technical articles on this but
    again poorly documented.

    The few articles that are posted don't help much.

    Any advice?

    John Wood




  2. #2
    Francisco Guest

    Re: Upsizing from access 97 to sql server 7


    in DTS Did you try copying objects option?





    John Wood <jwood@co.sarasota.fl.us> wrote:
    >Do you have any experience with this? I have a access 97 db (tables
    >only) that I want to upsize. I tried to pull it from the sql server side
    >using the data transformation services export feature in Enterprise
    >Manager but lost keys and indexes. I re-established the keys. I could
    >read from the db using vb and ado butcould not figure out how to write
    >to it.
    >
    >I then tried to push the db from the access side using the access
    >upsizing tool (which is very poorly documented by the way) with no luck
    >so far. I have checked the MSDN site for technical articles on this but
    >again poorly documented.
    >
    >The few articles that are posted don't help much.
    >
    >Any advice?
    >
    >John Wood
    >
    >
    >



  3. #3
    John Wood Guest

    Re: Upsizing from access 97 to sql server 7

    Since the Access db is made up of tables only, I resorted to doing an import
    from the sql side and then creating the keys, indexes and relationships in
    sql server. I am able to write ok now.
    JW

    Francisco wrote:

    > in DTS Did you try copying objects option?
    >
    > John Wood <jwood@co.sarasota.fl.us> wrote:
    > >Do you have any experience with this? I have a access 97 db (tables
    > >only) that I want to upsize. I tried to pull it from the sql server side
    > >using the data transformation services export feature in Enterprise
    > >Manager but lost keys and indexes. I re-established the keys. I could
    > >read from the db using vb and ado butcould not figure out how to write
    > >to it.
    > >
    > >I then tried to push the db from the access side using the access
    > >upsizing tool (which is very poorly documented by the way) with no luck
    > >so far. I have checked the MSDN site for technical articles on this but
    > >again poorly documented.
    > >
    > >The few articles that are posted don't help much.
    > >
    > >Any advice?
    > >
    > >John Wood
    > >
    > >
    > >



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center