Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Copying from Database to Database on the same Server
- Thread starter ADB1
- Start date
You could submit a
CREATE TABLE newdb.tabname AS olddb.tabname WITH DATA;
for each table. This will copy including indices, but not Foreign Keys and SET/MULTISET.
Another way is backup olddb and restore into newdb using the COPY command.
Dieter
CREATE TABLE newdb.tabname AS olddb.tabname WITH DATA;
for each table. This will copy including indices, but not Foreign Keys and SET/MULTISET.
Another way is backup olddb and restore into newdb using the COPY command.
Dieter
- Status
Similar threads
- Locked
- Question
- Locked
- Question