Hello,
I need to export all objects from a database to another database by programing in VC, but MSDN's example is in VB.
It is possible to use "TransferObjectsTask Object" in VC.But I don't know program step. Can you help me? thanks.Originally posted by n_fsk
Hello,
I need to export all objects from a database to another database by programing in VC, but MSDN's example is in VB.
It is possible to use "TransferObjectsTask Object" in VC.But I don't know program step. Can you help me? thanks.
you can make the DTS pacakge that does what u want (using Transfer Database task, etc.) and then save the DTS package as a VB file. You can then look at the code in VB for the DTS packages
Showing posts with label msdn. Show all posts
Showing posts with label msdn. Show all posts
Tuesday, March 27, 2012
Friday, February 17, 2012
DTS Import/Export Wizard
I have a problem here with my DTS Import/Export Wizard, according to MSDN Library stated below,
[When creating a table using the DTS Import/Export Wizard or DTS Designer, the owner of a table created at the destination is the current user (generally the dbo), regardless of who the owner is at the source. ]
My concern here is if i have a source table of owner A, how can I default the owner of a table created at the destination is A. The problem here is i have more that 20 table of owner A to transfer and i don't want the default to be dbo and i have to go and change each and everyone. Please advice.The most logical solution :
Register the server in EM with the login A. All tables will now be created with owner as A|||Originally posted by Enigma
The most logical solution :
Register the server in EM with the login A. All tables will now be created with owner as A
I had tried this logical solution. And it still give me dbo instead of user name A.
I try to import/export within the same server and i register the server using user A.
Please revert. Thank you very much.
[When creating a table using the DTS Import/Export Wizard or DTS Designer, the owner of a table created at the destination is the current user (generally the dbo), regardless of who the owner is at the source. ]
My concern here is if i have a source table of owner A, how can I default the owner of a table created at the destination is A. The problem here is i have more that 20 table of owner A to transfer and i don't want the default to be dbo and i have to go and change each and everyone. Please advice.The most logical solution :
Register the server in EM with the login A. All tables will now be created with owner as A|||Originally posted by Enigma
The most logical solution :
Register the server in EM with the login A. All tables will now be created with owner as A
I had tried this logical solution. And it still give me dbo instead of user name A.
I try to import/export within the same server and i register the server using user A.
Please revert. Thank you very much.
Subscribe to:
Posts (Atom)