Can i use Drupal 7 with a existing MS SQL Database on local server?

Wow....this is a good question.

I'm interested too.

Could you output the db as a csv file?

If so you could then use the Feeds module to import the csv into nodes.

new to Drupal and I want to know how to continue using the MySql databases and tables. in one db alone I have 40 tables that are critical reference tables as well as the various relational tables for client information and cross referencing. How do I make this work? I'm not finding the integration on the Drupal site that is helpful.

Notice i'm new to drupal but i've followed the entity tutorials and you are able to load and save entities from other databases. What you need to do is import the schema using the schema api, then define your entities and build a controller that is able to do the load and save part. You are then able to connect views and field api with it.

I have to say though i think its way to complicated solution to do something basic like this.... but maybe its because i'm new to drupal.

Paul

it will be some work. The "drupal way" is not always the easiest if you are not familiar with it.

http://drupal.org/writing-secure-code Has some good tips on how to make proper queries.
http://api.drupal.org/api/drupal/includes%21database%21database.inc/group/database/7 will help you understand a bit of the code.

Don't edit core but don't let it stop you from viewing core. Some of if not the best samples on how to code xyz in drupal come from core. Open up modules/node & books and see how drupal does it. Heck copy it over & find/replace the name with something new in a sandbox & replace it.

http://drupal.org/project/examples more examples!

If you want to add and manage products you'll probably want fieds. Mapping data fields is different than nodes.

http://www.ubercart.org/ & http://drupal.org/project/commerce are also good places to start people with the same problem have paved that road a bit fore you and you can find examples of how to do that in those systems.

best of luck.

Also very interested. This is what we face out there dealing with clients. They have existing database that we cannot even touch.

I think the best way is to create an own module. In this module connect with the custom database and set your query. Get the data from this query and set the fields of your content type with this data. Update the content types with every cron run.

These days there is a module for it ... Forena ...

The easiest way to do that is by using Google Cloud SQL.
It supports connections using the MySQLdb module and in addition It can be used to run in both production
and on dev_appserver by using a local MySQL server.

תביעה ייצוגית

Hi,

How did you solve the problem? I'm trying to do the same. I have a local ms sql server, and want to automatically sync with mysql, there for having stocks in sync etc etc

Thanks