Results 1 to 2 of 2

Thread: Copy a database

  1. 06-12-2003, 11:31 AM #1
    Whil
    Whil is offline Registered User
    Join Date
    Jun 2003
    Posts
    3

    Copy a database

    Hi,
    I am using ADO and Visual Basic and SQL. How do i copy a table in a password protected database into another database that is not password protected?
    Thanks
    -Whil
    Reply With Quote Reply With Quote
  2. 06-12-2003, 12:27 PM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    I am not clear what you mean by password protected database, in SQL Server all databases are password protected.

    You call DTS object from VB to copy a table. When you make connection to source and target server/database you have to use proper connection string with login/password.
    http://databaseandstorage.blogspot.com
    http://gotodba.weebly.com
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules