Sql 2008 Database Replication

Hello to all
I need to know which method is the best for my databse replication scenario.

1- my internet connection is slow(about 256/256kb)
2- my local database schema same as the my web database
3- The one way solutions is ok for me because i just need to send my local database changes to the web database.
4-Both of Sql servers are SQL 2008

thanks all

 

Hi,
How much data?
Normally I'd recommend the Wizards and a little clean-up SQL to double-check.

 

Thanks for your reply.
At the current time i have about 20,000 product in my database and it will grow 20 new product every day.
and also my inventory information have to be up to date on any sale or purchase action on my local database.
in this scale an automatic and stable solution is my desire

Sincerely
David

 

I have to say $$ is one of my parameters. please suggest a free solution.

 

...In the past DTS was great for this.
In SQL Server 2008 it's now Integration Services.
You can use this from a local system to keep your local and remote records in sync.
Your connection speed will slow it down but won't kill it.

I'd recommend you use this with temp tables.
Not actual "temp" tables, just leftover tables that you use to filter records in.

Could work like this:
1) SQL Server 2008 I.S. pumps the records.
2) Records are fed into a temp table.
3) I.S. fires off a SQL script that looks at the temp table records and feeds updates into the actual destination table. Primarily looking for duplicate records and records failures.

The script will require some work on your part but it will do the job.
Look at the categories here for help:
http://sqlserverpedia.com/wiki/Replication