Home Forums SQL Server 2008 SQL Server Newbies Multi database to SQL Server at record level RE: Multi database to SQL Server at record level

  • September 19, 2012 at 1:08 am

    #1539404

    Douglasjbell (9/19/2012)

    Hi

    Thanks for the replys.

    As the application has already been designed from the ground up for use with the Access database I would rather stick with this as the backend database.

    I have had a look at SSIS for SQL 2008 unfortuantly to use the Business Intelligence Development Studio I need to have SQL 2008 Professional which you get the developer edition with and unfortuantly I only have SQL 2008 Standard. I think I am going to have to look into writing my own VB program that sits as a service on the clients PC and updates the SQL Server Manually.

    Regards

    Dj

    BIDS is included in Standard Enterprise and Developer editions.

    Just a case of installing it from the SQL installation which installs the "shell" version of Visual Studio, or if you already have VS2008 installed, adds in the references to business intelligence projects.