Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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).

share|improve this question
    
It's not that it makes it difficult, its that Express doesn't have the SQL Agent. –  DanBig May 25 '11 at 13:16
add comment

2 Answers

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.

share|improve this answer
    
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
add comment

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

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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