Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2003
    Location
    Dallas, TX
    Posts
    1,004

    Question Unanswered: How to move from A2K to SQL Server2000

    Hi gang,

    Just trying to get some information on what is required to migrate from Access 2000 to SQL Server?? Is it pretty difficult to do? Are there any changes to the data or structure that is needed? Is SQL Server more secure? What about MSDE instead of SQL?? I'm just needing some tips and info on what to expect and all as I think we are going there kinda soon. I can do many things in Access but not sure how to go about them in SQL Server? Can you also do reports from there as well?

    Inquiring mind wants to know
    have a nice one,
    Bud

  2. #2
    Join Date
    Jul 2004
    Location
    Inverurie
    Posts
    628
    have you tried looking at the books online for SQL server? it should tell you in there.

  3. #3
    Join Date
    Dec 2003
    Location
    Dallas, TX
    Posts
    1,004
    Quote Originally Posted by cruickshanks
    have you tried looking at the books online for SQL server? it should tell you in there.

    As of yet I haven't looked anywhere as I was not sure where to start looking, so I came over to this side of the forum. Guess I'll have to find hopefully the right books that might be able to tell me about all the stuff I asked about.

    thanks

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Not really...

    http://www.dbforums.com/t1008694.html

    My advice would be to trash access.....

    Most existing access "apps" don't port very well....
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

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