February 18, 2015 at 10:37 pm
Production and development servers are on different domains and they do not trust each other. How do I import data from the table t1 from a database db1 in production and load it into table t1 inside database db1 in development?
February 19, 2015 at 2:32 am
Use any ETL tool that fits your needs (BCP, SSIS, whatever) and SQL Server authentication.
-- Gianluca Sartori
February 19, 2015 at 4:51 am
You either have to make the connection between the two using a piece of software, or, you need to export to a shared resource and then import from that shared resource as two steps.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 23, 2015 at 1:48 am
Use an ETL tool...or easy way..use SQL Server Import/Export wizard with SQL Server Authentication.
____________________________________________________________
APViewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply