Search Results

Search found 32538 results on 1302 pages for 'restore database'.

Page 537/1302 | < Previous Page | 533 534 535 536 537 538 539 540 541 542 543 544  | Next Page >

• 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

• 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

• WCF: 'Update Service Reference' hoses my files.

  - by mcoolbeth

  Every time that I make a change to the contract of my WCF service, I need to have Visual Studio update the service references in all of my client projects. This process regenerates my client's app.config file and, since I have hand-tuned the "bindings" section of the file, I need to back-up my file and then restore it each time I have VS do the update. Is there a way to avoid this necessity (eg: have VS update the service reference without rewriting anything in app.config)? 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

• 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

• 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

• Distributed sequence number generation?

  - by Jon

  I've generally implemented sequence number generation using database sequences in the past. e.g. Using Postgres SERIAL type http://neilconway.org/docs/sequences/ I'm curious though as how to generate sequence numbers for large distributed systems where there is no database. Does anybody have any experience or suggestions of a best practice for achieving sequence number generation in a thread safe manner for multiple clients?

  Read the article

• Which information (files) of an eclipse-workspace should be tracked by source control

  - by Phuong Nguyen de ManCity fan

  I want to track the workspace of eclipse by source control so that important settings can be backed up. However, there are a lot of kind of *.index inside the .metadata folder of workspace. Some information are important, for example Mylyn repository, but some information is merely cached files and thus, doesn't make sense to me for being tracked. In short, what files inside eclipse workspace that should be tracked so that I can restore the working workspace after problems (like meta data file deleted, etc.)

  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

• how to highlight search results in WPF treeview?

  - by Ravi

  I am developing an app ( A database file system ). I am using WPF treeview in its GUI.The treeview items are directly extracted from my apps database. I want to search and highlight the treeview items as I type.(e.g. keyword results shown in browsers) How do I achieve that?

  Read the article

• Connecting to Teradata via PHP

  - by AFHood

  We need to access a Teradata database via php application We don't have odbc (unixodbc etc) on the server. How might one go about connecting to a teradata database quickly. Keep in mind - this app needs to be as portable as possible.

  Read the article

• How can I monitor the SQL commands send over my ADO connection?

  - by RRUZ

  i need intercept all the SQL commands that pass between an ADO connection component and a database server. something like the TSQLmonitor of dbExpress, but for ADO . Anybody know any third-party component that implements this functionality? UPDATE I want to do is to monitor the SQL statements programmatically (by code) from my application without using an external tool. for any database engine.

  Read the article

• mysqldumpslow @ Freebsd

  - by Tomasz

  I have installed mysql-client-5.4.2 Multithreaded SQL database (client) mysql-server-5.4.2 Multithreaded SQL database (server) on my FreeBSD 8.0 box Why isnt there mysqldumpslow command available? What port should i install to make it available

  Read the article

• Connect to Mongodb in python

  - by SpawnCxy

  I'm a little confused by the document when I tried to connect to the Mongodb.And I find it's different from mysql.I want to create a new database named "mydb" and insert some posts into it.The follows is what I'm trying. from pymongo.connection import Connection import datetime host = 'localhost' port = 27017 user = 'ucenter' passwd = '123' connection = Connection(host,port) db = connection['mydb'] post = {'author':'mike', 'text':'my first blog post!', 'tags':['mongodb','python','pymongo'], 'date':datetime.datetime.utcnow()} posts = db.posts posts.insert(post) #print str(db.collection_names()) And I got an error as pymongo.errors.OperationFailure: database error: unauthorized.How can I do the authorizing part?Thanks.

  Read the article

• Accessing the music files in iPhone

  - by Mohammed Sadiq

  I need to build a system which backup and restore system in which all the phone datas including audio, video, pictures. From iPhone 4.0 , there is support for accessing the videos and photos from the library . Is there any way to access the music files. I need to convert those music files into binary format . Is there any way to accomplish this... awaiting for the response Best Regards, Mohammed Sadiq.

  Read the article

• spring classloader isolation problem on jboss

  - by mkosm

  Hi, i have two ears deployed on jboss with proper classloaders isolation settings. When seam bean call spring beans which make some queries on database everything works fine, but when spring quartz job bean is invoked and execute tries to execute database queries then there is a problem because spring tries too use hibernate jar from other ear and exception is thrown! It is clearily spring classloader isolation problem. Did anyone meet such a problem? How to ensure isolation?

  Read the article

• how does a sql query work?

  - by Anand

  Hi, How does a sql query work ? how does it get compiled ? Is the from clause complied first to see if the table exists ? How does it actually retrieve data from the database ? How and in what format are the tables stored in a database ? I am using phpmyadmin is there anyway I can peek into the files where data is stored ??

  Read the article

• google maps api v2 - tens of thousands of markers

  - by Adam

  Hello, my problem is with XXk (aka XX000) markers, atm I have 7k markers and will be more, and more, problem is in marker database, because atm this is 4MB (link to my DB http://tinyurl.com/ybau9ce) and problem is, how load that fast? for example DOWNLOAD only this what are show now, DOWNLOAD because load I have with ClusterMarker and problem is not with java but with download that database I think...

  Read the article

• Can five different GAE sites all share a common datastore?

  - by Pete Alvin

  In addition to the datastore for your specific site, can you also share one datastore between all your websites? (Like connecting to a different MySQL database from your main MySQL database?)

  Read the article

< Previous Page | 533 534 535 536 537 538 539 540 541 542 543 544  | Next Page >