gabepcsolutions
asked on
QUERIES AND SYNTAX
How do I copy a table from one database to another:
SELECT
FROM
WHERE
...how do I compare data from a field in a table with a table and a field in a another database.
SELECT
FROM
WHERE
...how do I compare data from a field in a table with a table and a field in a another database.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Could I use the same process to overwrite a whole database from another?
gabepcsolutions said:
>>Could I use the same process to overwrite a whole database from another?
In that case, I would just backup Database1, and then restore the backup over Database2.
>>Could I use the same process to overwrite a whole database from another?
In that case, I would just backup Database1, and then restore the backup over Database2.
Brandon makes a great point: my simple SQL will create the new table with the same data and column data types,
but it will not bring over indexes, constraints, triggers, etc.
Regards,
Patrick