Search Results

Search found 3710 results on 149 pages for 'databases'.

Page 74/149 | < Previous Page | 70 71 72 73 74 75 76 77 78 79 80 81  | Next Page >

• MSQL upgrade on Ubuntu - any heads ups?

  - by Rob Sedge

  I am needing to upgrade MYSQL on Ubuntu, it is a production server and naturally cautious. My many googles look to be essentially saying that I need to : 1) Backup my current mysql database and tables/data 2) Uninstall current mysql 3) Install new MYSQL 5+ 4) Restore Databases/ tables and data 5) Hope and Pray I got it right ?? Something doesn't seem right, sounds like a lot of down time and risk Am I missing something / or any simple solutions? Upgrading from mSQL 4 to 5 on Ubuntu 10 Many Thanks, Rob

  Read the article

• How do I find out the expiry date of a SQL Server 2008 trial-install instance?

  - by Peter Mounce

  So I installed a trial of SQL Server 2008 enterprise edition while waiting for MSDN licenses to come through - I now want to uninstall the trial and replace it with a developer edition installation. However, I'd like to first know how long I have left on the trial. Is there a way to do this programmatically with SQL? I looked at create_date in sys.databases, but these give dates that are in 2003 (which is, I guess, when master and model were originally created).

  Read the article

• Document-oriented database - What if the document definitions change?

  - by Sebastian Hoitz

  As I understand it, you can enter any non-structured information into a document-oriented database. Let's imagine a document like this: { name: 'John Blank', yearOfBirth: 1960 } Later, in a new version, this structure is refactored to { firstname: 'John', lastname: 'Blank', yearOfBirth: 1960 } How do you do this with Document-Oriented databases? Do you have to prepare merge-scripts, that alter all your entries in the database? Or are there better ways you can handle changes in the structure?

  Read the article

• Am I missing something about LINQ?

  - by Jason Baker

  I seem to be missing something about LINQ. To me, it looks like it's taking some of the elements of SQL that I like the least and moving them into the C# language and using them for other things. I mean, I could see the benefit of using SQL-like statements on things other than databases. But if I wanted to write SQL, well, why not just write SQL and keep it out of C#? What am I missing here?

  Read the article

• SQL Monitoring Overview

  - by andy

  Hi I currently loook after 20 odd databases in SQL server 2005 and need a tool for monitoring the performance and keep me informed if a database is running slow. Is there anything I can run within Managment studio of any other good third party tool (Pref free) that can do the job. Thanks

  Read the article

• how to use a MySql database within Eclipse

  - by aadersh patel

  I am very new to programming, so please bear with me, and apologies in advance if at first I dont make sense...! I am doing an undergrad programming project, and need to make some databases within a Java program. I am using eclipse (galilo) to write my program. I have downloaded a connector/J, but havent the foggiest how i should use it! Anyone out there able to give me a step by step approach?! Many thanks!

  Read the article

• NHibernate Use existing ConnectionStrings in app.config

  - by LnDCobra

  I want to use the connection string App.Config file. Also is it possible to use NHibernate connect to 2 databases (different connection strings) if so how?

  Read the article

• Need ad-hoc reporting component

  - by Nelson

  We need some simple ad-hoc reporting solution for our ASP.NET web-site. Just an ability to build a query with user friendly interface, then show the result of this query in some table and maybe export it to Excel or print. The solution must be quite easy for end users (our site visitors) who know nothing about databases, SQL and other tech stuff.

  Read the article

