The database-development tag has no wiki summary.
0
votes
1answer
55 views
How should I evaluate the Database Solution for Large Data Application
Background
I have been tasked to write an application that will be a combination of document and inventory management in VB.net which will be used to store document images in TIFF, PDF, XPS, TXT, DOC, ...
1
vote
1answer
70 views
What's the best approach to building a db schema for profile, but to track changes?
I'm working on a site where companies can create a profile then add locations for each profile.
Those first two tables are simple enough.
But any changes to their profiles or locations have to go ...
-1
votes
2answers
205 views
SQL Server: When to use SSIS vs T-SQL for ETL Tasks [closed]
When should I use one versus the other? For instance, let's say I have 20 comma delimited, denormalized text files and I want to transform the data and load it into normalized SQL Server tables.
1
vote
1answer
140 views
How can I maintain a SQL schema upgrade that goes out to our users on a regular basis?
I work on a project that uses a SQL database as a back end, and a desktop app as a front end. We do releases on a regular basis, and as part of a release, our client needs to update their SQL server.
...
1
vote
1answer
86 views
Visual Studio DBProjects and problem with it running post-build SQL (file too big)
What I am doing is creating a DBProject.. importing a DB.. then creating scripts in the PostBuild that are DATA scripts for each table (so that the post build can populate the tables after the schema ...
0
votes
3answers
172 views
How to maintain user relationship when user unfollows another user
I have a table of user relationship which stores who follows whom, the table structure is as follows
-id
-follower
-following
when someone follows any other user, I add a record with follower user ...
3
votes
3answers
180 views
Are database developers considered under DBA jobs?
This isn't career advice, this is more of a question of logistics.
When looking at job market and such there is a lower than what I think would be out there of database admins but I'm curious if ...
3
votes
1answer
190 views
Database Schema Usage
I have a question regarding the appropriate use of SQL Server database schemas and was hoping that some database gurus might be able to offer some guidance around best practice.
Just to give a bit of ...
-1
votes
2answers
734 views
Fitting it together, database, reporting, applications in C#
Introduction
Preamble
I was hesitant to post this, since it's an application whose intricate details are defined elsewhere, and answers may not be helpful to others. Within the past few weeks (I was ...
8
votes
5answers
7k views
What are the advantages of myBatis over Hibernate?
I've done some research on my own and understand the basic concept. But some insights can only be gained through actual experience.
What are the advantages of myBatis that would make it worth ...
5
votes
4answers
437 views
How do you keep track of the meaning of your SQL fields?
The more SQL fields I add to my tables and the more primary/foreign keys I add the more I lose the overview for specific fields for certain scenarios like Get/Add/Delete/Update data.
I use SQL ...
2
votes
1answer
161 views
In-memory DB to perform intersects on set slices
I have a specific programming need where I need to efficiently store large sorted sets in memory, query them for ranges, and intersect them against other sets that are also queried for ranged.
I am ...
2
votes
2answers
962 views
Development environment to manage multiple Oracle databases
I am in an enterprise environment where we have applications that need to run against multiple Oracle databases. Developers may need to manage multiple vintages of these databases to support ...
10
votes
2answers
2k views
Conflict resolution for two-way sync
How do you manage two-way synchronization between a 'main' database server and many 'secondary' servers, in particular conflict resolution, assuming a connection is not always available?
For example, ...
2
votes
5answers
230 views
Organizing my products database
I’m developing a web-based store in MVC (very closely based on the SportsStore example in Pro ASP.Net MVC 3 Framework http://www.powells.com/biblio/61-9781430234043-0).
I’m using a SQL database and ...
