Search Results

Search found 32851 results on 1315 pages for 'vsts database edition'.

Page 213/1315 | < Previous Page | 209 210 211 212 213 214 215 216 217 218 219 220  | Next Page >

• Any good SQL Anywhere database schema comparison tools?

  - by Lurker Indeed

  Are there any good database schema comparison tools out there that support Sybase SQL Anywhere version 10? I've seen a litany of them for SQL Server, a few for MySQL and Oracle, but nothing that supports SQL Anywhere correctly. I tried using DB Solo, but it turned all my non-unique indexes into unique ones, and I didn't see any options to change that.

  Read the article

• How to backup MySQL database?

  - by mouthpiec

  Is there a way to backup an MySQL database so that if something wrong occurs, it will be easy to recreate the tables with the same data?

  Read the article

• Truncate all tables in postgres database

  - by Aaron

  I regularly need to delete all the data from my postgresql database before a rebuild. How would I do this directly in SQL? At the moment I've managed to come up with a SQL statement that returns all the commands I need to execute: SELECT 'TRUNCATE TABLE ' || tablename || ';' FROM pg_tables WHERE tableowner='MYUSER'; but I cant see a way to execute them programatically once I have them... Thanks in advance

  Read the article

• Multiple Connection Types for one Designer Generated TableAdapter

  - by Tim

  I have a Windows Forms application with a DataSet (.xsd) that is currently set to connect to a Sql Ce database. Compact Edition is being used so the users can use this application in the field without an internet connection, and then sync their data at day's end. I have been given a new project to create a supplemental web interface for displaying some of the same reports as the Windows Forms application so certain users can obtain reports without installing the Windows app. What I've done so far is create a new Web Project and added it to my current Solution. I have split both the reports (.rdlc) and DataSets out of the Windows Forms project into their own projects so they can be accessed by both the Windows and Web applications. So far, this is working fine. Here's my dilemma: As I said before, the DataSets are currently set up to connect to a local Sql Ce database file. This is correct for the Windows app, but for the Web application I would like to use these same TableAdapters and queries to connect to the Sql Server 2005 database. I have found that the designer generated, strongly-typed TableAdapter classes have a ConnectionModifier property that allows you to make the TableAdapter's Connection public. This exposes the Connection property and allows me to set it, however it is strongly-typed as a SqlCeConnection, whereas I would like to set it to a SqlConnection for my Web project. I'm assuming the DataSet Designer strongly-types the Connection, Command, and DataAdapter objects based on the Provider of the ConnectionString as indicated in the app.config file. Is there any way I can use some generic provider so that the DataSet Designer will use object types that can connect to both a Sql Ce database file AND the actual Sql Server 2005 database? I know that SqlCeConnection and SqlConnection both inherit from DbConnection, which implements IDbConnection. Relatively, the same goes for SqlCeCommand/SqlCommand:DbCommand:IDbCommand. It would be nice if I could just figure out a way for the designer to use the Interface types rather than the strong types, but I'm hesitant that that is possible. I hope my problem and question are clear. Any help is much appreciated. Let me know if there's anything I can clarify.

  Read the article

• How do I connect to MSSQL 2008 database in Java with JDBC

  - by shuxer

  I have MSSQL 2008 installed on my local PC, and my Java application needs to connect to a MSSQL database. I am a new to MSSQL and I would like get some help on creating user login for my Java application and getting connection via JDBC. So far I tried to create a user login for my app and used following connection string, but I doesn't work at all. Any help and hint will be appreciated. jdbc:jtds:sqlserver://127.0.0.1:1433/dotcms username="shuxer" password="itarator"

  Read the article

• how to monitor if the connectivity between the rails apps and mysql database is established

  - by anusuya

  How do we monitor that the connectivity between the rails app and the database is established. will rails try to re-connect the connection with mysql if it closes?

  Read the article

• Error, could not create MachMessagePort for database doctor (com.apple.addressbook.migrationdaemon)

  - by user262998

  I'm working in address book for iphone. it generate address into UILabel. when I'm running the application everything goes well, but after showing about %30 of the addresses and sadenly stopped without any reason! Only in terminal shows: Error, could not create MachMessagePort for database doctor (com.apple.addressbook.migrationdaemon) starting in process migration Please help me!

  Read the article

• How to Generate Castle ActiveRecord C# Classes for an Existing Database

  - by Russell Giddings

  What is the best way to generate C# classes for use with Castle ActiveRecord and NHibernate given an existing database structure? Can you recommend any of the class generation tools or is it just less hassle to write the classes by hand?

  Read the article

• contents of page reload when any user post data in database in php

  - by Mayan Alagar Pandi

  Hello Tech Jargons, I have developing messenger in php. In my application in need to reload the content of div in a page while any user post their comments on database of server. Please kindly help me... Thanks in Advance Mayan Alagar.

  Read the article

• Multiuser XML document "database" for asp.net app

  - by Pierreten

  I was thinking about a way to allow multiple users to get CRUD access to an XML document in an asp.net app. The operations would obviously have to be made under the assumption of a multithreaded environment. For perf reasons, would it make sense to cache the document, and use a mutex on that cached version? When would changes be flushed to the physical XML document? Any and all recommendations are appreciated (also "use a database" isn't an option at this point unfortunately)

  Read the article

• SQLite database creation fails, documentation is unclear

  - by Lars D

  When I add this code to my Android 2.1 Java app, it fails: db=SQLiteDatabase.openOrCreateDatabase("Locations", null); Do I need a special permission to create a database, or can anybody provide a suggestion how to find out what goes wrong?

  Read the article

• Entity Framework: Generating database from classes

  - by Anonymous Coward

  Hi Everyone Is it possible to create the database from the classes with entity framework 4.0? I found many tutorials on how to do it the other way round. But since we have already implemented and tested all classes of the domain we'd like to avoid changing them to much. If I used the wrong keywords in Google I'd appreciate you could post a link. Cheers, CA

  Read the article

• Dataset to Database

  - by user181421

  Hello, I'm working with framework 2.0. I have a dataset with many rows that were entered by the user and I need to write them to the database. What is the right way to do it? TY

  Read the article

• ASP.Net: need help with dropdown list bound to a database column

  - by cloudravi

  I have created database which has columns - MemName - monthlyAmt - CurrentInstAmt I have bound the Memname column with a DropDownList box; onselection of memname value in DropDownList box, the corresponding values of currentInstAmt and monthlyamt should be displayed in Textbox. I am beginer in asp.net

  Read the article

• need to get value from the database and populate a drop down list using jquery

  - by jarus

  hi i need to populate a drop down list when i select a certain value , and the options need to be queried from the database .. can i achieve this from jquery ? if i can then please i would appreciate any help..

  Read the article

• SQL Select statement that includes a column that isn't in the database

  - by Cypher

  I'm trying to execute a SELECT statement that includes a column of a static string value. I've done this in Access, but never with raw SQL. Is this possible? Example: Name Status John Unpaid Terry Unpaid Joe Unpaid In the above example, the "Status" column doesn't exist in the database.

  Read the article

• [rails] do we need database level constraints

  - by shrimpy

  i have the same problem as in the following post http://stackoverflow.com/questions/1451570/ruby-on-rails-database-migration-not-creating-foreign-keys-in-mysql-tables so i am wondering, why rails do not support generate foreign key by default??? it is not necessary??? or we suppose to do it manually?

  Read the article

• Search MySQL Database

  - by McCrum

  Hey, I have put together an iPhone web app and i'm currently reading and displaying data from a MySQL database. I have added a search bar to this page and was wondering what the best way would be to search the content on the page. http://j.mp/c6lV8c

  Read the article

• How to create a huge Informix database?

  - by tabrez

  Can anyone provide me with a script for creating a huge database (for example, 2 GB of data) in IBM Informix Dynamic Server (IDS) version 11.50.FC4 on a Linux RHEL 64-bit machine?

  Read the article

• manually updating database table values are not reflecting in webpage - aspnet mvc

  - by FosterZ

  hi,i noticed some wierd problem i.e i have built a web page on which information comes from database table named "school", when i change some data in that table manually from mssql the web page data is still same as previous, its not gettin' changed, i dn't know how it is possible.

  Read the article

• Transport Database Query through Web Services without using Dataset

  - by Marty Trenouth

  Understanding that passing Datasets through web services is a bit heavy (and almost if not completely unconsumable to non .NET clients) what is the best way to prep database query results that don't map to known types for transport through web services in c#?

  Read the article

• Caching Mysql database for better performance

  - by kobey

  Hi, I'm using Amazon cloud and I've performance issue since the HDD is not located on my machine. My database is small (~500MB) and I can afford to keep it all in my RAM. I do not want to keep queries in my RAM, i need all the tables there. How can i do it? Thanks, Koby P.S. I'm using ubuntu server...

  Read the article

• Is their any tool that can create Ruby on Rail migration script of existing Database

  - by changed

  Hi I wanted to know if their is any tool that can be used to create sql migration script of existing database in Ruby on Rails. Also is their any visual tool that can be used to write Ruby on Rails migration script.

  Read the article

• Oracle Database Enforce CHECK on multiple tables

  - by GigaPr

  I am trying to enforce a CHECK Constraint in a ORACLE Database on multiple tables CREATE TABLE RollingStocks ( Id NUMBER, Name Varchar2(80) NOT NULL, RollingStockCategoryId NUMBER NOT NULL, CONSTRAINT Pk_RollingStocks Primary Key (Id), CONSTRAINT Check_RollingStocks_CategoryId CHECK ((RollingStockCategoryId IN (SELECT Id FROM FreightWagonTypes)) OR (RollingStockCategoryId IN (SELECT Id FROM LocomotiveClasses))) ); ...but i get the following error: *Cause: Subquery is not allowed here in the statement. *Action: Remove the subquery from the statement. Can you help me understanding what is the problem or how to achieve the same result?

  Read the article

• Symfony - Delete and reload all database records for each test

  - by Andree

  Hi there, From the Jobeet tutorial provided in Symfony website, I found out that I can load fixtures data each time I run unit test by using this script: Doctrine_Core::loadData(sfConfig::get('sf_test_dir').'/fixtures'); However, I want to delete and reload all records from database each time I run a unit test. Currently, I'm doing this manually (Run symfony doctrine:build --all before each test). Can someone provided me a correct way to do this?

  Read the article

< Previous Page | 209 210 211 212 213 214 215 216 217 218 219 220  | Next Page >