 Mssql To Mysql Database Connection |
Welcome Guest ( Log In | Click here to Register a free account now! )
Register a free account to unlock additional features at BleepingComputer.com
Welcome to Bleeping Computer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.| Important Announcement: We have a terrific contest still running on the site that I wanted all our members and guests to know about. The chance to win two Seagate FreeAgent external hard drives. More information about this contest can be found here. I suggest everyone submit an entry for them. - BleepingComputer Management |
  |
 Jun 30 2008, 11:06 AM
Post
#1
|
|
 Multi Megaton Malware Munition  Group: HJT Team Posts: 5,118 Joined: 17-January 08 From: Northfield, Ohio Member No.: 184,215  |
If it doesn't, I'm looking for a common file format which can be recognized by both MSSQL and MySQL. Any ideas? Billy3 -------------------- The forum is always a busy place. In the event I fail to reply within twenty-four hours, feel free to send me a PM.
|
 |
 
|
|
Jun 30 2008, 01:34 PM
Post
#2
|
|
 Hail Groovicus! Group: Site Admin Posts: 6,276 Joined: 5-June 04 From: Vermillion, SD Member No.: 689 |
http://dev.mysql.com/tech-resources/articl...-microsoft.html
There is no reason to do it yourself when there are already tools to do it for you. -------------------- |
|
|
|
|
Jun 30 2008, 01:40 PM
Post
#3
|
|
|
Multi Megaton Malware Munition Group: HJT Team Posts: 5,118 Joined: 17-January 08 From: Northfield, Ohio Member No.: 184,215 |
Hello, groovicus.
I would assume you are refering to this? http://www.kofler.cc/mysql/mssql2mysql.txt True, but I don't have the option of doing this manually... it has to execute from a batch script nightly, without intervention. Billy3 -------------------- The forum is always a busy place. In the event I fail to reply within twenty-four hours, feel free to send me a PM.
|
|
|
|
|
Jun 30 2008, 08:43 PM
Post
#4
|
|
|
Hail Groovicus! Group: Site Admin Posts: 6,276 Joined: 5-June 04 From: Vermillion, SD Member No.: 689 |
Then might I respectfully suggest that if you are having to make nightly transfers from one sql database to another, then there is a serious problem in implementation. There are any number of things that can happen when migrating data (which is why it isn't something that should be done every night). Is there a really good reason for operating like this, because this is a horrible idea. What is it that you are trying to accomplish exactly?
-------------------- |
|
|
|
|
Jun 30 2008, 10:11 PM
Post
#5
|
|
|
Multi Megaton Malware Munition Group: HJT Team Posts: 5,118 Joined: 17-January 08 From: Northfield, Ohio Member No.: 184,215 |
Hello, groovicus
We have an internal server running MSSQL and Microsoft CRM, which has a knowledgebase section. The external server is running MySQL and Joomla!. The servers can't connect because there's a firewall between. An SSH tunnel is connected for ~ 30 seconds through the firewall when updates to the dataset on the internal server can be replicated to the external server. Not much I can do about the implementation... I'm only tasked with making a converter, not with setting things up  I agree with you that it's not such a good idea. Billy3 -------------------- The forum is always a busy place. In the event I fail to reply within twenty-four hours, feel free to send me a PM.
|
|
|
|
|
Jun 30 2008, 10:18 PM
Post
#6
|
|
|
Multi Megaton Malware Munition Group: HJT Team Posts: 5,118 Joined: 17-January 08 From: Northfield, Ohio Member No.: 184,215 |
Forgot to add...
I figured out a way to do this: I have to write sort of a custom program to handle it, but I'm just going to use an ODBC Connection to each database. We'll see if it works :D Billy3 -------------------- The forum is always a busy place. In the event I fail to reply within twenty-four hours, feel free to send me a PM.
|
|
|
|
|
Jul 4 2008, 06:33 PM
Post
#7
|
|
|
Multi Megaton Malware Munition Group: HJT Team Posts: 5,118 Joined: 17-January 08 From: Northfield, Ohio Member No.: 184,215 |
Not that I think anyone cares, but that's what I ended up doing ;).
Not final code, but in case anyone's interested: http://billy-oneal.com/joomlaUpdaterProtot...totype/Form1.vb Yes, the Big Wigs at work need to get their skulls screwed on straight ;). What a nasty system design  !Billy3 -------------------- The forum is always a busy place. In the event I fail to reply within twenty-four hours, feel free to send me a PM.
|
|
|
|
|
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:
| Lo-Fi Version | Time is now: 5th December 2008 - 11:49 AM |
© 2003-2008 All Rights Reserved Bleeping Computer LLC.