CODEWITHSUNDEEP
sqlssis
mehdi lotfi
mehdi lotfi

Reputation: 11581

Create New Database By SSIS

I have two database named: olddatabase and newdatabase. I want to create a new database named newdatabase2 then copy database structure from newdatabase to newdatabase2 and then convert data from olddatabase to newdatabase2.

To copy database structure from newdatabase to newdatabase2 I use Transfer SQL Server Object Task component in SSIS, and then execute SSIS Package to convert data. But in step 1 I dont now how to create new database named newdatabase2. Currently I create the database manually.

Upvotes: 1

Views: 5978

Answers (1)

Diego
Diego

Reputation: 36166

There is a "Transfer Database Task". You can use it to make a copy of newdatabase to newdatabase2:

enter image description here

EDIT:

or you can use the "Copy Database Wizard" once. It will generate an SSIS package and a SQL Server job, then you can re-use it as many times as you want.

EDIT2: it would't make much sense to open on BIDS because you will only see something like this: enter image description here

I don't think these packages are meant to be editable. You can access it, though:

enter image description here

Upvotes: 3

Related Questions