• Annotate gem and rails 3.1

  - by vincent jacquel

  Does anyone have any idea why annotate does not work anymore in rails 3.1 ? When trying to run it with : $ rvmsudo bundle exec annotate --position before and given I've got the following in my gemfile: gem "annotate", '2.4.0' I get the following error: /usr/local/rvm/gems/ruby-1.9.2-p180@rails31/gems/activerecord-3.1.0/lib/active_record /railties/databases.rake:3:in `<top (required)>': undefined method `namespace' for main:Object (NoMethodError) I'm using RVM with a gemset dedicated to rails 3.1 with Ruby 1.9.2

  Read the article

• How to determine the country of a mobile phone browser

  - by Starfield

  Is it possible to determine the country of a mobile phone browser? I've read elsewhere that mobile phone IP addresses frequently change and can be reported as originating from different countries by some IP location databases. 1

  Read the article

• Is there a tool like phpMyAdmin which can be configured to access just a single database?

  - by Ritesh M Nayak

  Is there a tool like phpMyAdmin which can be configured to access only a single MySQL database in a server? I cannot use phpMyAdmin because it allows access to all databases. A view that can allow a user to create/delete/insert/update tables should do. I remember using a software similar to this but dont remember what it was. It would also be great if its in PHP.

  Read the article

• Common way to compare timestamp in oracle, postgres and SQL Server

  - by Pratik

  I am writing a sql query which involves finding if timestamp falls in particular range of days. I have written that in the postgres but it doesn't works in Oracle and SQL Server: AND creation_date < (CURRENT_TIMESTAMP - interval '5 days') AND creation_date >= (CURRENT_TIMESTAMP - interval '15 days') Is there are common way to compare the timestamp across different databases?

  Read the article

• How do you change the default collation of MySql for rake db:create:all in rails?

  - by Matt

  In my rails app I am running rake db:create:all in order to create the databases and I am prompted that the collations do not match. Is there a way to change the default MySQL collation? If not what is the best way around this? Thanks

  Read the article

• Creating views with PHP for couchDB

  - by Industrial

  Hi! I have started to try out noSQL databases now and are currently testing out couchDB. Seems like a good solution, but I really get some headache when I follow available examples on how to create views (queries) to select documents from a database and sort them. Everything I can find is regarding Javascript and it would be great to take part of some examples for PHP since that is the language we will use. So, how do I create views using PHP for couchDB?

  Read the article

• Is there an automatic way to generate a rollback script when inserting data with LINQ2SQL?

  - by Jedidja

  Let's assume we have a bunch of LINQ2SQL InsertOnSubmit statements against a given DataContext. If the SubmitChanges call is successful, is there any way to automatically generate a list of SQL commands (or even LINQ2SQL statements) that would automatically undo everything that was submitted? It's like executing a rollback even though everything worked as expected. Note: The destination database will either be Oracle or SQL Server, so if there is specific functionality for both databases that will achieve this, I'm happy to use that as well.

  Read the article

• How to configure multiple web site with django and tornado?

  - by mapcuk

  On my VDS I use nginx, django and tornado. I had just one project, Now i gonna deploy another one project with a different domain name. I want to use different databases and folders. I know how to configure nginx for serving static resourses , but what about tornado? Should i run separeted instance of tornado for each project or is there any better solution?

  Read the article

• tsql to know when a database was last shrunk

  - by Manjot

  Hi, In SQL 2000, 2005 and 2008, how can I know when databases were last shrunk on a MS SQL server? I want to do this using TSQL. Regards Manjot

  Read the article

• Can I chain database links in Oracle?

  - by RenderIn

  I have 3 databases. 1 links to 2, 2 links to 3. I'd like to query tables in 3, from 1. I tried third_db_tab@3@2 and it did not work. Wondering if this is possible and if so, what the syntax is.

  Read the article

• What ORM to use in one process multiple db connections sinatra application?

  - by Andrey Yatsyk

  Checked ActiveRecord, DataMapper, Sequel: some use globals (static variables) some require open db connection before loading source file with models. What ORM is better to use in sinatra application that uses different databases.

  Read the article

• How do you change the colors of the text when doing a Schema Compare in Visual Studio 2008 Database

  - by Jason Stevenson

  I am trying to find out how to modify the Colors / Fonts used in the Schema Compare "Object Definitions" window that appears after a comparison is done between two databases. The color scheme I have is unreadable, but I cannot seem to find the right settings in the Tools/Options/Environment/Fonts and Colors dialog. Thanks for any help. Jason

  Read the article

• Remote SQLite manager

  - by aip.cd.aish

  Does someone know of a Sqlite manager that I can put on my site, so that I can access it over the web and create/edit SQlite databases. I guess something like phpMyAdmin for MySQL.

  Read the article

• Team working on Drupal - Tips

  - by fighella

  I am working on a Drupal site with a few friends. Obviously we can Version control the code... but what do we do to keep each others databases in check? I have managed to get all the theming into files (contemplate etc), but ideally my views settings, menu settings would be in line also... (Not worried about Content either way as we're just building the framework) Any suggestions?

  Read the article

• Maintaining a secure database of user logins and info?

  - by Rafe Kettler

  I want to have a login form on a charity website I am building (it's for a friend, and I'm learning on the go), and I want to know what languages/software should I learn to build databases for user logins and info? Note: it HAS to be secure and relatively simple to learn for someone with moderate programming experience. Update: I understand that CMSs offer good tools for logins etc. but I want to do this all by myself.

  Read the article

• Can I create my own database from PHP?

  - by Roman

  I have a working PHP server. Now I want to use databases (MySQL or something similar). Is it possible to create a database from PHP? I would like to emphasize that in my case I do not have any user-name and password to which I can use to connect to MySQL server. I also do not have a control-panel where I could create a database or a table in an existing database.

  Read the article

• Where to start .NET Entity Framework and ORM?

  - by Freshblood

  Hello I haven't used any database system enough but i believe i know logic of databases and i have learnt little sql so i shouldn't start to learn ORM before learn them well? Where can i start to learn .NET Entity Framework and which version of framework i have to start 3.5 or 4.0 because i heard that 4.0 has strong support for Entity Framework.I am looking sources web pages,e-books or other else.

  Read the article

< Previous Page | 70 71 72 73 74 75 76 77 78 79 80 81  | Next Page >