Search Results

Search found 30279 results on 1212 pages for 'database drift'.

Page 487/1212 | < Previous Page | 483 484 485 486 487 488 489 490 491 492 493 494  | Next Page >

• Where is the future of databases?

  - by Danny

  I'm a bit frustrated with my MySQL database at the moment, so I've been thinking about all the things I'd like to see in the database of the future. But I thought it would be fun to hear other people's thoughts too--I'm not a pro by any means.

  Read the article

• How to format this string in c#

  - by Rohit

  I have a setting stored in database which has a value .jpg|.gif|.png . I want to display it on frontend as ".jpg",".gif" and ".png" in a single string. for example Allowed formats are ".jpg",".gif" and ".png" I was able to seperate it using string fileTypes = String.Join(",", supportedFileTypes.Split('|')) How to specify and clause before the last string. It has to be dynamic. For example if we have .jpg|.gif in database, it should be Allowed formats are ".jpg" and ".gif".

  Read the article

• Oracle Enterprise Server SOAP/Servlet/SoapRouter

  - by JACK

  Does anyone know any sample Oracle SOAP XML requests that that queries the database? For example, the url: http://myoracle:7778/oracle/soap/soaprouter/ I'd like to program xml requests and get return xml database. But I have no idea on the Oracle SOAP format. Please provide an example.

  Read the article

• NSIS Vs WiX Vs AnyOther Installation Package

  - by Sandeep Jindal

  Hi, Need to create a Installation Package that would need to a) install a Database, b) create database and tables, c) installed already created installable in Visual Studio, d) create ODBC datasource, e) copy files. f) create shortcuts, etc Can you please suggestion which one to use? To simplify following would be my criteria(Descending Order) Stable Fullfill all my needs. Easy to learn Can you please suggest? Sandeep Jindal

  Read the article

• Recursive Query Help

  - by Josh

  I have two tables in my database schema that represent an entity having a many-to-many relationship with itself. Role --------------------- +RoleID +Name RoleHasChildRole --------------------- +ParentRoleID +ChildRoleID Essentially, I need to to be able to write a query such that: Given a set of roles, return the unique set of all related roles recursively. This is an MSSQL 2008 Database.

  Read the article

• Using Excel to work with SQL data (read/write)

  - by Tyler Brock

  I have a ton of data in a sql database which I would like to be able to import and display in excel (I can already do this) and additionally modify or append to the dataset within excel and write the changes/additions back to the database. What is the best way to go about doing something like this? Please let me know, thanks!

  Read the article

• PostgreSQL cross server query?

  - by AlexRednic

  Is there a way that I might query a database located on "Server 2" and get my data in "Server 1" ? That is return a set of records from a remote server to my local one. PS: Not cross database query on same server because I know how to do that with dblink.

  Read the article

• SQL Server 2005 Users & Roles

  - by koumides

  All, I am trying to script out a database in SQL Server Management Studio 2005. In my database users belong to different roles. Unfortunately I can't find how to script out the relationship between users and roles. Thanks, M

  Read the article

• file handling in vb.net

  - by Indranil Mutsuddy

  Hello there I have developed an application in vb.net2008 and database sqlserver. Now i want to ignore the database(it has 1 table as customer(name,password,hour,minute)) as i dont want my client to install sqlserver separately or other overheads. I am planning to do the whole using file handling in vb.net(manipulating the data in files itself eg change username, password etc). As I am new i dont actually know the proper way and of course need assistance. Kindly help out. Regards Indranil

  Read the article

• Zero Downtime with Hibernate

  - by Stephan Schmidt

  What changes to a database (MySQL in this case) does Hibernate survive (data, schema, ...)? I ask this because of zero downtime with Hibernate. Change database, split app servers into two clusters, redeploy the application on one of the clusters and switch application. Thanks Stephan

  Read the article

• Unique Constraint Nhibernate.

  - by Will

  I have a object with a Nhibernate mapping that has a surrogate ID and a natual ID. Since of cource the natural ID is uniquely constrained a insert query will fail if the object is already in the database with the same natural ID. My solution for this has been to manually check to see if natural IDs are in the database before trying to insert. Is there a way to specify Nhibernate to do a select before insert on natural Id's/Unique Constraints?

  Read the article

• how to bind a winforms to a field ?

  - by MemoryLeak

  I use winforms to develop application, I want to know how can I use data binding to bind two radio button to a database field ? And if bind to a database field is too complicated, then can I save the value manually while leave other field bind to textbox and automatically update the value?

  Read the article

• MS SQL Error: Primary file group is full

  - by aximili

  I have a very large table in my database and I am starting to get this error Could not allocate a new page for database 'mydatabase' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup. How do you fix this error? I don't understand the suggestions there.

  Read the article

