Export import script automatically | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Export import script automatically

Hi ,
I am running export – Import wizard to transfer data from tables from
one Dataabse to other Database on the same server .
I want to generate script for the same and want to run it through
commnad ..or can it be scheduled to run automatically???…. Is it possible?? Please send me some good links … Rohit Kochar
MCP .Net(Web and SqlServer)
Company : TCS ,Noida
You can use plain TSQL with cross db joins to import/export data from one db to another on the same server and it can be schedule too… Ex: Copy a table from pubs to pub1.
select * into pubs1.aut from pubs..authours insert into pubs..test
select * from pubs1..test1
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.
Dear Mohammedu ,
I have applied the approach of SSIS package. It is working fine now . Now i want to run my
SSIS package ‘newpackage1’ from commond prompt so that it can be scheduled to run daily
.How can i make it to run from commond prompt?? Rohit Kochar
MCP .Net(Web and SqlServer)
Company : TCS ,Noida
You can schedule you SSIS package using SQL Agent job…
If you want to execute using command line check Dtexec.exe utility in BOL…
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.
]]>