DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: converting Access databases to SQL

Hybrid View

  1. #1
    Veronica Guest

    converting Access databases to SQL


    Question:

    I am in the process of converting a series of Access databases. Each databases
    contains a primary key (autonum). In converting them over to SQL, does SQL
    Server 7 support this feature? In not, how can I incorporate a primary key
    or unique key into the databases?

    Thank you for all of your help!

    Veronica Lee
    vlee@ascap.com

  2. #2
    Bruce Taylor Guest

    Re: converting Access databases to SQL


    Hi Veronica,

    you can create a auto-incrementing in SQL Server 7 by defining an integer
    data type and setting the IDENTITY attribute on the column to true. you
    can access this attribute through the Enterprise Console by opening a table
    in design mode.

    Bruce Taylor
    PriceWaterhouseCoopers

    "Veronica" <vlee@ascap.com> wrote:
    >
    >Question:
    >
    >I am in the process of converting a series of Access databases. Each databases
    >contains a primary key (autonum). In converting them over to SQL, does

    SQL
    >Server 7 support this feature? In not, how can I incorporate a primary

    key
    >or unique key into the databases?
    >
    >Thank you for all of your help!
    >
    >Veronica Lee
    >vlee@ascap.com



  3. #3
    Veronica Guest

    Re: converting Access databases to SQL


    Thank you so much!!

    Veronica

    "Bruce Taylor" <bruce.a.taylor@us.pwcglobal.com> wrote:
    >
    >Hi Veronica,
    >
    >you can create a auto-incrementing in SQL Server 7 by defining an integer
    >data type and setting the IDENTITY attribute on the column to true. you
    >can access this attribute through the Enterprise Console by opening a table
    >in design mode.
    >
    >Bruce Taylor
    >PriceWaterhouseCoopers
    >
    >"Veronica" <vlee@ascap.com> wrote:
    >>
    >>Question:
    >>
    >>I am in the process of converting a series of Access databases. Each databases
    >>contains a primary key (autonum). In converting them over to SQL, does

    >SQL
    >>Server 7 support this feature? In not, how can I incorporate a primary

    >key
    >>or unique key into the databases?
    >>
    >>Thank you for all of your help!
    >>
    >>Veronica Lee
    >>vlee@ascap.com

    >



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