|
Hello,
I've an Oracle database with two schemas. One is old and another is new. I would like to update the old schema with the new columns of the new schema.
I get the tables which have changes with the following query.
select distinct table_name from...
Started by coder247 on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Not handle
created/dropped tables data type/precision changes of existing columns ( ALTER TABLE MODIFY ) DEFAULT VALUES (so you can't apply it on a table with data when new column is NOT NULL ) Check constraints, Foreign Key constraints....
|
|
I have a table that got into the "db_owner" schema, and I need it in the "dbo" schema.
Is there a script or command to run to switch it over?
Started by DevelopingChris on
, 7 posts
by 7 people.
Answer Snippets (Read the full thread at stackoverflow):
You need to firstly stop all connections, 2005 & 2008) you can use the Server Explorer... .
ALTER SCHEMA NewSchama TRANSFER dbo.Table1
(1) Right click the table and select modify
(2) On the properties panel choose the correct owning schema.
|
|
I'm trying to copy data from one Oracle schema (CORE_DATA) into another (MY_DATA) using an 'INSERT INTO (...)' SQL statement.
What would the SQL statement look like?
Thanks,
Started by chabzjo on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Your schema must have grant create any table privilegePrefix your table names with the schema names when logged in as a user with access to both:
insert schema string,....
DATA to the table named table_name in MY_DATA.
|
Ask your Facebook Friends
|
I'm new to Data Generation Plans in Visual Studio, but I googled a bit and can't find the answer to this question. I've made modifications to my schema on the database side (changed the size of an NVARCHAR field) based on data that was generated by a ...
Started by brian on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
If you create a data generation plan and then the schema:
You create a data generation....
Doesn't the IDE force you to update your data generation plan if your schema changes anyway on the database schema of the project.
|
|
I have a Oracle database backup file (.dmp) that was created with expdp. The .dmp file was an export of an entire database. I need to restore 1 of the schemas from within this dump file. I dont know the names of the schemas inside this dump file. To use...
Started by KyleLanser on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Not ideal to the schema you're interested in, and you have to do a bit of text file searching for the various big files, you might be able to locate....
Then you can grab the schema names from that file.
A file of DDL (based on a full import).
|
|
I would like to compare two SQL Server databases including schema (table structure) and data in tables too. What is best tool to do this?
Started by tomaszs on
, 10 posts
by 10 people.
Answer Snippets (Read the full thread at stackoverflow):
I am using Red-Gate's software: http://www.red-gate.com
I use schema and data comparison the schemas plus data to plain-text.sql dumps, and then use a tool such as Beyond Compare to find the Schema Compare and Migration....
|
|
Hi
Is anyone aware of some work being done on generating RDF schema for a given RDF data instance ? It would be some thing like coming up with information like classes, their attributes, their associations(hierarchical or peer) with other classes and ...
Started by Andriyev on
, 3 posts
by 2 people.
Answer Snippets (Read the full thread at stackoverflow):
The schema? Using RDFS already tell you few things like if you have some specific triples, you can.
|
|
I am implementing a navigation-based application. The user will drill down to the node of interest. I am using Core Data, mostly because I want to try it out. How do I load the database initially? Should I write custom code that loads the database initially...
Started by Andrei Tanasescu on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
There....
Of your data, you may be able to reverse-engineer the XML schema enough to generate an XML-backed like a downside, I'd really like to see a tool for batch (shell) pre-population of data sources meant to be used by CoreData.
|
|
Are there techniques for comparing the same data stored in different schemas? The situation is something like this. If I have a db with schema A and it stores data for a feature in say, 5 tables. Schema A -> Schema B is done during an upgrade process...
Started by vholstein on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
I've used SQLAlchemy successfully for migration between one ....
Basically, you should create object representations for both schema versions, and then compare is, in principle, capable of mapping existing schema definitions onto objects.
|
|
RedGate makes a tool for Microsoft SQL Server that allows you to snapshot the difference between two databases. It generates the scripts needed to update the database schema while preserving the data.
I need to find a tool like this for the Firebird database...
Started by dthrasher on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
Does anyone have schema archive compare and synchronizations, data compare, sync, and masking, and configuration.
Scripts to migrate schema and data changes are XCase and Database Workbench .
|
