Uploading a Database to another Machine

  • Thread starter Thread starter WWGD
  • Start date Start date
  • Tags Tags
    Database Machine
Click For Summary

Discussion Overview

The discussion revolves around methods for sharing a database between two users, specifically focusing on options for transferring a database from one machine to another and potential tools for visualizing the database structure. The scope includes practical applications and theoretical considerations related to database management systems.

Discussion Character

  • Exploratory
  • Technical explanation
  • Debate/contested

Main Points Raised

  • One participant suggests scripting the database and sending the script for execution on the friend's machine as a primary method of sharing.
  • Another participant proposes using their own website for hosting the database, mentioning the need for server software and a database management system.
  • A brief mention of cloud sharing as an alternative method is made by a participant.
  • A participant inquires about creating a graphical user interface (GUI) representation of the database from a script or standard tables in SQL Server.
  • One participant clarifies that the friend would need a SQL Client to connect to the database directly using a public IP address.
  • Another participant mentions phpMyAdmin as a tool for GUI representation of the database.
  • One participant discusses the option of using a hosting service for a CRUD website to facilitate data updates, noting potential costs associated with hosting.

Areas of Agreement / Disagreement

Participants present multiple competing views on the best method for sharing the database, and the discussion remains unresolved regarding the most effective approach. There is no consensus on a single method or tool.

Contextual Notes

Some limitations include the dependence on specific software and configurations, as well as the potential need for additional programming skills to implement certain solutions.

WWGD
Science Advisor
Homework Helper
Messages
7,806
Reaction score
13,120
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   Reactions: WWGD
Cloud sharing .
 
  • Like
Likes   Reactions: 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   Reactions: 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   Reactions: 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   Reactions: 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 3 ·
Replies
3
Views
2K
  • · Replies 8 ·
Replies
8
Views
3K
  • · Replies 16 ·
Replies
16
Views
3K
  • · Replies 0 ·
Replies
0
Views
2K
  • · Replies 1 ·
Replies
1
Views
2K