Uploading a Database to another Machine

  • Thread starter Thread starter WWGD
  • Start date Start date
  • Tags Tags
    Database Machine
Click For Summary
To share a database with a friend who doesn't have it on their machine, scripting the database and sending the script for them to run is one option. Alternatively, using a web hosting service that includes a database management system (DBMS) like MySQL can facilitate sharing. For a graphical representation of the database, tools like phpMyAdmin can be utilized, allowing for a user-friendly interface to manage and view database structures. If the database design remains static and only the data changes, hosting a CRUD (Create, Read, Update, Delete) website can be an effective solution, with average hosting costs around $20 per month. It is important to ensure that the friend has a SQL client to connect to the database directly if needed.
WWGD
Science Advisor
Homework Helper
Messages
7,771
Reaction score
12,990
Hi All,
I want to work with my friend using a database I have in my machine but he does not have in his.
Only method I can think of to send it to him is scripting it, sending him the script and having him run it
in his machine ( we both have SQL Server Dev ). Is there some other way? Just curious.

Thanks.
 
Computer science news on Phys.org
Depending on the details, I might use my own website. In almost all cases, the website fees include a DBMS (such as mySQL). But you would need to have server software (perhaps php programming) to make it useful.
BTW: I use siteground - cause its cheap.
 
  • Like
Likes WWGD
Cloud sharing .
 
  • Like
Likes WWGD
Thanks all,
Somewhat-related: is there a way of GUI-fying a database given either as script , or as standard tables in SQL Server? EDIT: I mean, I want to have a GUI rep of the database as a list of column names, with the ows, etc as output given either the database script or as tables, as in Management Studio in SS Developer..
 
You want your friend to have SQL Client. Not Server. Then he can connect directly to your database using your public ip.
 
  • Like
Likes WWGD
WWGD said:
Thanks all,
Somewhat-related: is there a way of GUI-fying a database given either as script , or as standard tables in SQL Server? EDIT: I mean, I want to have a GUI rep of the database as a list of column names, with the ows, etc as output given either the database script or as tables, as in Management Studio in SS Developer..
Sorry, I didn't see this.

It's called phpmyadmin.
 
  • Like
Likes WWGD
You could put it on a hosting service if the design never changes and you are just changing data. I run the automated Visual Studio tools to create a CRUD website which you both could use to update the data. hosting would prolly cost $20 a month on average.
 
  • Like
Likes WWGD
harborsparrow said:
You could put it on a hosting service if the design never changes and you are just changing data. I run the automated Visual Studio tools to create a CRUD website which you both could use to update the data. hosting would prolly cost $20 a month on average.
Thanks, it was just more of a theoretical thing, not intending to do it for now. Sorry for bother :).
 

Similar threads

  • · Replies 8 ·
Replies
8
Views
2K
Replies
7
Views
3K
Replies
6
Views
2K
Replies
5
Views
2K
  • · Replies 3 ·
Replies
3
Views
2K
  • · Replies 8 ·
Replies
8
Views
2K
  • · Replies 3 ·
Replies
3
Views
2K
  • · Replies 16 ·
Replies
16
Views
3K
  • · Replies 0 ·
Replies
0
Views
2K
  • · Replies 1 ·
Replies
1
Views
2K