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 |
|
cmaheshwari16
Starting Member
3 Posts |
 Posted - 2010-10-06 : 02:34:42
|
| I just wanted to know the following things if u can just help me.I made a website in Visual Studio 2008 and used the database provided by the VS [I dont know which version is this].That website runs successfully on the machine having visual studio[As in that i just attach my database through the GUI provided by VS].Now I want to deploy that website on a LAN. I have the database in .ldf and .mdf format. But I dont know whether it is in sql 2005 or sql 2008[as i made it through Visual Studio GUI]Now the system in which i have to deploy cannot have a licensed product. So i have to convert that database either to open source or an free version of sql server.I chose to go for SQL Server express edition that is free. Now the prolem being whether I use SQL Server 2008 or 2005 as i dont know which database was provided by the VS.[when i made that databse]But the problem being that on the system in which i have to deploy does not contain VS.Supposing it provides SQL Server 2005 express edition I permormed the following test:- Now i have installed .NET framework 3.5, MS SQL server 2005 Express Edition and the SQL Server management studio that is a GUI for handling d/b. Now when I attached that database[that i have, of which i dont have the version]. I can see the database and tbles and all the contents that was there in the d/b.[through that management studio GUI]. Now i have deployed my website on IIS also and when i browse my page i can see it on the browser but ....... I am not able to connect to the database tables as when i enter the login and password it comes to the same login page again without showing any error. Now, I cannot identify whether its due to the following reason:-1> The database that i have is in SQL server 2008 express edition or something else.2> I have to make some changes in the connectivity[in web.config or some other location]NOTE: Also when i connected the d/b in management stuio it shows all the tables with dbo as a prefix.for eg. suppose i had a table as User_Master than its showing as dbo.User_Master.please guide me if u can. Waiting for ur reply. |
|
|
|
|
|
How to find the version of the .ldf or .mdf format