Hi All,
Basically what I need to do is import set of tables, procedures, indexes, views etc. from the source database to a target database. The complication in the process is that everytime the user should be able to pick and choose what tables that should be transfered to the target database. Also if a user pick a table then the dependant objects for that table should be imported to the target database.
I have looked in to create a DTS Package and using in visual basic to execute this package. Problem is that the DTS package is not importing the dependant procedures from the source database. I'm more familiar with writing procedures in sql server 7 than doing this in visual basic. Does anyone have any suggestions for me?
Thank you!
Basically what I need to do is import set of tables, procedures, indexes, views etc. from the source database to a target database. The complication in the process is that everytime the user should be able to pick and choose what tables that should be transfered to the target database. Also if a user pick a table then the dependant objects for that table should be imported to the target database.
I have looked in to create a DTS Package and using in visual basic to execute this package. Problem is that the DTS package is not importing the dependant procedures from the source database. I'm more familiar with writing procedures in sql server 7 than doing this in visual basic. Does anyone have any suggestions for me?
Thank you!