copying mssql database on my local machine to a mysql database online

Reply

Join Date: Oct 2005
Posts: 13
Reputation: iketunde is an unknown quantity at this point 
Solved Threads: 0
iketunde iketunde is offline Offline
Newbie Poster

copying mssql database on my local machine to a mysql database online

 
0
  #1
Nov 10th, 2005
Hello,

I have a software package for monitoring warehouse transactions. I have a need to share information across many users in several different locations.I don't want to network the pc's i can't afford that. i however notice that putting the information online saves a lot of cost for me. I have also noticed the software uses a MSSQl database with 8 databases and several tables.

my options?

i have considered the following.

1. I have considered sharing the information by putting it up on the internet but i need anyone who can recommended the best possible means. How can i export the information to the internet is it possible to bulk copy the whole database and put it online on a mysql database...(noting that i would have to regularly update the database as the program is updated like creating triggers that transfer data on update)

2. isn't it possible to access the program directly by connecting to the pc with its IP address.and then forget about the first suggestion entirely.



what other options do you suggest?
Reply With Quote Quick reply to this message  
Join Date: Mar 2004
Posts: 763
Reputation: Phaelax is on a distinguished road 
Solved Threads: 38
Phaelax Phaelax is offline Offline
Master Poster

Re: copying mssql database on my local machine to a mysql database online

 
0
  #2
Nov 29th, 2005
You should be able to export your current database on your local machine as a CVS file, then import that into the other database on the server. I'm sure there's free software out there to handle this.
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC