SQL - where to start?

[Grit]

Hi

I need to write a program that reads the contains of MSSQL Database and copy the data to a MYSQL database. I have no idea where to start. How do I get access to a mysql and mssql database? Has anybody a good example for me? Is it maybe easier to use C# for this problem? If yes, is there anywhere a good HowTo?

best regards
Grit

[Skizmo]

Well. .. to start somewhere. . make sure you have a Visual Studio .
It doesn't matter what language you use. You can use C# or MFC or ...
Most of the databases can be accessed by ODBC. For accessing the data, you usually use SQL. So. . I guess it depends more on what you want to build instead of how.

[Grit]

I have the VC 2005 and I don't want to use ODBC. I downloaded the mysql API but there were no lib files or dll files but only header files. I have no idea how to use them without a lib or dll. I also need some howto for connecting to MS SQL Server. Is there a lib for that too?

I did write something similar already with PHP but in C++ it's a bit different because I don't know which class or function I need to use for it

Love
Grit

[TheCPUWizard]

You have to use either the native drivers or the odbc drivers. There is no way to do it without them (from any practical sense).

[Grit]

Where do I get the native driver for MSSQL?

Grit

[TheCPUWizard]

With SQLServer or with the .Net Runtime (for managed code only)

[GCDEF]

SQL Server will let you export data directly. Depending on your requirements, you may not need to write any code at all.

ODBC would be much, much easier than using any kind of native API.

[Grit]

Do you know where I could find a simple example how to connect to a MS SQL Server?

Grit

[Grit]

SQL Server will let you export data directly. Depending on your requirements, you may not need to write any code at all.

ODBC would be much, much easier than using any kind of native API.

Well I have a table in the MSSQL database. Once a day special columns of the table shall be copied to a MySQL database on a Linux Server.

The orginal base contains a table with FirstName, LastName, birthdate and some other things. Only the entire Firstnames and Lastnames shall be copied to the Linux MySql database each night. I thought it would be as easy as in PHP to connect to both database and do the copying. If there is a way to do that without writing a program I would be happy but I also would like to learn how to do this with a C++ or C# program

Grit

[GCDEF]

The easiest way I know programatically would be to use Class Wizard to create CRecordset derived classes for the source and destination databases. From there the code you'd need to write would be trivial. Read up on CRecordset.

I'm not a SQL admin type person, but that does seem like something you could do directly with SQL Server too.

[g_gili]

Have a look at Ovidiu Cucu's article.
MySQl Wrapp

[Arjay]

Is this a one-time MSSQL -> MySQL conversion or do you need this operation to run periodically (say once a day)?

[TheCPUWizard]

Aejay,

You are slipping....look back at post #9

Once a day special columns of the table shall be copied to a MySQL database on a Linux Server.

[Arjay]

Aejay,

You are slipping....look back at post #9

Oops, missed that. Anyway, you may want to consider running this as a service or at least provide logging to the event viewer to capture any errors that may occur.

[Grit]

Have a look at Ovidiu Cucu's article.
MySQl Wrapp

I saw this already but I get alot of errors when I use the VS 2005 for compiling :-(

I also don't know if this can connect to a MS SQL database too