|
With which tool / library it is possible to update an existing database structure. On the update of the software it is also needed to change the database. Because there can be different versions of the software it should compare the current status with...
Started by Horcrux7 on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
A database migrations tool, like.
Check out Liquibase.
Patches all applied to your sql database.
|
|
How do you update your SQL sever database when installing your product's update? Are there any tools that will integrate with windows installer? My typical schema changes are:
Adding/removing columns Adding/removing tables. Adding views. Adding/alter ...
Started by Aaron Fischer on
, 7 posts
by 7 people.
Answer Snippets (Read the full thread at stackoverflow):
You want to do build Have a table in the database to hold a list of schema changes that have been applied when you connect to your database, scan that table....
When your software connects to the database, rather than at install time.
|
|
How do i update mysql database with ajax and php with no page refresh
Started by djairo on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
HTML from the example page:
<html> <head> <script.
); ?>
?>
how can we get the value from database then update the database
to update the script to what you need.
|
Ask your Facebook Friends
|
Using dataadpter how to update data in database
Started by Seenu on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
If so, check out
this
myDataAdapter.Update(myDataSet);
A vague question at best merits a vague answer. .
I assume you're talking about SqlDataAdapter.
|
|
Is there a way to update more than one Database having same schema using single ObjectDataSource in C#???
i.e Just by providing more than one connection string is it some how possible to update more than one Database? I need to update/insert same record...
Started by NSK on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
I hope with an ObjectDataSource YOU ae....
Address, and need to touch on another database: your Update(...) method in your CustomerManager class database, .NET will automatically "upsize" the transaction to a distributed transaction.
|
|
So with LINQ-to-SQL I know you can update the database from the LINQ objects and update the LINQ objects from the SQL.
I am using LINQ's entity framework (a.k.a. LINQ-to-entities) and I can update the entities from the SQL database, but I can't update...
Started by Phobis on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
The database cannot be generated the LINQ to SQL Database....
RelationsRight now the EF model can only be generated from the database.
A preliminary, but working, version that can generate and update tables in your database.
|
|
I have a mySQL database that might have a table named jason . A separate instance of the database may not have the jason table (it would have other tables in common)
I'd like to run a simple update against both databases but the update is for the jason...
Started by Jason on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
You'll need to generate the schema information is in a database....
If you name a non-existant table, the update statement will fail to compile.
Just run the update statement, if the table didn't exist, it will fail and cause no damage.
|
|
Usually throughout development of a project I will deploy frequently, just to make sure I wont have any problems in production.
Also, throughout development, I find myself changing the database's schema.
How can I easily update the database in production...
Started by Ronnie Overby on
, 9 posts
by 9 people.
Answer Snippets (Read the full thread at stackoverflow):
You can also make ....
Alternatively, use a third party tool that can compare the two that are different .
Maintain a list of all the change scripts that you apply to your dev database and apply them to the Production database when deploying.
|
|
Righteo, Just started messing with Jquery, and I can update a database etc with it, but I want to know if there is a way to display new info posted into a database (even if it is not what was just posted) without a reload etc.
Don't write it out for me...
Started by Oliver Stubley on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Easiest solution is to poll to server....
Edit:
No way except to use a framework that handles the polling for your .
There is no way to initiate interaction from the server side .
The only way is to have the web page regularly poll the server for new info .
|
|
For my application I have to support update scenarios and the database might be affected.
I want to be able to update from an old version to the newest without installing intermediate versions. E.g. Suppose I have version A (the oldest), B (intermediate...
Answer Snippets (Read the full thread at stackoverflow):
I wrote this up in....
Personally, I'd worked a treat for me.
I don't believe a database version is a built in property of a database, however you can probably use an extended property.
This depends on your version of SQL Server you're using .
|
