473,748 Members | 2,551 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

how to export data from sql server and import to mysql automatically

16 New Member
hi,

i have export one table from sql server.and those data are import to mysql automatically.n o manual.it runs every time gap.

please any one know how to do it..help i want to finish this work by this week

Thanks in advance
Jul 23 '10 #1
2 2885
dlite922
1,584 Recognized Expert Top Contributor
You have a couple of options.

Use mysqldump (and sql server equivalent of mysqldump) and put them in a crontab / scheduled-task.

OR

Do it with code. With php, connect to the first database, get the data, connect to mysql, insert the data.

You can automate it by putting this php file in a crontab too.

Take your pick, but I suggest you go with the former if your table is pushing hundreds thousands of rows or more.

Cheers,


Dan
Jul 23 '10 #2
neelsbr
16 New Member
@neelsbr
thank u..i will try in my job..i will contact u further any reference..than k u for ur reply
Jul 24 '10 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

10
7695
by: ls | last post by:
Hi All, I looking for help with ZODB data export to text file. I have file Data.fs (file becomes from Plone CMS) and I have to display content structure, data like intro, body of article, etc and save it in to simple file. However I can't use Plone XML export because is broken, Zope Corp. set low priority for this bug, so I have to find other way how to digg in to data. Could you point me in to some Python code examples, code...
3
1773
by: James Alexander Starritt | last post by:
I have created a rather large (60 table database) website dealio in PHP that works with MS SQL Server, Oracle and presumably any other data base I add to the wrapper functions that I created. All the development was done in Oracle, but now its time to create that large datastructure again in MySQL -- now I've built this all in notepad for Oracle (twice) and built it in SQL Server using the SQL Server import tools (pretty nice) -- is there...
1
1827
by: Andy | last post by:
I have a mysql db and running on RH linux , how can I export the data from the mysql db on the shell ? thx.
7
3712
by: Eric | last post by:
Hi, Any suggestion to Rapid Application Dev with postgreSQL ? I have a small app to make. I would prefer open-source solution if possible. I also would like to developp on my linux box but the result will be used on a windows 2000 and XP machine. But If I have no choice, I will developp on winXP.
7
7810
by: Vanessa | last post by:
hi Everyone, I have two questions on exporting data to Excel using ASP (w/o converting formatted excel file into web page and then plug in the dynamic data): 1. Can we export data into different sheets at Excel? 2. Can we do graph at export? Thanks!!
0
1524
by: =?Utf-8?B?Vml0b3I=?= | last post by:
Hi, I trying to develope a mobile application that need to import and export data from sql server mobile (compact) to an oracle database. I think the best way is to use web services. I have a web service with a method that access a oracle that base and returns the number of records from a table. Every thing is ok but I ned the web service to return a xml containing the table data. What is the best way and how ?
4
4909
by: Max2006 | last post by:
Hi, We are developing a SQL server based asp.net application. As part of requirement we should allow users import/export some relational data through web user interface. We are investigation which file format would be the most efficient format to import export relational data. So far we came up with two options: XML and Access MDB files and we prefer MDB files.
4
7786
by: sejal17 | last post by:
Dear Sir, Can you tell me how to export data from MySQL database to a xls file using php code?I have to export data from different tables of mysql database to a single xls file.Please help me!!! Regards, Sejal Mandaliya
2
1644
by: creative1 | last post by:
Hi Everyone, I am using vb6 and access for my software application ( Point of Purchase ). I a asked to make it able to import and export data from some tables (Vendor Information, Products Details etc) for using in Quick Books. I have some knowledge of QBook . I think we can import data if its in excel sheet. Can someone guide what I should do. Any help will be highly appreciated. I am trying to google it and going through different...
3
7160
by: =?Utf-8?B?YzY3NjIyOA==?= | last post by:
Hi all, I have a question for you. I have a .csv file which has many lines of data. Each line has many data fields which are delimited by ",". Now I need to extract part of data from this file but save it as an excel file. The data in this excel file will be imported into an Access database. The
0
9562
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9386
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
9333
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9254
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8255
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6799
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
1
3319
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2791
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2217
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.