up vote 0 down vote favorite
share [g+] share [fb]

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

link|improve this question
20% accept rate
It's not that it makes it difficult, its that Express doesn't have the SQL Agent. – DanBig May 25 '11 at 13:16
feedback

2 Answers

up vote 0 down vote

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.

link|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
feedback
up vote 0 down vote

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

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

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