Another 'Insert INTO' question

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Another 'Insert INTO' question

Author

Topic

REEPER
Yak Posting Veteran

53 Posts

Posted - 2007-01-19 : 15:33:04

How can I copy data from 1 database to another on an entirely differant machine. Here is what I have so far:

INSERT INTO TOPS_BOM_MASTER
MaterialNo, Plant, MaterialGroup, UoM, MaterialDescription, CommisionGroup, SalesOrg, GroupDescription)
tmpSql.Append("SELECT MaterialNo, Plant, MaterialGroup, UoM, MaterialDescription, CommisionGroup, SalesOrg, GroupDescription
FROM de1.DE1.dbo.TOPS_BOM_MASTER

The database being copied to is: whisql2k.WHWSMaster.dbo.TOPS_BOM_MASTER

MCP, MCSD

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-01-19 : 15:36:43

You would need to add a linked server to de1. Then you can use the four part naming convention to get to it:

INSERT INTO whisql2k.WHWSMaster.dbo.TOPS_BOM_MASTER
MaterialNo, Plant, MaterialGroup, UoM, MaterialDescription, CommisionGroup, SalesOrg, GroupDescription)
tmpSql.Append("SELECT MaterialNo, Plant, MaterialGroup, UoM, MaterialDescription, CommisionGroup, SalesOrg, GroupDescription
FROM TOPS_BOM_MASTER

You could also add a linked server to whisql2k and do this as well:

INSERT INTO TOPS_BOM_MASTER
MaterialNo, Plant, MaterialGroup, UoM, MaterialDescription, CommisionGroup, SalesOrg, GroupDescription)
tmpSql.Append("SELECT MaterialNo, Plant, MaterialGroup, UoM, MaterialDescription, CommisionGroup, SalesOrg, GroupDescription
FROM DE1.dbo.TOPS_BOM_MASTER

Tara Kizer