Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [development]

The tag has no usage guidance.

0
votes
1answer
43 views

How to Set Up a Shadow Production Database for PostgreSQL?

I'm working on a Django project and I'd like to avoid the common pitfall of using SQLite for development and PostgreSQL for production referenced in Two Scoops of Django. I'd like to take this a ...
5
votes
1answer
217 views

How can we manage cross-database dependencies across environments?

I've put off asking this question for some time since it's tricky to encapsulate our situation and challenges without a wall of text, but the situation is getting worse so I'll do my best. I'm looking ...
5
votes
2answers
1k views

what would be the right permission to allow everything else but overwriting or creating a database?

I have a test environment where the AD group mycompany\developers is currently sysadmin. Recently I have had some issues, specially regarding to people restoring databases. My concerns are: ...
2
votes
1answer
355 views

Tool to test RDBMS SQL dialect for ANSI SQL standard compliance

We are developing an interface to our internal data storage and manipulation tool that would allow people to use SQL dialect. We decided that it would be perfect to make our SQL dialect as close to ...
4
votes
3answers
85 views

Who should own application objects?

So I am just started doing stuff resembling full-blown Oracle DBA work recently, so am still learning much of the basics of the administration part of my job. I have been tasked with bringing multiple ...
0
votes
1answer
648 views

SQL Server - Data Warehouse large log file, how to safely shrink?

My DW database is about 20GB size in data file and nearly 120GB in log file. Data staleness is until midnight (so "yesterday's news") and multiple databases are being replicated daily from ...
2
votes
1answer
207 views

Split SSIS project in to multiple files to avoid merge hell

Since SSIS does not like being merged nicely I was wondering how to have a big SSIS package split up. With the idea of having multiple devs working on this simultaneously, and a minimal chance of ...
1
vote
2answers
771 views

How to set up development servers SQL Server

My .NET development team has been massively restructured recently, and as a result of the restructure, we now have the ability to do things like set up source control and database backups, and ...
2
votes
1answer
255 views

Logical condition when declaring handler procedure

I have a procedure in MySQL that executes a handler for SQLEXCEPTION to read the errno code and insert it to a table. DECLARE EXIT HANDLER FOR SQLEXCEPTION BEGIN GET DIAGNOSTICS CONDITION 1 @...
4
votes
1answer
536 views

How to develop a database (workflow)?

tl;dr: I know a few SQL semantics and I know how databases work (basically) but I never created one that had a considerable size. I lack of knowledge concerning workflow, SQL-code management and very ...
2
votes
1answer
1k views

Laravel MySQL relation difficulties

I have a "users" table: And an organisations table ("orgs"): And this is the pivot table: I have some relations: On the "users" table, I have a function called "orgs()" which is a belongsToMany ...
3
votes
1answer
543 views

Migrate small sets of data from production to staging/sandbox

I have a development environment that consists of a production, staging and development servers that host SharePoint 2010 or 2013 as well as SQL Server 2008 R2. These each need to have relevant data, ...
0
votes
2answers
68 views

sync 2 tables in a single database in mysql with no duplicacy [closed]

I have 2 tables in a single database of MySQL. The structures are like this: mysql> desc main_tbl; +-----------------+--------------+------+-----+-------------------+----------------+ | Field ...
0
votes
1answer
61 views

Who should own the staging database right

At my company we are re-assessing which developers will take on the deployment for xyz ticket. At the moment when a developer is done with his ticket, a deployment ticket is created and another ...
2
votes
2answers
2k views

Using MySQL/PHP PDO, is there a 'simulate' or dry run option?

Does MySQL (or, ideally, PHP PDO) have some way of simulating transactions without actually committing them? (Can I get MySQL or PDO to act as if data is inserted/deleted/updated, without actually ...
0
votes
1answer
97 views

Creating a database base

I'll start of with what I have already: I've learned at uni how to create databases and now I'm trying to create my own for personal use and possible use for my customer base. The people I work for ...
1
vote
2answers
1k views

Creating a database with only MySQL command line?

The linux server on which I'm attempting to create a MySQL database has many difficult to work with permissions. My supervisor has tried to install MySQL Workbench on the server, but has been unable ...
1
vote
0answers
41 views

Help understanding SQL Server Developer License when users test via webserver [duplicate]

I'm trying to understand how many licenses I may need if we decide to pursue a SQL Server Developer license for our Testing environment. We would have 5 actual developer and DBA's physically ...
0
votes
1answer
108 views

How to organize a development environment using Oracle XE 11g?

I started developing small applications using Oracle XE 10g/11g using APEX. They are intented to be run on desktop computers that acts as a server in small offices. Oracle XE is well suited for those ...
1
vote
0answers
734 views

What's is the best way to get incremental changes from production to incrementally changed development database?

I came to a new dev team where all development is on the same (instance) of an SQL Server (2005) database once in 1-2 days restored from a current full backup of production database replacing a dev ...
0
votes
1answer
137 views

Remote SSIS development

I'm currently developing SSIS packages which include transferring data between two servers. The servers are in the same local LAN, but I'm remote to them. Is there any way that I can develop the ...
0
votes
1answer
3k views

AdventureWorks2012: “The FILE SIZE property is incorrect” error while trying to attach sample database “Adventure Works for SQL Server 2012”

I am trying to attach the sample databases, for example, AdventureWorks2012_Data.mdf from codeplex "Adventure Works for SQL Server 2012" into a MS SQL Server 2012 (default) instances on a a virtual ...
2
votes
1answer
59 views

Preferred Methods of copying a new database from Development to Production

I am wondering what are preferred methods to copy a new (Development) database into a new environment. The database will be empty, so essentially I am copying only the schema of this database and not ...
2
votes
2answers
324 views

Can I default to T-SQL only view in VS 2012?

When creating new tables in a database project in VS 2012, opened sql files default to a split view. One is the T-SQL text editor view, and the other is the Design view. I've never used the design ...
1
vote
1answer
1k views

How to sync a table between oracle and sybase

I have a table in Sybase (destination) that I would like to keep it synced with a table in Oracle (source) I cannot truncate and populate the table in Sybase because it is used by an application, I ...
1
vote
2answers
4k views

How to update SQL Server 2012 from Evalutation to Developer edition?

During the installation of a new development infrastructure, I had to install many SQL Server instances on different machines. Some were of course dedicated for production and some other for ...
1
vote
2answers
168 views

Is this an appropriate development environment MySQL backup strategy?

I'm a web developer and I use primarily my own laptop at work. We use an SVN repository for our project codebases, and deploy our changes to an internal development server for testing. Our system ...
8
votes
2answers
1k views

Do agile software development approaches apply to SQL?

I would like to learn if agile software development methods/principles/patterns are valid to SQL programming as well. If yes, where would be a good place to start learning about that? Are there any ...
11
votes
1answer
5k views

How to setup local database development process for small web team?

Background I am working on creating a new development process for a small web team of about 4 programmers and 4 designers, with the obvious potential to grow the team in the future. Our product is a ...
2
votes
3answers
8k views

Easy or Schedulable way to move data from Production to Test

What I am looking to do, is schedule a copy of data from my production database to my dev/test database. The dev/test database will be newer than the production database in terms of schema, but the ...
20
votes
7answers
17k views

Does a DBA need to know how to program in a system language besides SQL?

To what extent does a Database Administrator need to know system or application level programming languages (for example .NET or PHP) besides "just SQL"? For the purposes of this question, no ...