how to connect SQL server to salesforce

[Mridu]

hi

i have installed SQL Server 2005  and visual web developer express 2005 .i want to get data from SQL say one table account-accountname and address  into salesforce.How we can connect sqL server to salesforce.Is it possible.Give me  a solution asap

[aalbert]

A free option would be to use the Data Loader. You could manually extract the data from your DB into CSV files, then import those files into salesforce.com objects with the data loader. If you want to automate that, you could use the Command Line Interface of the Data Loader.

Depending on the complexity of your requirements, you could also try out Informatica's cloud-based Data Loader Service.

[forceAMP]

Over a 1000 companies use DBAmp to connect SQL Server to salesforce.com

More details at http://appexchange.salesforce.com/listingDetail?listingId=a0N300000016bWzEAI

[SFDC_Learner]

We can do this using Jitterbit.

[CozyRoc]

Check COZYROC SSIS+ library. It is a third-party extension library for SQL Server Integration Services (SSIS). It does include Salesforce adapters and many other useful additions. When you test and develop from Visual Studio (BIDS), no license key is required. The adapters are very easy to use and completely integrated in SSIS.