sql server - first timer...

Discussion in 'Databases' started by LiorFil, Dec 21, 2008.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. LiorFil

    LiorFil

    I currently have 4 sites onthe servers that run access databases.
    I am working on another site that would require sql server.
    I have never worked with sql server before.
    Do you have any FAQ's that would help me get that site up and running? (I tried searching your site but couldn't find any).
    any additional links and help would be greatly appreciated.
    </o:p>
    Thanks,
    Lior.
     
    LiorFil, Dec 21, 2008
    #1
  2. JorgeR

    JorgeR DiscountASP.NET Staff

    When it comes to migrating you access database to SQL, you will need to use the Microsoft's migration assistant tool - http://www.microsoft.com/sqlserver/2005/en/us/migration-access.aspx#assist. As for FAQs - please reference - http://kb.discountasp.net/default.aspx?cNode=0T3E1C&pNodes=1P4K0H:6E0U3I for sql 2008 database and http://kb.discountasp.net/default.aspx?cNode=6E6D1E&pNodes=1P4K0H:6E0U3I for sql 2005. They both are pretty similar in the task that you need to get you started.

    In general, here are the steps:
    1) add the sql addon 2008 or sql 2005
    2) use Microsoft's migration assistant tool as mentioned above to export your local Access db (this is done on your pc) to the dasp sql server
    3) once complete change the connection string in your application


    junior

    DiscountASP.NET

    www.DiscountASP.NET
     
    JorgeR, Dec 23, 2008
    #2
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page