I have a MS-SQL database on a server and have decided to play around with source control for the database. I want to create a database project and include that project within my solution. Is there any way to "import" an existing database into a database project in Visual Studio 2008? I have run a few searches but I haven't really found ...
If I add an id column to a table, and set id as the primary key, will the table be in 2NF? ...
Hi, how can i call my own function stored in postgres DB, while i am selecting data throught Doctrine_Query::create() ->select('schema.my_function(id)') ...
I log insert and update info to every table create_date TIMESTAMP create_user_id INT update_date TIMESTAMP update_user_id INT I thought that instead of putting them on every table, creating only one log table and referencing the log table on every table so I can retrieve the log info only when I need. I know it depend on the ap...
Hi, I need to open up my database to a remote QA team.I want to ensure that they have read-only access to all my database objects (table records,procs, functions, views,etc) . But they should not be able to delete or drop database objects. How do i do that in oracle 10.2g ? Is there a built-in role which can be assigned to the user ...
I'm running into a strange problem using the Toplink implementation of JPA. I'm writing a stand-alone application to manage loans. I define a LOAN class that has a OneToMany (bi-directional) relationship with a NOTICE class. I created a GUI to display all the notices for a particular loan. In another part of my program I can send out...
I've been searching and can't find an answer anywhere. I also haven't had time to try it out either. Is it possible, using java in the Google App Engine (GAE), to connect to a remote database. Whether it MySql, SQLServer, etc. Will it be allowed to make calls outside of it's domain? Is it possible to even use the required libraries ...
Ok... I have a database table called employees.. This has columns called ID, Name, datejoined and Cannotbedeleted (check boxes)... Now i want to add a delete column which deletes the rows when clicked. But there are some entries which cannot be deleted if the Cannotbedeleted field is true (checked)... so the delete button should be in...
My employer has a database committee and we've been discussing different platforms. Thus far we've had people present on SqlLite, MySQL, and PostreSql. We currently use the Microsoft stack so we're all quite familiar with Microsoft Sql Server. As a part of this comparison I thought it would be interesting to create a small reference app...
Is there any way to read the Picasa database? What is the format of the Picasa database? Are there any APIs to access the database? ...
I'm aware of the fact that database testing (CRUD) can be considered out of NUnits scope, since it's not quite unit testing, but nevertheless : Is there any standard way in NUnit for database testing? Something in the lines of rolling back transactions made, or any other solution I cannot come up with? ...
I have an application, which need to do some validation on the database end. Each process goes through database validation (search on the table that has around 6 million records), then goes through some Lucene Index searcher (the index is built off this 6 million record table). As these steps are disjoint for each line items being passe...
Hi, I'm trying to find a lib to access a DB from an Ocaml program. After trying ocaml-sqlite, I'm not satisfied since it's somewhat slow. I've seen a mysql module but it doesn't seem to be maintained. thanks. ...
I have two tables - let's call them Customers and Orders. It's a 1:n relationship, where each Order is placed by one Customer, and one Customer can have many orders. The Web app is written in Zend Framework. My goal is to query a customer from the database, and get their 10 most recent orders (for example), and to have all this informat...
Is there a way for me to force a specific join order in Postgres? I've got a query that looks like this. I've eliminated a bunch of stuff that was in the real query, but this simplification demonstrates the issue. What's left shouldn't be too cryptic: Using a role/task security system, I'm trying to determine whether a given user has pr...
Hello, I'm asking for the advice. I'm working at the Silverlight 3 application and now I should select the mean how to save the information and get it. I could save the necessary info in files (from 1 to 300K size) or I could save them in database. If I would use WebClient for accessing to separate file there's very low loading of the se...
Hi, Can anyone point me to some really good online resources for understanding Database Concepts. p.s.: My background is of Java Development. Thanks. ...
I'm working on an app where users enter pricing quotes. They want to be able to have multiple revisions of the quotes and have access to all of them to revise and view. Currently the data is stored in a Quotes table that looks like this: QuoteID (PK, autonumber) data1, data2, data3 and so on. QuoteID foreign keys to other tables for o...
Hello! In contrast to my previous question, i'll try to give my requirements. I am trying to find some framework/methodology/"thing" that would fit the following: Ability to write an automated test, preferably written in Visual Studio, using C#. Test should drive a web browser and interact with SUT just like an user would. Test shoul...
DocID | Date Updated | DocName 8245376 | 8/26/2009 1:07:01 PM | Doc1 8245376 | 8/26/2009 4:07:04 PM | Doc1 8245376 | 8/26/2009 7:07:01 PM | Doc2 8245376 | 8/26/2009 2:07:03 PM | Doc2 646681 | 8/26/2009 1:07:01 PM | Doc3 263272 | 8/26/2009 1:07:01 PM | Doc4 8245376 | 8/26/2009 1:07:01 PM | Doc5 8245376 | 8/26/2009 2:07:10 PM ...