I'm needing to copy all the records from one database to another for just one table. Both DB;s are int the same directory. Can this be done with T-SQL like (Excuse the rough SQL, but it's serving as pseudocoode really):
INSERT INTO [SoftIT].[dbo].[tblBUlookup]
[BU_ID_Rec],
[CostCenter],
[BusinessUnit]
FROM
SELECT * FROM [TrackIT].[dbo].[tblBUlookup]