Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2017
    Posts
    4

    Unanswered: Access to SQL Server

    I have an Access database that I would like to move into an SQL server to learn about SQL server and am going to be using C# to develop with.

    How do I start the process?
    We have MS Server 2008 or 2012 on the company servers, but I am not sure is SQL server is installed/used. So, to start my learning process, I figured I'd get a local server going, but I am not sure how to do that, yet either.

    Then, how do I get my tables and data into this server?

    Thanks for your help.

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,858
    Provided Answers: 17
    You may as well get Developer edition of SQL Server installed on your laptop. It's free now.

    Once you have that, you can import your tables from Access into SQL Server using Management Studio. To do this:
    Create a database
    Right click on the database, go to Tasks->Import Data...
    Select your Access database, select the tables, and off it goes. It won't pick good datatypes for you, so that can be the first thing you start learning about. Once you have the tables in SQL Server, then you can start developing queries, procedures, and whatever else you need.

Posting Permissions

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