January 14, 2019 at 6:00 am
Hi,
I have 100 databases, with 1000 table each database (all databases= 5 TB).
What is the most simple method to import all databases in a single UNIQUE database AUTOMATICAL ?
Thank you
G.
January 14, 2019 at 6:03 am
Mr_Q - Monday, January 14, 2019 6:00 AMHi,I have 100 databases, with 1000 table each database (all databases= 5 TB).
What is the most simple method to import all databases in a single UNIQUE database AUTOMATICAL ?
Thank you
Do all of the tables, across all of the databases, have different names?
What do you mean by 'unique database'?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
January 14, 2019 at 6:06 am
All tables have the same name. And all the databases are different names and are mounted on the same instances.
Through the unique database I understand a separate and independent database.
G.
January 14, 2019 at 6:42 am
Mr_Q - Monday, January 14, 2019 6:00 AMHi,I have 100 databases, with 1000 table each database (all databases= 5 TB).
What is the most simple method to import all databases in a single UNIQUE database AUTOMATICAL ?
Thank you
Quick questions:
1. Are you merging the content or is the data to be kept separate?
2. Do the databases have different schemas?
3. Are there any conflicts in any user/object/function/synonym etc. names?
January 14, 2019 at 7:07 am
Quick questions:
1. Are you merging the content or is the data to be kept separate?
R: For imported data, it is necessary to know (after import) the correspondence between the data and the source (for this it can be imported into a dedicated sql schema)
2. Do the databases have different schemas?
R: The schemas are the identical
3. Are there any conflicts in any user/object/function/synonym etc. names?
R: There are NO conflicts
G.
January 14, 2019 at 7:34 am
Hi,
Assuming you're aware than maintaining a 5 To database is way painful than 100 50Go databases, and if you don't have stored procedures of views (especially views of views issues), you have various solutions :
- Do a script who run through each database to script out 'SELECT INTO FROM' style scripts (if the tables are heaps), and run the script, putting the name of the database as schema
- Do a script who run through each database to script out 'CREATE TABLE' style scripts (if the tables are clusters or if you have more time, le first solution is faster to execute), and run the script, then script out some 'INSERT INTO' style script putting the name of the database as schema.
Again, a 5 To database is painful to maintain so think now about filegroups techniques and partitions before to run the big show!
Johan Jezequel
** Sorry for my english, I promess you I do my best **
January 14, 2019 at 9:21 am
Mr_Q - Monday, January 14, 2019 7:07 AMQuick questions:
1. Are you merging the content or is the data to be kept separate?
R: For imported data, it is necessary to know (after import) the correspondence between the data and the source (for this it can be imported into a dedicated sql schema)2. Do the databases have different schemas?
R: The schemas are the identical3. Are there any conflicts in any user/object/function/synonym etc. names?
R: There are NO conflicts
The next question is: do you have the space to duplicate the data during the consolidation?
😎
January 14, 2019 at 12:24 pm
Mr_Q - Monday, January 14, 2019 6:00 AMHi,I have 100 databases, with 1000 table each database (all databases= 5 TB).
What is the most simple method to import all databases in a single UNIQUE database AUTOMATICAL ?
Thank you
First step, find out where your 5000 TB server is located!
January 14, 2019 at 11:20 pm
I have enough space.
G.
January 21, 2019 at 9:28 pm
nobody has a solution?
G.
January 21, 2019 at 10:01 pm
Maybe they're waiting for you to post your plan for them to comment on?
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply