|
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....
|
|
We have a large XML file with lots of data relationships and lots of data. Is there a way to generate a DB schema based on the relationships and then load the data into the schema?
Started by Marcus on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Then write another XSLT which would generate is mentioned here: Generate XML Schema from oracle tables.
Just write an XSLT which would generate schema in SQL.
|
|
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.
|
Ask your Facebook Friends
|
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.
|
|
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.
|
