SQL - Copy data from one database to another
I have a production database and a test database. I want to update data in a table from prod to test.
Example
Prod Dbase IP 2.2.2.2 Table Employees
Test Dbase IP 1.1.1.1 Table Employees
Want to update Test database table Employee (1.1.1.1) with data from Prod database table Employee (2.2.2.2)
Thanks
Example
Prod Dbase IP 2.2.2.2 Table Employees
Test Dbase IP 1.1.1.1 Table Employees
Want to update Test database table Employee (1.1.1.1) with data from Prod database table Employee (2.2.2.2)
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks.
ASKER
I want to update the email field in table employees.
I am selecting into #temp from prod to verify the data.
UPDATE employee
SET email = #temp.email
WHERE id = #temp.id