homepage Welcome to WebmasterWorld Guest from 54.161.185.244
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Home / Forums Index / Microsoft / Microsoft IIS Web Server and ASP.NET
Forum Library, Charter, Moderators: ocean10000

Microsoft IIS Web Server and ASP.NET Forum

    
setting up local test server
problems exporting live sql server dbases
edzillion

5+ Year Member



 
Msg#: 3990192 posted 10:01 am on Sep 16, 2009 (gmt 0)

Hi

I am in the process of setting up a test server on my xp machine. Have installed visual studio 2008 and saved all the web folders locally. I still need to set up the SQL database locally though. I have some questions:

- Does VS2008 have a built-in test sql server? If not, which should I install?

- How do I export and save the live SQL dbase locally? myLittleAdmin is the dbase mgmt tool on the host, which isn't very useful. There is a 'query analyser' so that might let me run the relevant sql script (?)

Ed

 

marcel

WebmasterWorld Senior Member 5+ Year Member



 
Msg#: 3990192 posted 10:27 am on Sep 16, 2009 (gmt 0)

Does VS2008 have a built-in test sql server? If not, which should I install?

There should have been an option to also install SQL Server Express along with Visual Studio (I think it's checked by default) But if you do not have it installed you can get it here [microsoft.com]

How do I export and save the live SQL dbase locally? myLittleAdmin is the dbase mgmt tool on the host, which isn't very useful. There is a 'query analyser' so that might let me run the relevant sql script (?)

I'm not familiar with myLittleAdmin, but I have found that most hosts will create a backup of the database for you. You can then restore this to your local database with SQL Server Management Studio (Express)

edzillion

5+ Year Member



 
Msg#: 3990192 posted 1:10 pm on Sep 16, 2009 (gmt 0)

I have figured out how to backup from myLittleAdmin - which saves the file as a .bak file.

Then tried importing this using VS2008 'connect to database'. When I add all the details in and hit OK it prompts me to create an .mdf file. If I agree I get another window in which

server: .\SQLEXPRESS

database: master

If I hit OK again I get the error 'log in failed for user: <my dbase username>

edit: I took the database username and password values from the web.config file under <connectionStrings> so they should be correct(?)

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Microsoft / Microsoft IIS Web Server and ASP.NET
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved