User Name Password Register
DaniWeb IT Discussion Community
All
What is DaniWeb IT Discussion Community?
You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 397,624 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,465 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MySQL advertiser:
Views: 3581 | Replies: 1
Reply
Join Date: Oct 2005
Posts: 13
Reputation: iketunde is an unknown quantity at this point 
Rep Power: 3
Solved Threads: 0
iketunde iketunde is offline Offline
Newbie Poster

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

  #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?
AddThis Social Bookmark Button
Reply With Quote  
Join Date: Mar 2004
Posts: 717
Reputation: Phaelax is on a distinguished road 
Rep Power: 6
Solved Threads: 29
Phaelax Phaelax is offline Offline
Master Poster

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

  #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  
Reply

Only community members can participate in forum threads. You must register or log in to contribute.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 

DaniWeb MySQL Marketplace
Thread Tools Display Modes

Similar Threads
Other Threads in the MySQL Forum

All times are GMT -4. The time now is 8:53 pm.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC