Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2003
    Location
    Pensylvania - USA
    Posts
    15

    Unanswered: Converting Access 2000 to SQL

    Ok, I finally figured out SQL somewhat. I cannot upsize all of my databases using the upsize wizard provided with Access 2000. I can upsize some database, but most importantly, not the one I need to upsize. Does anybody have any idea why some would upsize and some wouldn't? Could it be a problem with linked tables? OR is there any other way of converting the access databases into SQL databases for SQL Server 2000? Remember, I am a very first time SQL user.
    Thanks a lot,
    Aaron Shover

  2. #2
    Join Date
    Dec 2002
    Location
    Antwerp, Belgium
    Posts
    227
    with SQL Server a very handy tool is delivered: Data Transformation Services (DTS). You can use DTS to transform data from one source to another for all major databases, office applications, text files and more. If you are willing to convert to SQL Server this is probably the way to go. You can search in the Books Online for more info.
    You can also set up your Access databases as linked servers to access them from SQL server, but conversion is probably better.
    Johan

  3. #3
    Join Date
    Jul 2003
    Location
    Pensylvania - USA
    Posts
    15
    I found the DTS and I used it. Now, this database has a front end and a backend. When I transferred the front end all it allowed me to transfer were the queries. So then I had to go to the back end and transfer the backend in order to transfer the tables. I assume this is because of the database being split, and if it wasn't it would allow me to do both at the same time?

  4. #4
    Join Date
    Jul 2002
    Location
    Australia
    Posts
    147
    well the tables aren't located in the front end - how can they be transferred??

    They are only *linked* to the tables in the back end.
    There have been many posts made throughout the world.
    This was one of them.

  5. #5
    Join Date
    Jul 2003
    Location
    Pensylvania - USA
    Posts
    15
    That's what I thought; I just wanted conformation so I understand everything that is going on.
    "Me only have one ambition, y'know. I only have one thing I really like to see happen. I like to see mankind live together - black, white, Chinese, everyone - that's all."
    - Bob Marley

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •