Search Results

Search found 31319 results on 1253 pages for 'alter database'.

Page 346/1253 | < Previous Page | 342 343 344 345 346 347 348 349 350 351 352 353  | Next Page >

• What is the best framework for developing a Java CRUD for an existent database?

  - by Otavio

  We have a Java application with lots of config tables on the database (Oracle). We'd like to have Web-based GUIs for setting up these tables, that we currently update via SQL queries. What is the simplest way to develop CRUDs for a subset of our database? Is there any Java-based framework for doing this?

  Read the article

• how to forward engineer database diagram from visio 2003 file ?

  - by dotnetcoder

  I came across some vb macros that export it to a mdb ( ms access ) file. But does not work very well when copying forward constraints , etc. I want generate schema from the database diagram for sql server 2005 database.

  Read the article

• Is there a way to easily serialize form input into xml or yaml for database storage?

  - by aaandre

  I am dealing with an old app in asp classic vbscript. I'd like to store the input of a form in a database text field as the form fields are a subject to frequent change and I don't feel like normalizing the old database. Any solutions for serialization in vbscript? Thank you!

  Read the article

• How do I quickly rename a mysql database (change schema name)?

  - by deadprogrammer

  Usually I just dump the database and reimport it with a new name. This is not an option for very big databases. Apparently RENAME {DATABASE | SCHEMA} db_name TO new_db_name; does bad things, exist only in a handful of versions, and is a bad idea overall. Oh, one more thing - this needs to work with InnoDB, which stores things very differently than MyISAM.

  Read the article

• How to Dump only specific data table form a database in MySQL?

  - by Harish Kurup

  How to Dump only specific table from a database like if my Database has 10 table's and i want to dump only 3 tables of my choice...is it possible with "mysqldump" command...

  Read the article

• How are lookup columns for lists maintained in Sharepoint Content database?

  - by Abhishek Rao

  Can someone explain how are lookup columns for lists maintained in Sharepoint Content database? How is the relationship maintained in the database?

  Read the article

• Reliable Way To Transfer A MySQL Database From My LocalHost To A Hosted Server?

  - by Joshua

  I've just developed a large database, and am trying to put it online. I want to make sure that all the foreign keys, defaults, constraints, views etc, are preserved. When I try to export from my development PC using phpMyAdmin and then import on my hosted server, it errors out on all the views. Is there any other way to clone a database?

  Read the article

• Good test database on Windows to play around with data retrieval operations in SQL?

  - by ovr

  I need a test database to practice joins and other kinds of data retrieval operations in SQL. What's a good free test database and RDBMS system to use on Windows?

  Read the article

• Faster way to know the total number of rows in MySQL database?

  - by Starx

  If I need to know the total number of rows in a table of database I do something like this: $query = "SELECT * FROM tablename WHERE link='1';"; $result = mysql_query($query); $rows = mysql_fetch_array($result); $count = count($rows); So you see the total number of data is recovered scanning through the entire database. Is there a better way?

  Read the article

• How can I replicate an Oracle 11g database(data+structure) on my local machine for development?

  - by bron

  I am working on a test server with an Oracle 11g installed. I was wondering if there is anyway I can replicate the database(environment + data) on my local Linux machine. I am using a CentOS 5.3 on Windows XP with SUN Virtual Box. On Windows I am using sqldeveloper client to connect to the 11g database.

  Read the article

• Why is it necessary to remove and then re-add a user to a SQL Server database after restoring it fro

  - by Craig Johnston

  Why is it necessary to remove and then re-add a user to a SQL Server database after restoring it from a file? If I don't do this, I get a "User login failed" when trying to access the database using this username from apps.

  Read the article

• How can I split mySQL query logs by database?

  - by barnaby

  I've been trying to implement a mySQL Proxy solution that can separate out the queries into per-database logs. Everything I've Googled has pointed to mySQL Proxy but I can only seem to capture the database a connection was opened to, not which the current query is being issued against. Is it even possible? Is there a different tool to use? Thanks for any suggestions.

  Read the article

• one or more Entity models for one database for entity framework?

  - by KentZhou

  When use entity framework for DAL tier, VS 2010 can create edmx for each database. Question: If I have a database with many tables, should I create only one edmx for all tables or mutiple edmx files? for example, maybe all security tables for one edmx file, other tables for another edmx file. If there is more than one, then in other tiers, there will have more then on ObjectContext in code for business logic. Which one it the best solution for this case?

  Read the article

• How does one concatenate database values into a string?

  - by ggg

  I would like to string together database values into a string. Something like $a "text" $b. And then use the entire string as a variable, let's say $c. Is it better to do this at the database level? Will php use lots of resources to do this?

  Read the article

• How to read data from SQL database and store it into an XML file ?

  - by Morano88

  I have a Silverlight application that reads its content from an XML file. User can enter data and It'll be stored in SQL database. How can I read the data from SQL database and store it into an XML file ? Thanks,

  Read the article

• setting the datetime in jquery datetime picker with database datetime.

  - by sagar

  hi,i am developing a multi language site.My problem is i need to set the date and time in the datepicker from the database as the user may have choose the different timezone while registering in the site.At present i am getting the server time on my jquery datepicker. Thanks in advance. Technology used:Asp.net mvc,Jquery. Database:Sql server2005. O/s :winxp.

  Read the article

• How do I specify a recovery model (full, simple or bulk-logged) when creating a database in T-SQL co

  - by Ivan

  How do I specify a recovery model (full, simple or bulk-logged) when creating a database in a CREATE DATABASE query in T-SQL code?

  Read the article

• how to write the array into the sqlite database for objective-c ?

  - by uttam

  i have taken the data from databse into array now i want it to send it back into database by using the insert query. how can i insert the array of the data into the database.

  Read the article

• Faster way to know the tolal number of rows in Mysql Database?

  - by Starx

  If I need to know the total number of rows in a table of database I do something like $query = "SELECT * FROM tablename WHERE link='1';"; $result = mysql_query($query); $rows = mysql_fetch_array($result); $count = count($rows); So you see the total number of data is recovered scanning through entire database Is there a better way

  Read the article

• Where is the html5 local database located on a client machine?

  - by gath

  Am playing around with html5 local storage on different browsers (Firefox, Opera, Safari & Chrome) and am just wondering where is the location for the local database that i create using "opendatabase". Can i change the location of this database? Gath

  Read the article

• In Asp.net (c#) ,how to store an image in database(linq to sql) ?

  - by Anand

  i need to get an image from client and displayed(preview) before saving it into database..and then should be saved in database after getting preview..? Is is possible in Asp.net using c#... ?

  Read the article

• ADO.net - how do I reload database data into an existing & filled DataTable?

  - by Greg

  Hi, If I have an existing DataTable (already filled) but then I want to refresh/reload the data from the database directly (as I know there was a non-ADO.net process that changed data without going through the DataTable), however do I do this "refresh". Note the database data at that point can overwrite whatever is in the DataTable. thanks

  Read the article

• Is there a way to listen for changes in an MySQL database table using Java and JDBC?

  - by adrian7

  I have a number of users which are logged in at a time in my desktop application. They are working on the same table (create, read, update, delete data) so I have to update their views, to reflect changes, every few seconds - currently I am thinking to use a different thread to do that. I am using the MySQL database engine. Is there a way, using JDBC, to listen for changes on a specific table in the database and triggering a Java method only when changes are made?

  Read the article

• What is best way of keeping two database schema in synch?

  - by ebeworld

  We have two SQL server database, and one is kept in US and being changed from day to day and the other one is in India. What is the best way of keeping two database schema in synch. Does any functionality like sql server replication help?

  Read the article

• Best way to store a database password in a startup script / config file?

  - by Mark Harrison

  So our web server apps need to connect to the database, and some other apps have startup scripts that execute at boot time. What's the best way to store the name/password for these applications, in terms of security, e.g. perhaps we don't want sysadmins to know the database password maintainability, e.g. making the configuration easy to change when the password changes, etc. both windows and linux solutions appreciated!

  Read the article

< Previous Page | 342 343 344 345 346 347 348 349 350 351 352 353  | Next Page >