468,136 Members | 1,435 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,136 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 2355
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
27 posts views Thread by didacticone | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.