470,822 Members | 1,230 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,822 developers. It's quick & easy.

SQL Server EXPRESS and .MDF in Visual Studio

Hi

I have a bunch on tables and data in my local SQL Server 2005 Express master
DB and I want to export it to a database.mdf within my wwwroot (visual
studio) file - how can i do this?

Thanks for you help

leonaisse

Jan 6 '07 #1
3 2474
Hi leonaisse,
can you tell me that are you using Visual Studio.NET 2005 for
development of your website.

Regards,
Kunal Ramesh Lalwani
Sr Process Executive.
Styx Infosoft Pvt Ltd
ahmedabad 380054
(091) 9979391229 (M)
(091) 9998810566 (M)
Email:- ku**********@gmail.com

leonaisse wrote:
Hi

I have a bunch on tables and data in my local SQL Server 2005 Express master
DB and I want to export it to a database.mdf within my wwwroot (visual
studio) file - how can i do this?

Thanks for you help

leonaisse
Jan 6 '07 #2
Hi Kunal

It is Visual web developer 2005 Express! I hope this helps I have my local
SQL Server 2005 express connected and my remote SQL server 2005 (shared)
connected but i want to put the data in the MDF so i can upload that.

Thanks

Leonaisse

"kunal" <ku**********@gmail.comwrote in message
news:11********************@51g2000cwl.googlegroup s.com...
Hi leonaisse,
can you tell me that are you using Visual Studio.NET 2005 for
development of your website.

Regards,
Kunal Ramesh Lalwani
Sr Process Executive.
Styx Infosoft Pvt Ltd
ahmedabad 380054
(091) 9979391229 (M)
(091) 9998810566 (M)
Email:- ku**********@gmail.com

leonaisse wrote:
>Hi

I have a bunch on tables and data in my local SQL Server 2005 Express
master
DB and I want to export it to a database.mdf within my wwwroot (visual
studio) file - how can i do this?

Thanks for you help

leonaisse

Jan 6 '07 #3
You do not directly "put" data into MDF file, SQL Server/Express does (that
is, MDF file is part of SQL Server/Express).

In your previous post, you said you have a bunch of table/data in SQL Server
Express' master database and want to export them. Master database in SQL
Server is used by SQL Server itself to hold SQL Server's information itself,
not user's data. If the mentioned tables/data is your table /data, it must
be in a different database, not in master database of SQL Server.

If what you want to do is to transfer your data in your local SQL
Server/Express to another production SQL Server, you do not export your data
into MDF file (the data is already stored in mdf/ldf file). What you need to
do is to do a full back up to your database on the local SQL Server/Express
(you must know which database it is: a SQL Server/Express can hold many
databases), and then restore the backup (saved in a proper media, CD, DVD,
HD...) to the other SQL Server. You can also detach the database from your
local SQL Server/Express, and copy the mdf/ldf to a media, and then attach
it ti the other SQL Server.

"leonaisse" <le*******@hotmail.comwrote in message
news:e9**************@TK2MSFTNGP02.phx.gbl...
Hi Kunal

It is Visual web developer 2005 Express! I hope this helps I have my local
SQL Server 2005 express connected and my remote SQL server 2005 (shared)
connected but i want to put the data in the MDF so i can upload that.

Thanks

Leonaisse

"kunal" <ku**********@gmail.comwrote in message
news:11********************@51g2000cwl.googlegroup s.com...
>Hi leonaisse,
can you tell me that are you using Visual Studio.NET 2005 for
development of your website.

Regards,
Kunal Ramesh Lalwani
Sr Process Executive.
Styx Infosoft Pvt Ltd
ahmedabad 380054
(091) 9979391229 (M)
(091) 9998810566 (M)
Email:- ku**********@gmail.com

leonaisse wrote:
>>Hi

I have a bunch on tables and data in my local SQL Server 2005 Express
master
DB and I want to export it to a database.mdf within my wwwroot (visual
studio) file - how can i do this?

Thanks for you help

leonaisse


Jan 6 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by NetIdiot | last post: by
1 post views Thread by Darryl Kerkeslager | last post: by
14 posts views Thread by Developer | last post: by
2 posts views Thread by kress1963nov22 | last post: by
6 posts views Thread by Cirene | last post: by
reply views Thread by mihailmihai484 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.