473,779 Members | 2,063 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

how to attach database created in sql server management studio to the currnt project

21 New Member
Hi frnds,

i created a database in sqlserver management studio, and i know how to connect that database to the current project.

but problem is when i change to another system(pc), i need to run whole script in that system's sqlserver management studio, again to create the same database there. and again connect to it.

(i know this task how to do.)

but i want my database should be within my solution explorer so that "if i shift to any another system(pc) that database should be carried with my project solution"

i know that this(the above task) can be done using by adding SQLdatabase (.mdf & .ldf files) to the solution explorer.

but my problem is

i have created nearly 25 tables in sqlserver management studio,

when i added sqldatabase(.md f, .ldf files). i need add individual tables and save them.

which i feel is very risky task.

so i need a solution for export my whole database from "sqlserver management studio" to the "SQL database(.mdf, .ldf) file" in my current working project solution explorer.


frnds,
i think, i explained you clearly.

if there is mispells, sorry for that,

if any one of u guyz understand what i said above, pls reply to me

i'm waiting 4 ur reply.

ThanQs for ur patience....... .

praveen
Feb 20 '09 #1
0 2201

Sign in to post your reply or Sign up for a free account.

Similar topics

7
1885
by: Alex | last post by:
Hi all, I've been writing in ColdFusion for about 6 years now, and now that we've installed a Sharepoint Portal Server I'm finding that I need to use ASP.Net to make database calls. I'm finding no good documentation for someone who hasn't worked with ASP.Net... In ColdFusion it's a very simple task to pull data from a database... just setup the datasource in the CF Admin page and use something like this:
16
2326
by: Jeremy S. | last post by:
I'm about to install VS.NET 2005 and SQL Server 2005 on a new/clean development machine (XP Pro/SP2 etc). Is the order of installation important (i.e., which product should I install first)? Thanks!
4
5642
by: jeffreywgraham | last post by:
A word of warning, I am new to .NET and fairly new to SQL Server. The problem I have must be a common one, but I am uable to make it work. I have a .NET project and have the user management and roles working fine via Visual Studio and the default "ASPNewSQlMembershipProvider." There is database file called "ASPNETDB ..MDF", and users are easily created and logged in. I can access the tables fine. Now I just need to upload the...
3
8629
by: Freddie | last post by:
hi, i try to get the asp.net 2.0 security controls to work with SQL Server 2005 Dev RTM, this is my connetion string in mashine.config <connectionStrings> <add name="LocalSqlServer" connectionString="data source=.;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=false;" providerName="System.Data.SqlClient" />
4
3510
by: axel22 | last post by:
Ok, I've installed MS Sql Server Express, and I've created a database 'ProbnaBaza' and a table 'clan' in Management Studio. I tried using the database locally through a project in Visual Studio. I used the following connection string: "Server=.\\SQLEXPRESS;Initial Catalog=clan;Integrated Security=SSPI"; It worked perfectly. Then, I tried using the database by setting an IP address within the connectionString,
3
1963
by: =?Utf-8?B?UmljaGFyZCBCeXNvdXRo?= | last post by:
Hi I have 2 installers for my VB.NET app, one for the client app (exe, dlls, config etc.), one for server components (shared data files, sql express db). I have a few questions relating to the architecture of the deployment: 1. For the server install, I will be providing the mdf/ldf files. These either need to be attached to an existing SQL 2005 installation (any version) or SQL Express will need to be installed and the files attached...
0
1376
by: aboutjav.com | last post by:
Hi, How do I attach the .mdf and .ldf with the SQL Server Management Studio Express? Do I attached all 4 files? MyWebSiteName_log.LDF MyWebSiteName.mdf ASPNETDB.MDF aspnetdb_log.ldf
1
5602
by: ziycon | last post by:
I'm getting this error when i try to attach a DB:
9
7811
by: dpatel75 | last post by:
I am trying to copy a database from a SQL 2000 SP3 Windows 2000 server to a 2005 SP2 Windows 2003 server. I am trying to use detach and attach method (have tried both within Management Studio and T-SQL) and experience an error when attaching to the 2005 server: "CREATE FILE encountered operating system error 5 (error not found) while attempting to open or create the physical file 'xxxxxxxxxxxx' (Microsoft SQL Server, Error: 5123)" I have...
0
9636
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9474
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10306
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10138
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
9930
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7485
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5503
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4037
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3632
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.