Synchronize two sql database

[hdesbiens]

Hi

what i want to do is to build a website for the resellers, and i want to put the product catalog on this website, my problem is that the resellers does not have internet access everywhere they go, so i want to put the same database on their laptop but they will have to synchronize every day after the work.

I want to know if theres a way to do that?

Thanks a lot

 

[NoCoolHandle]

SQL has a very nice build in replication feature that is ideal for what you describe.

You can access "Wizards" to set this up by selecting your server in enterprisemanager, then rightclicking the righthand window (that shows some text) and selecting View->TaskPad.

Scroll down and check out the replation options.

The best option (IMHO) for what you describe (which is to only Move the latest data from your server to the laptops.) is Transactional Replication.

Once you have setup your "Articles" and "Publications" you can either choose to iniate replicaton (syncronzation) from either the laptop or the server..

Process is reasonably simple..

Good Luck

Rob

 

[JayKusch]

Third party tool by Red Gate called SQL Compare and do that rather nicely. It is well worth the price. Try to build a custom app can get wild.

Thanks

J. Kusch

 

[Catadmin]

Rob,

FYI, Transaction Replication requires a consistant network connection. I agree with you that Replication would be a good tool to use, but not the Transaction Replication version. It won't work correctly if the laptops aren't constantly hooked up to the system.

I'd recommend Snapshot Replication, hdesbiens, if you're only looking at synching once a day. Since Snapshot only requires being hooked up to the network during the actual forwarding of the snapshot, it should be the best for your situation if you choose to use Replication instead of the 3rd party tool recommended by Jay.



Catadmin - MCDBA, MCSA
"If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back???

 

[NoCoolHandle]

Read again Catadmin.. Initiated via the Subscriber it will work.