Generating SQL Scripts

[manmaria]

Any one heard using scptxfr.exe to generate SQL scripts?

I have 2 databases with similar structure and around 40 tables. I like to generate a script to copy data from one table from first database into another database. Few tables are large and I do not want to copy all the data. So I want to generate a script to copy all the data from one DB to another except these few tables.

Thanks in advance,

 

[mrdenny]

Why not just use DTS (or SSIS) for this? Or the import\export wizzard?
I've never heard of that app before.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[Catadmin]

Like Denny saids, The DTS Import/Export is a wonderful thing (if you're using SQL 2000). You can pick and choose what tables to port over and do it all at once or have the Wizard create it as a package that you can schedule for the middle of the night.

SSIS has the same type of wizard if you right click the DB in SQL 2k5, go to All Tasks - Export Data.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"