How to replicate SQL server 2000 database without using replication!
Posted on 2004-08-09
My problem is a practical one. I have a hosting package that lets me do anything with SQL server as long as it doesn't involve changing permissions. i.e stuff involving sysadmin. What I want to do is fairly simple and covered perfectly with snapshot replication. I have a SQL database on my local machine and a SQL database on my hosting company and I want to be able to update my hosted database with changes in my local database. The changes won't be that often so a manual synchonization will be fine.
Problem is you need admin or db_owner permissions to create the publications or subscriptions. Now as I can't use them does anyone have any ideas on how I can either update the ten table son my hosted database with the ten on my local machine? I don't want to DROP, CREATE and INSERT every time is there a more elegnat solution?
Any help greatly appreciated.