January 15, 2009 at 3:36 am
Hi all,
We are migrating a SQL2000 database to SQL2005.
In order to change the collation (different between 2000 and 2005), we decided to make those steps.
1-Restoring the original database on SQL2K5 on [originalname_TMP] : old collation
2-Creating a new but empty database with the [originalname] and new collation
3-Create a SSIS package : *.dtsx + config file
4-Scripting all in a beautiful *.cmd for our final users !
It seems to work fine for .....tables but our views are transformed in tables...
Good damned !!!
So, how to transform my View in View with SSIS ?
See you later
Philippe
January 15, 2009 at 10:26 am
Use the Transfer SQL Server Objects task to copy views.
Greg
January 16, 2009 at 3:31 am
God damned :blink:
I haven't saw this task in toolbox...! So It work fine.
Thank you very well Greg
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply