swarner22 avatar image
swarner22 asked

Before I start, How to, database questions, read details.

1. I know how to build a database and design one, put one together. But I have only done so on my local host through either mamp or the standard workbench server, how do I connect to the "customers" server to build there database on, so how do I run there server on my laptop to build the database in or whatever work I am doing. 2. How will they access this database I create, do I need to design the software or webpage it is accessed with via the users I create with sql or do they normally have someone els do this, like a web designer or UI specialist, or is there common database software that allows them to do so, perhaps I should build servers for "raziors edge" clients? 3. can I transfer a pre-made database from my localhost on my server to there server and do maintenance on it once it is on there server over time? So how to transfer databases between servers, while keeping data inside them intact. 4. How do you import massive amounts of data into a database if the client has a huge list of data to be transferred? 5. How can I transfer transfer data from a database on one server to a database on another server 6. would it be "safer" to create a duplicate of a database and copy and paste the data from the database you are duplicating from and change/apply maintenance to the things you need, then replace the duplicated with the newly modify duplicate to avoid "oopsies".
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

Tom Staab avatar image
Tom Staab answered
1. That depends on the project. If it's a new database, and they are okay with this from a security perspective, you might be able to develop it locally on your machine and then just back it up and restore it to their system. For development and/or maintenance of an existing system or work involving confidential data, they may require you to be in their office or possibly connect via VPN. 2. Once again, this depends on the project. They may have someone else build the UI, or it might be an existing UI, or they might want a whole solution built including front-end and back-end. 3. BACKUP and RESTORE: [][1] 4. Personally, I love SSIS (SQL Server Integration Services). Well, truth be told, we have a love-hate-love back and forth relationship, lol. All kidding aside, it really is a powerful tool with a short learning curve to get going with the basics. You could also use [bcp][2] or [BULK INSERT][3]. 5. SSIS or bcp can be used to transfer the data between 2 databases. SSIS requires a connection between them. With bcp, you export from one database into a file and then import into the other, so you don't need a direct connection between the 2 systems. 6. If your goal is to not do development in a production environment, then hell yeah. But I'd avoid copy/paste and stick with the tools I mentioned above. [1]: [2]: [3]:
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Awesome Tom, you and frank have been reeeally helpful, and I am walking through that door "morpheus". Just learning a few skills in developing API's with php. That way I can just have something "pre-made" I can have my clients use, encase they don't have one already.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.