Copy values from one DB to another
I have the following script to copy records from one database to another, problem is I get an error because the table and fields already exist on the target database, which is OK, I don't need to create them I only need the data to be copied from source DB to target DB
SELECT
legal_entity_sk as legal_entity_sk,
company_sk as Employerid,
first_name as FirstNm,
last_name as LastNm,
middle_name as MiddleNm
INTO BDotSiskindImport.dbo.User
FROM Siskind.dbo.legal_entity
GO
SELECT
legal_entity_sk as legal_entity_sk,
company_sk as Employerid,
first_name as FirstNm,
last_name as LastNm,
middle_name as MiddleNm
INTO BDotSiskindImport.dbo.User
FROM Siskind.dbo.legal_entity
GO
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SQL
SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.
61K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
