Post reply

Import from SQL server 2005 express

  • May 16, 2011 at 12:39 pm

    #239745

    Hi,

    I need to import data from SQL express to SQL 2008 database tables. This needs to be set up as a job every 15mins.

    Any help appreciated.

    Thanks,

    PSB

  • May 16, 2011 at 1:15 pm

    #1325412

    You could use SSIS and schedule it from SQL Agent. You could use a PowerShell script and run that from SQL Agent. You could probably use a linked server and run a TSQL statement from SQL Agent, but I'm not crazy about that approach in the event that the Express database is offline. The other two options offer much better error handling.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • May 16, 2011 at 1:21 pm

    #1325416

    I tried to use SSIS . When I tried defining the source connection manager for this server, I couldnot get the drop down list of the databases available in that server.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply