hydev
asked on
How to replicate SQL server 2000 database without using replication!
Hi,
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.
Mike
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.
Mike
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Really? Wow, that never *cough* every day *cough* happens to me... :-)
ASKER
Mike