hey guys,
I am writing a VB6 app that dynamically generates a DTS package and saves it to a SQL server. This allows us a simple way to blow away and refresh test/training databases based on production DBs.
I've run into a situation... I use the TransferObjectsTask to copy all the structure from source DB to target DB. It is used to copy structure only. The problem is there is a bug with it that forces the filegroup to be set to PRIMARY for all the tables.
Details from MS here:
In trying to keep this as automated (streamlined is a better term) as possible, what are my options to get the table structures copied across withough having to manually generate ther script to do so from Enterprise Manager? I could technically still use TransferObjects for all other objects, its just hte tables I need to come across with the proper filegroups in-tact.
thanks for the help.
Jason
I am writing a VB6 app that dynamically generates a DTS package and saves it to a SQL server. This allows us a simple way to blow away and refresh test/training databases based on production DBs.
I've run into a situation... I use the TransferObjectsTask to copy all the structure from source DB to target DB. It is used to copy structure only. The problem is there is a bug with it that forces the filegroup to be set to PRIMARY for all the tables.
Details from MS here:
In trying to keep this as automated (streamlined is a better term) as possible, what are my options to get the table structures copied across withough having to manually generate ther script to do so from Enterprise Manager? I could technically still use TransferObjects for all other objects, its just hte tables I need to come across with the proper filegroups in-tact.
thanks for the help.
Jason