DataBase Sync.

Hi,

I have SQL2005 at the office, and i have registerd with ASPDiscount and i have the same database with ASPDiscount.

Now Can I Sync the 2 database with each other?

Please Help.

Regards
Omar

 

Hi,
You can use your local copy to pump tables and records either way, local and remote.
(Using the Import/Export wizards...)
Here's a basic Webcast showing how to do it with SQL Server 2008:
http://www.dasptv.com/avc-view.aspx?videoid=17
All the best,
Mark

 

Hi,

thank you for the replay,

but is there a way that do it automaticaly, like replication ...

 

Hi,
There are other ways to do this, one of the most common in previous SQL Server editions was with DTS.
It's still possible with a DASP SQL Server but it will require DBA skills on your part to script everything locally.
In my opinion the Export/Import Wizard offers your best options.
All the best,
Mark

 

Thanks ... I will Try that.