将数据从本地数据库插入生产数据库 [英] insert data from local database to production database

问题描述

第一张表

First table

CREATE TABLE [dbo].[emp](
    [id] [int] IDENTITY(1,1) NOT NULL,
    [name] [varchar](50) NOT NULL
) ON [PRIMARY]

GO

第二张表

Second table

CREATE TABLE [dbo].[emp1](
    [id] [int] IDENTITY(1,1) NOT NULL,
    [name] [varchar](50) NOT NULL
) ON [PRIMARY]

GO

插入进入emp

Insert into emp

insert into emp (name) values ('a')
insert into emp (name) values ('b')
insert into emp (name) values ('c')

现在尝试将数据从emp插入emp1 ..

Now tried to insert data into emp1 from emp..

BEGIN TRAN
select COUNT(*) from emp
declare @NumRow int= 0
select @NumRow =  count(id) from emp
insert into emp1 (name) select name from emp
IF (@@ROWCOUNT = @NumRow AND @@ROWCOUNT > 0 )
BEGIN
        COMMIT TRAN
        print 'Inserting Records..'
        delete from emp
END
ELSE
    BEGIN
        ROLLBACK TRAN
        print 'error occured while inserting record'
    END

它成功地将数据从emp插入emp1并从emp中删除数据。如果emp和emp1都在同一台服务器上，则此查询很好。



但如果emp表在本地服务器上并且emp1在生产服务器上，该怎么办。





提前致谢.. !!

It successfully insert data from emp to emp1 and delete data from emp. This query is fine if both emp and emp1 are on same server.

But What to do if emp table is on local server and emp1 is on production server.


Thanks in advance..!!

推荐答案

请参阅：为远程SQL Server实例设置链接服务器 [ ^ ]

这篇关于将数据从本地数据库插入生产数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！