We have 2 servers with SQL Server 2008 Express for IVR systems and one for our website. The website's database server is more accessible on our network. I would like to copy some tables from the other two servers to the website's database server for reporting purposes and to make it easier to lookup transactions. As you probably know, the paid version of SQL Server makes what I'm trying to do extremely easy, and the free version makes it difficult. So what I need is a tool or script that is free to either generate a backup or script that I can use to automatically copy the table to our other database every day. I looked at sqlpubwiz, but couldn't find out where to get it or how to install it (it seems to have only came with an old version of SQL Server 2005 Express I had).

  • It's not that it makes it difficult, its that Express doesn't have the SQL Agent.
    – DanBig
    May 25 '11 at 13:16

You might want to check out these free tools which uses windows scheduler to do backup in Express edition of sql server. ExpressMaint and SQLBackupAndFTP.

  • I've used those tools, but I really just want this single table synced, no the entire database.
    – Chris
    Oct 4 '10 at 16:13
  • Have you tried writing a script that will insert into your reporting tables and scheduling it using windows job scheduler?
    – DaniSQL
    Oct 6 '10 at 18:23

Using sqlcmd or osql to script out the actions, then using Task Scheduler to run the script, may work for you.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.