MS Sqlserver2000 Linked Server RRS feed

  • Question

  • All.Welcome();

    Nowadays Im refactoring  some of my old web applications,

     one of these has used MS Linked Server to export/Import data SQLserver DB to Access file, And Im asking you all ;

     Do you have a better solution than using linked server ? and Why ? Im waiting...





    I have developed this task in 2005 as apart from an E-government solution using .Net v1 and SQlserver 2000 , and the following Customer and Biz cases which related to this point :

    Customer Case: the system admin must have a way to select any number of db entities and export downloadable access file with a specific schema.

    Business Case: members of Administrators role have a privalge to Data Exporting/Importing page, for Exporting we allow the user to select from chick list boxs of aviabl DB Entities, then when he confirme his selections the page show the proccess status (Copying X enti..... Zipping the file  ...Click here to download).,








    Monday, June 11, 2007 1:28 PM