Results 1 to 3 of 3

Thread: database connection [RESOLVED]

  1. Dec 29th, 2003, 12:40 AM #1
    Andy
    Andy is offline

    Thread Starter
    Frenzied Member
    Join Date
    Nov 2003
    Posts
    1,489

    database connection [RESOLVED]

    I'm not sure if this is in the right forum but, since it deals with vb.net, I will try here first.

    I finally got an MS SQL server 2000 installed on my computer and finally figured out how to connect to the databases from vb.net using the server explorer and using the sqlconnector component.

    What I'd like to know is how to take this .sql script file I have that is a backup of one of my forums and use it to restore the forum's data. Just a quick and dirty lesson is all I need really.

    It isn't all that hard is it?
    Last edited by Andy; Feb 11th, 2004 at 09:54 PM.
    Reply With Quote Reply With Quote
  2. Dec 29th, 2003, 03:10 AM #2
    Edneeis
    Edneeis is offline
    Your Ad Here! Edneeis's Avatar
    Join Date
    Feb 2000
    Location
    Moreno Valley, CA (SoCal)
    Posts
    7,339
    Do you have MS SQL or MSDE? If you have SQL then the easiest way is to start the SQL Query Analyzer tool and just load and run the script in there. Otherwise you could probably just load the text of the script into the Server Explorer or in code and execute it that way.
    Utility to Convert Visual Studio.NET 2003 Project Files

    Edneeis.com
    Reply With Quote Reply With Quote
  3. Dec 29th, 2003, 03:31 AM #3
    Andy
    Andy is offline

    Thread Starter
    Frenzied Member
    Join Date
    Nov 2003
    Posts
    1,489
    I installed ms sql 2000. I will try that out ed. thanks!!
    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


Click Here to Expand Forum to Full Width