• Load the information in Grid View from SQL

  - by Sivakumar

  Hi friends, I need to load the database values into the grid view by checking the attrinute "id". If the id value which I entered s equal to database, then it'll load in d grid view. Help me to do tat

  Read the article

• DB Designer creates compound primary key

  - by Jon Winstanley

  When adding relationships to a database model in DB Designer 4, a composite primary key is being created every time. So every foreign key I add, I get an extra key added to a composite primary key. I think I must have changed a setting as I don't remember it doing this in the past. Does anyone know how to turn off this feature as I prefer to use a single surrogate primary keys in my database tables?

  Read the article

• Unit of Work Pattern in .Net

  - by Jazza

  Does anyone have any concrete examples of a simple Unit of Work pattern in C# or Visual Basic that would handle the following scenario? I'm writing a WinForms application in which a customer can have multiple addresses associated with it. The user can add, edit and delete addresses belonging to the customer before the customer is saved back to the database. Therefore, at the time of saving, all the original addresses need to be deleted from the database and the new addresses added in a single transaction.

  Read the article

• Loading SQL dump before running Django tests

  - by knutin

  I have a fairly complex Django project which makes it hard/impossible to use fixtures for loading data. What I would like to do is to load a database dump from the production database server after all tables has bene created by the testrunner and before the actual tests start running. I've tried various "magic" in MyTestCase.setUp(), but with no luck. Any suggestions would be most welcome. Thanks.

  Read the article

• Default Value or Binding in "Transfer SQL Server Object Task"

  - by Kronass

  Hi, I want to move 500 table from Database to other with their data and constraints all the tables have column who has default value, I used SSIS using "Transfer SQL Server Object Task" and I choose to copy all tables, copy data and primary keys, it copies the table except the default bindings I tried in SQL Server 2008 CopyAllDRIObjects Property but still the same result. How can I copy all tables from database to other with their data and maintaining their constraints.

  Read the article

• DB comparison tools

  - by Dimi Toulakis

  Has someone experience with database comparison tools? Which one you would recommend? We are currently using "SQLCompare" from Redgate, but I am curious to know if there are better tools on the market. The main requirement is that they should be able to compare scripts folder against a live database. Thanks, Dimi

  Read the article

• SQL programming

  - by Prince

  How can I update a table (MyTable) from a aprticular database (DB1) by equating the said MyTable from a different database (DB2) but it has the same tablename with the one I need to update. I tried putting alias to my program but it doesn't work. Need Help

  Read the article

• Set of Tools to optimize the performance in general of SQL Server

  - by Dave

  Hi, I know there are things out there to help to optimize queries, ect... but is there anything else, something like a full package that can scan your database and highlight all the performance issues, naming conventions, tables not properly normalized, etc? I know this is the job of a DBA and if the DBA is good, he shouldn't need a tool like that, but sometimes you start a new job, you get in charge of an existing database and the DB is a mess, so you don't know where to start... Thanks to everyone Dave

  Read the article

• Is it possible to restore Sql Server 2008 backup in sql server 2005

  - by AvidProgrammer

  Is it possible to restore a backup of a SQL Server 2008 database onto an instance of SQL Server 2005? I need to work on an sample application for which database backup is in sql server 2008. But I'll not be able to install 2008. So is it possible to restore that back up in 2005?

  Read the article

• How do I handle Memcached::ServerIsMarkedDead error with Rails?

  - by Kevin

  Hi, In my Rails app, I changed my model's find method to search into the cache before looking into the database, but I sometime get this error: Memcached::ServerIsMarkedDead While waiting for Memcached server to be up again, how should I handle this error and force Rails to search into the database? Thank you, Kevin

  Read the article

• Counting the number of visitors for a web page - JavaScript and Struts

  - by Dj

  Hi i am Dhananjay, I need to keep track of the number of visitors to a web page. I have planned like this: on load of the home page, I will call a javascript callCounter(); From javascript, I need then to call an action and update a record in database. Please help me with this. How do i call the action? I should be in the same home jsp after updating database. Thanks in advance, Dhananjay

  Read the article

• Registration Form check PostgreSQL is username is already taken

  - by MrEnder

  Hey I'm really new to PHP and PostgreSQP or any database in that matter. So I'm at a loss how to do this. I need an if statement that says. If(the username user just typed in is already in database) { my code here } the variable the username that the user just typed in is $userNameSignup how would I do that with PHP for PostgreSQL? also how might I redirect people to a new page once they have completed the form properly? Thanks Shelby

  Read the article

< Previous Page | 483 484 485 486 487 488 489 490 491 492 493 494  | Next Page >