Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lthames
Starting Member
2 Posts |
 Posted - 2008-09-25 : 14:16:28
|
| I'm writing an app for a client that needs to read something from his MS SQL file and process into my application.Is there anyway I can do this and test it without having a live SQL server on hand?Thanks for any direction you can give me! |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-25 : 14:20:29
|
| you have an free version available called SQL Server Express which you can install and set up a test db and some tables required for app. |
 |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-09-25 : 14:37:39
|
| if its in .net using visual studio, just in the database explorer, just click add database.You can connect to either a local instance or remote instance. Or using MS SQL express, you can just add you .mdf file to the App_Data folder |
|
|
|
lthames
Starting Member
2 Posts |
Posted - 2008-09-25 : 16:29:23
|
| Thanks so much for your responses. I have installed ms sql server 2005 express AND the management studio express 2005. The file provided to me is a backup made from management studio express 2005. I copied this file to the backup folder under MSSQL.1\MSSQL\Backup folder.Then I opened the management studio and right clicked on databases and selected restore database. I set the source for restore to the backup folder and checked restore and then set the destination for restore to database . . and selected the file listed with the backup file name.I got the following error:Restore failed for Server 'LY_DESK\sqlexpress'. (Microsoft.sqlServer.Express.Smo)Additional information:System.Data.SqlClient.SqlError: The media set has 2 media families but only 1 are provided. All members must be provided. (Microsoft.SqlServer.Express.Smo)Any thoughts?NOTE . . . . being new to SQL I did not do anything before trying this (ie create a new database, etc). Thanks for any help!LynnI tried just restoring the database but I received an error that sait was expecing |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-09-25 : 16:47:17
|
| Well 2 things.1. You didnt confirm if its .net you are using but from the errorSystem.Data.SqlClient.SqlErrorThats a .net namespace.2. You dont need to set the path in Visual studio, once you have installed the database. Just go to the database explorer and click on add connection and set up the path, VStudio will add the connection string in your web.config file.From there, you can set up advanced features such as .net's encryption, timeouts and a whole lot of features. |
|
|
|
|
|
|
Anyway to develop app to access SQL w/o a server?