| Subject | How to copy one table from one database to another, then drop table in originating database. |
|---|---|
| Author | Adrian Wreyford |
| Post date | 2005-07-05T11:15:13Z |
I have to upgrade a clients databases for a software upgrade.
Database1 has tableA in it which must be copied to database2
TableA and all its data must be copied.
The generator for table a also needs to be copied.
Both the TableA and GeneratorA for database1 must then be dropped.
Can I do this using DSQL, or what do you suggest the easiest way.
Can you please supply an example
Thanks
Adrian
[Non-text portions of this message have been removed]
Database1 has tableA in it which must be copied to database2
TableA and all its data must be copied.
The generator for table a also needs to be copied.
Both the TableA and GeneratorA for database1 must then be dropped.
Can I do this using DSQL, or what do you suggest the easiest way.
Can you please supply an example
Thanks
Adrian
[Non-text portions of this message have been removed]