SQL License Question

Discussion in 'OT Technology' started by michelin man, Jan 9, 2003.

  1. michelin man

    michelin man IDB Construction

    Joined:
    Jul 22, 2001
    Messages:
    11,660
    Likes Received:
    0
    Location:
    Austin
    I need to move some access table over to SQL due to the size restraints of Access.

    if 5 or 10 people are connection to the SQL tables through Access do I need a license for each person that connects to SQL?
     
  2. 5Gen_Prelude

    5Gen_Prelude There might not be an "I" in the word "Team", but

    Joined:
    Mar 14, 2000
    Messages:
    14,519
    Likes Received:
    1
    Location:
    Vancouver, BC, CANADA
  3. michelin man

    michelin man IDB Construction

    Joined:
    Jul 22, 2001
    Messages:
    11,660
    Likes Received:
    0
    Location:
    Austin

    ????
     
  4. 5Gen_Prelude

    5Gen_Prelude There might not be an "I" in the word "Team", but

    Joined:
    Mar 14, 2000
    Messages:
    14,519
    Likes Received:
    1
    Location:
    Vancouver, BC, CANADA
    Well exactly what limitations are you running into. I mean, I have over 4 gigs of data linked into one database, so the 1 gig limit doesn't really affect me. It just forces you to be a little more clever with how the data is organized.
     
  5. michelin man

    michelin man IDB Construction

    Joined:
    Jul 22, 2001
    Messages:
    11,660
    Likes Received:
    0
    Location:
    Austin
    I have 3 databases with one table in each. The current size for each is over a gig. I know I could bring them all together in one db by linking them. Then do a Union Query, and then speed becomes a major issue.

    I'm open to other ideas.
     
  6. 5Gen_Prelude

    5Gen_Prelude There might not be an "I" in the word "Team", but

    Joined:
    Mar 14, 2000
    Messages:
    14,519
    Likes Received:
    1
    Location:
    Vancouver, BC, CANADA
    a) do you really need all of that data in one table?
    b) how many fields are in each record? You could use a 1-1 relationship for info that isn't needed.
    c) how many indexes are you using?
    d) can you archive the data?

    Is there any duplicate information? ie For each order in an order entry system you are recording the last name first name etc... instead of just a pointer to the customer.

    BTW, as I found out today, union queries only really work well if you make a table with the result set. The side benefit of it actually working instead of giving you a bunch of crap results is that it's much faster to make a temporary table, display it and then delete it.

    Show me the table layouts and I might have some other suggestions too.
     
  7. michelin man

    michelin man IDB Construction

    Joined:
    Jul 22, 2001
    Messages:
    11,660
    Likes Received:
    0
    Location:
    Austin
    There does not seem like an easy way around this. I have a basic understanding of SQL and these tables are straightforward so it should be fairly easy to maintain.

    I think I will put in the P.O. for the new server and go from there....

    thank you for your help and the ideas
     
  8. 5Gen_Prelude

    5Gen_Prelude There might not be an "I" in the word "Team", but

    Joined:
    Mar 14, 2000
    Messages:
    14,519
    Likes Received:
    1
    Location:
    Vancouver, BC, CANADA
    Oh well, if you can afford it then of course move to SQLServer! Don't look back!
     

Share This Page