Hello,
I have a report that is attempting to go out and grab images for certain
items off of a website. The URL is basically a guess and when it is
incorrect (404 File Not Found) RS returns an image of a red X. Is there an
expression I can use to hide the visibilty of the red X if one should appear?
I havn't been able to figure out how to do this.
Thanks!
Paulchecking the binary stream return value and if there is nothing then hide
the column displaying the image
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:616E1484-1B3D-4393-8974-F7C616A6051A@.microsoft.com...
> Hello,
> I have a report that is attempting to go out and grab images for certain
> items off of a website. The URL is basically a guess and when it is
> incorrect (404 File Not Found) RS returns an image of a red X. Is there
> an
> expression I can use to hide the visibilty of the red X if one should
> appear?
> I havn't been able to figure out how to do this.
> Thanks!
> Paul|||Ok, thanks for the post. How exactly do I go about checking the binary
stream return value in RS?
"Vaibhav" wrote:
> checking the binary stream return value and if there is nothing then hide
> the column displaying the image
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:616E1484-1B3D-4393-8974-F7C616A6051A@.microsoft.com...
> > Hello,
> >
> > I have a report that is attempting to go out and grab images for certain
> > items off of a website. The URL is basically a guess and when it is
> > incorrect (404 File Not Found) RS returns an image of a red X. Is there
> > an
> > expression I can use to hide the visibilty of the red X if one should
> > appear?
> > I havn't been able to figure out how to do this.
> >
> > Thanks!
> > Paul
>
>
Showing posts with label website. Show all posts
Showing posts with label website. Show all posts
Monday, March 26, 2012
Monday, March 12, 2012
Extend search function
Hello
In my website I have a textbox to search some products, but it would like to extend my search-function so that it could find special characters.
For example:
When I search Mexico, I would like to find México.
Is there an easy way to do this?
Thanks in Advance
Wesley
Hi Wesley,
As far as I know, there is no way to achieve this automatically. The only way is write custom code to substitute the characters and search again.
Sunday, February 26, 2012
Express sql database
Hi,
As far as I am aware, I have uploaded my website anddatabases (express) to the internet. I did this in VWD -> website > copywebsite. I assumed that my database would copy within the App_Datafolder..?
But I am getting errors which tend to suggest thedatabases aren't there? Have I done it correctly? If I have, then itmust be my connections - what do I need to adjust for them to work onthe web rather than just locally?
The hosting company definately supports express, and is set to 2.0.
Thanks!
Jon
check your web.config file for proper path for your database on the hosting server. and also make sure ASPNET account has read/write permission to app_data folder.
Friday, February 17, 2012
Exporting to Excel
I am having problems exporting to excel. When I try to export a report from
the SQL Server Reporting Services website the conditional color formating
doesn't come acrost. The nonconditional color formating comes acrost just
fine. If I try to export the same report from Visual Studio the formaing
exports just fine. What am I doing wrong or how can i get this to work.I read somewhere (though I can't remember where) that not all colours will
export to excel. Try changing the colour you are using for your conditional
hilighting to the same colour as that which you already have displayed in
excel. All my conditional colours display fine - though I don't have any
non-conditional colours if that makes sense.
"KO" wrote:
> I am having problems exporting to excel. When I try to export a report from
> the SQL Server Reporting Services website the conditional color formating
> doesn't come acrost. The nonconditional color formating comes acrost just
> fine. If I try to export the same report from Visual Studio the formaing
> exports just fine. What am I doing wrong or how can i get this to work.|||I've came across this issue recently. It not necessarily that the colors
don't come across. In the process formulas/functions are converted to an
Excel equivalent if one is found. The formulas/functions that get translated
are those that use report item expressions, not field expressions.
Otherwise, the result of the expression is stored in a cell as a constant
value.
For example, if a textbox contains an expression like
=Sum(Fields!UnitPrice.Value * Fields!OrderQty.Value) there is no equivalent
to that in Excel. So if you are using an IIF function in the color property
and your doing a test on a field: =IIF(Fields!UnitPrice.Value > 1500, Red,
Black) Excel doesn't know how to translate the Field expression. So it goes
with the first color Red and all the values in that column come out red.|||Hi russsage,
i've the same issue but i refer to ReportITems and not to Field...
can you give me some more tips?
Many thanks
"russsage" wrote:
> I've came across this issue recently. It not necessarily that the colors
> don't come across. In the process formulas/functions are converted to an
> Excel equivalent if one is found. The formulas/functions that get translated
> are those that use report item expressions, not field expressions.
> Otherwise, the result of the expression is stored in a cell as a constant
> value.
> For example, if a textbox contains an expression like
> =Sum(Fields!UnitPrice.Value * Fields!OrderQty.Value) there is no equivalent
> to that in Excel. So if you are using an IIF function in the color property
> and your doing a test on a field: =IIF(Fields!UnitPrice.Value > 1500, Red,
> Black) Excel doesn't know how to translate the Field expression. So it goes
> with the first color Red and all the values in that column come out red.|||I also had a color problem and hide/visible problem when exporting to excel.
I found that you must surround your settings in quotes otherwise you can get
unexpected results...
=IIF(Fields!UnitPrice.Value > 1500, "Red", "Black")
I have even had to set a standard value like this ="Visible". I know it
sounds wierd but it has worked in some instances for me.
Also... ditto on the color translation to excel. If the color is not in your
default excel palette then excel will mangle it and try to set it to the
nearest color. Some of my red shades end up as purple in excel. It can make
a nice report in RS look very ugly in excel.
Bill
russsage wrote:
>I've came across this issue recently. It not necessarily that the colors
>don't come across. In the process formulas/functions are converted to an
>Excel equivalent if one is found. The formulas/functions that get translated
>are those that use report item expressions, not field expressions.
>Otherwise, the result of the expression is stored in a cell as a constant
>value.
>For example, if a textbox contains an expression like
>=Sum(Fields!UnitPrice.Value * Fields!OrderQty.Value) there is no equivalent
>to that in Excel. So if you are using an IIF function in the color property
>and your doing a test on a field: =IIF(Fields!UnitPrice.Value > 1500, Red,
>Black) Excel doesn't know how to translate the Field expression. So it goes
>with the first color Red and all the values in that column come out red.
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200512/1
the SQL Server Reporting Services website the conditional color formating
doesn't come acrost. The nonconditional color formating comes acrost just
fine. If I try to export the same report from Visual Studio the formaing
exports just fine. What am I doing wrong or how can i get this to work.I read somewhere (though I can't remember where) that not all colours will
export to excel. Try changing the colour you are using for your conditional
hilighting to the same colour as that which you already have displayed in
excel. All my conditional colours display fine - though I don't have any
non-conditional colours if that makes sense.
"KO" wrote:
> I am having problems exporting to excel. When I try to export a report from
> the SQL Server Reporting Services website the conditional color formating
> doesn't come acrost. The nonconditional color formating comes acrost just
> fine. If I try to export the same report from Visual Studio the formaing
> exports just fine. What am I doing wrong or how can i get this to work.|||I've came across this issue recently. It not necessarily that the colors
don't come across. In the process formulas/functions are converted to an
Excel equivalent if one is found. The formulas/functions that get translated
are those that use report item expressions, not field expressions.
Otherwise, the result of the expression is stored in a cell as a constant
value.
For example, if a textbox contains an expression like
=Sum(Fields!UnitPrice.Value * Fields!OrderQty.Value) there is no equivalent
to that in Excel. So if you are using an IIF function in the color property
and your doing a test on a field: =IIF(Fields!UnitPrice.Value > 1500, Red,
Black) Excel doesn't know how to translate the Field expression. So it goes
with the first color Red and all the values in that column come out red.|||Hi russsage,
i've the same issue but i refer to ReportITems and not to Field...
can you give me some more tips?
Many thanks
"russsage" wrote:
> I've came across this issue recently. It not necessarily that the colors
> don't come across. In the process formulas/functions are converted to an
> Excel equivalent if one is found. The formulas/functions that get translated
> are those that use report item expressions, not field expressions.
> Otherwise, the result of the expression is stored in a cell as a constant
> value.
> For example, if a textbox contains an expression like
> =Sum(Fields!UnitPrice.Value * Fields!OrderQty.Value) there is no equivalent
> to that in Excel. So if you are using an IIF function in the color property
> and your doing a test on a field: =IIF(Fields!UnitPrice.Value > 1500, Red,
> Black) Excel doesn't know how to translate the Field expression. So it goes
> with the first color Red and all the values in that column come out red.|||I also had a color problem and hide/visible problem when exporting to excel.
I found that you must surround your settings in quotes otherwise you can get
unexpected results...
=IIF(Fields!UnitPrice.Value > 1500, "Red", "Black")
I have even had to set a standard value like this ="Visible". I know it
sounds wierd but it has worked in some instances for me.
Also... ditto on the color translation to excel. If the color is not in your
default excel palette then excel will mangle it and try to set it to the
nearest color. Some of my red shades end up as purple in excel. It can make
a nice report in RS look very ugly in excel.
Bill
russsage wrote:
>I've came across this issue recently. It not necessarily that the colors
>don't come across. In the process formulas/functions are converted to an
>Excel equivalent if one is found. The formulas/functions that get translated
>are those that use report item expressions, not field expressions.
>Otherwise, the result of the expression is stored in a cell as a constant
>value.
>For example, if a textbox contains an expression like
>=Sum(Fields!UnitPrice.Value * Fields!OrderQty.Value) there is no equivalent
>to that in Excel. So if you are using an IIF function in the color property
>and your doing a test on a field: =IIF(Fields!UnitPrice.Value > 1500, Red,
>Black) Excel doesn't know how to translate the Field expression. So it goes
>with the first color Red and all the values in that column come out red.
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200512/1
Wednesday, February 15, 2012
Exporting SQL Server Data
Hi,
We are migrating our website to a new hosting site. The site has a
CMS written in C# with a SQL Server backend. I need to migrate this
but the new hosting site will not allow me to restore the SQL Server
from backup at the new site and requires that I import CSV files.
How can I export the data to a CSV to import at the new hosting site?
Thank you very much.Hi
How about http://www.sqldts.com/299.aspx or you could use BCP and generate
the commands from sysobjects.
John
"KDawg44" <KDawg44@.gmail.com> wrote in message
news:74fd81da-6361-4544-aece-0330377841ce@.z38g2000hsc.googlegroups.com...
> Hi,
> We are migrating our website to a new hosting site. The site has a
> CMS written in C# with a SQL Server backend. I need to migrate this
> but the new hosting site will not allow me to restore the SQL Server
> from backup at the new site and requires that I import CSV files.
> How can I export the data to a CSV to import at the new hosting site?
> Thank you very much.
We are migrating our website to a new hosting site. The site has a
CMS written in C# with a SQL Server backend. I need to migrate this
but the new hosting site will not allow me to restore the SQL Server
from backup at the new site and requires that I import CSV files.
How can I export the data to a CSV to import at the new hosting site?
Thank you very much.Hi
How about http://www.sqldts.com/299.aspx or you could use BCP and generate
the commands from sysobjects.
John
"KDawg44" <KDawg44@.gmail.com> wrote in message
news:74fd81da-6361-4544-aece-0330377841ce@.z38g2000hsc.googlegroups.com...
> Hi,
> We are migrating our website to a new hosting site. The site has a
> CMS written in C# with a SQL Server backend. I need to migrate this
> but the new hosting site will not allow me to restore the SQL Server
> from backup at the new site and requires that I import CSV files.
> How can I export the data to a CSV to import at the new hosting site?
> Thank you very much.
Exporting SQL db from Visual Studio?
Hi
I have a Visual Studio website with an mdf file in the App_Data folder. I'm
trying to move my site to my webhost, and I think the only way it will work
is for me to "backup" the database to .bak files, and then import it.
Is it possible to backup/export the database in VS, or do I need to install
SQL Management Studio and connect to the instance running inside VS?
Thanks,
Dan
Your databases are not running under VS. SQL Server Express Edition or
Developer Edition (if your VS is Pro Ed.) would be installed when you
install VS 2005. So your databases are already being stored in a SQL Server
instance.
You can easily manage your databases using SQL Server Management Studio.
Ekrem ?nsoy
"musosdev" <musoswire@.community.nospam> wrote in message
news:EFC0CEB9-E133-44C3-A927-99F2B1A95215@.microsoft.com...
> Hi
> I have a Visual Studio website with an mdf file in the App_Data folder.
> I'm
> trying to move my site to my webhost, and I think the only way it will
> work
> is for me to "backup" the database to .bak files, and then import it.
> Is it possible to backup/export the database in VS, or do I need to
> install
> SQL Management Studio and connect to the instance running inside VS?
> Thanks,
>
> Dan
|||Hi Dan,
From your description, I understand that you would like to know if it is
possible to backup/export your database in Visual Studio.
If I have misunderstood, please let me know.
In Visual Studio 2005, it does not provide GUI feature for database backup
and restore, however you can create a T-SQL backup statement and execute it
in it. You may refer to the following steps:
1. Click View menu, select "Server Explorer", right click "Data
Connections", click "Add Connection...", and select your database server
and database;
2. Click Data menu, select "New Query", and directly click Close button in
the "Add Table" window;
3. Input "BACKUP DATABASE <database name> TO DISK='<backup path>'" to the
SQL window and execute it.
Also, you can use the utility osql.exe/sqlcmd.exe from command line to
backup your database. For example:
[osql utility - included in MDAC installed with Windows OS ]
osql -S <server name>\<instance name> -E
1> BACKUP DATABASE <database name> TO DISK='backup path'
2> Go
1> quit
[sqlcmd utility - included in SQL Native Client]
sqlcmd -S <server name>\<instance name> -E
1> BACKUP DATABASE <database name> TO DISK='backup path'
2> Go
1> quit
Hope this helps. If you have any other questions or concerns, please feel
free to let me know. It is my pleasure to be of assistance.
Best regards,
Charles Wang
Microsoft Online Community Support
================================================== ===
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====
|||Hi guys
Thank you both for your replies.
Having installed SQL MS and used it on my main server, I thought I'd go for
that as I know that quite well. So I actually downloaded and installed SQL
Server Management Studio Express.
This installed ok, saw the .\SQLEXPRESS instance, and allows me to connect
to it.
However, the database my website uses is not listed under DATABASES.
Any ideas why that might be, and how to make it appear?!
Thanks
Dan
"Charles Wang[MSFT]" wrote:
> Hi Dan,
> From your description, I understand that you would like to know if it is
> possible to backup/export your database in Visual Studio.
> If I have misunderstood, please let me know.
> In Visual Studio 2005, it does not provide GUI feature for database backup
> and restore, however you can create a T-SQL backup statement and execute it
> in it. You may refer to the following steps:
> 1. Click View menu, select "Server Explorer", right click "Data
> Connections", click "Add Connection...", and select your database server
> and database;
> 2. Click Data menu, select "New Query", and directly click Close button in
> the "Add Table" window;
> 3. Input "BACKUP DATABASE <database name> TO DISK='<backup path>'" to the
> SQL window and execute it.
> Also, you can use the utility osql.exe/sqlcmd.exe from command line to
> backup your database. For example:
> [osql utility - included in MDAC installed with Windows OS ]
> osql -S <server name>\<instance name> -E
> 1> BACKUP DATABASE <database name> TO DISK='backup path'
> 2> Go
> 1> quit
> [sqlcmd utility - included in SQL Native Client]
> sqlcmd -S <server name>\<instance name> -E
> 1> BACKUP DATABASE <database name> TO DISK='backup path'
> 2> Go
> 1> quit
> Hope this helps. If you have any other questions or concerns, please feel
> free to let me know. It is my pleasure to be of assistance.
> Best regards,
> Charles Wang
> Microsoft Online Community Support
> ================================================== ===
> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from this issue.
> ================================================== ====
> This posting is provided "AS IS" with no warranties, and confers no rights.
> ================================================== ====
>
|||Hello,
Is your database that your website uses located on your local hard drives or
is it located on another server?
If it's on your local hard drive, then you need to find that database's mdf
file and attach it to your current running SQL Server instance to manage it
using SSMSE.
If it's located on a remote server then you need to know its IP and add it
as an Alias using SQL Server Configuration Manager. So, you'd be able to
connect to that instance (so your database) using your SSMSE and using that
Alias.
Ekrem ?nsoy
"musosdev" <musoswire@.community.nospam> wrote in message
news:6D0F8324-F122-4644-93A7-7FF819D57D02@.microsoft.com...[vbcol=seagreen]
> Hi guys
> Thank you both for your replies.
> Having installed SQL MS and used it on my main server, I thought I'd go
> for
> that as I know that quite well. So I actually downloaded and installed SQL
> Server Management Studio Express.
> This installed ok, saw the .\SQLEXPRESS instance, and allows me to connect
> to it.
> However, the database my website uses is not listed under DATABASES.
> Any ideas why that might be, and how to make it appear?!
> Thanks
>
> Dan
>
> "Charles Wang[MSFT]" wrote:
|||Hi Dan,
I am not an expert regarding ASP.NET, however from my research, your web
application is using SQL Server 2005 Express Edition User Instances:
SQL Server 2005 Express Edition User Instances
http://msdn2.microsoft.com/en-us/library/bb264564.aspx
I performed a simple test at my side. You can easily create a database in a
web application under the App_Data folder. You can easily manage it in
Visual Studio. When you double click the .mdf file, the database will be
displayed under the Data Connections in Server Explorer.
The database created in user instance will not be displayed in SSMS by
default, however you can refer to the section "Connecting to User Instances
from Other Clients" in the above article or the following article for
connecting to the user instance in SSMSE:
How to: Connect to a User Instance
http://msdn2.microsoft.com/en-us/library/aa337276.aspx
I looked through your original post carefully and I thought that your real
concern was that you would like to move your database to another webhost
together with your web application. However what is the matter if you
directly copy all the database files together with your website? or you can
use "Copy Website" or "Publish Website" to your remote server in Visual
Studio 2005? Make sure that you have detached the database in Visual Studio
2005 before you perform the progress.
If you have any other questions or concerns, please feel free to let me
know. Have a nice day!
Best regards,
Charles Wang
Microsoft Online Community Support
================================================== ===
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====
I have a Visual Studio website with an mdf file in the App_Data folder. I'm
trying to move my site to my webhost, and I think the only way it will work
is for me to "backup" the database to .bak files, and then import it.
Is it possible to backup/export the database in VS, or do I need to install
SQL Management Studio and connect to the instance running inside VS?
Thanks,
Dan
Your databases are not running under VS. SQL Server Express Edition or
Developer Edition (if your VS is Pro Ed.) would be installed when you
install VS 2005. So your databases are already being stored in a SQL Server
instance.
You can easily manage your databases using SQL Server Management Studio.
Ekrem ?nsoy
"musosdev" <musoswire@.community.nospam> wrote in message
news:EFC0CEB9-E133-44C3-A927-99F2B1A95215@.microsoft.com...
> Hi
> I have a Visual Studio website with an mdf file in the App_Data folder.
> I'm
> trying to move my site to my webhost, and I think the only way it will
> work
> is for me to "backup" the database to .bak files, and then import it.
> Is it possible to backup/export the database in VS, or do I need to
> install
> SQL Management Studio and connect to the instance running inside VS?
> Thanks,
>
> Dan
|||Hi Dan,
From your description, I understand that you would like to know if it is
possible to backup/export your database in Visual Studio.
If I have misunderstood, please let me know.
In Visual Studio 2005, it does not provide GUI feature for database backup
and restore, however you can create a T-SQL backup statement and execute it
in it. You may refer to the following steps:
1. Click View menu, select "Server Explorer", right click "Data
Connections", click "Add Connection...", and select your database server
and database;
2. Click Data menu, select "New Query", and directly click Close button in
the "Add Table" window;
3. Input "BACKUP DATABASE <database name> TO DISK='<backup path>'" to the
SQL window and execute it.
Also, you can use the utility osql.exe/sqlcmd.exe from command line to
backup your database. For example:
[osql utility - included in MDAC installed with Windows OS ]
osql -S <server name>\<instance name> -E
1> BACKUP DATABASE <database name> TO DISK='backup path'
2> Go
1> quit
[sqlcmd utility - included in SQL Native Client]
sqlcmd -S <server name>\<instance name> -E
1> BACKUP DATABASE <database name> TO DISK='backup path'
2> Go
1> quit
Hope this helps. If you have any other questions or concerns, please feel
free to let me know. It is my pleasure to be of assistance.
Best regards,
Charles Wang
Microsoft Online Community Support
================================================== ===
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====
|||Hi guys
Thank you both for your replies.
Having installed SQL MS and used it on my main server, I thought I'd go for
that as I know that quite well. So I actually downloaded and installed SQL
Server Management Studio Express.
This installed ok, saw the .\SQLEXPRESS instance, and allows me to connect
to it.
However, the database my website uses is not listed under DATABASES.
Any ideas why that might be, and how to make it appear?!
Thanks
Dan
"Charles Wang[MSFT]" wrote:
> Hi Dan,
> From your description, I understand that you would like to know if it is
> possible to backup/export your database in Visual Studio.
> If I have misunderstood, please let me know.
> In Visual Studio 2005, it does not provide GUI feature for database backup
> and restore, however you can create a T-SQL backup statement and execute it
> in it. You may refer to the following steps:
> 1. Click View menu, select "Server Explorer", right click "Data
> Connections", click "Add Connection...", and select your database server
> and database;
> 2. Click Data menu, select "New Query", and directly click Close button in
> the "Add Table" window;
> 3. Input "BACKUP DATABASE <database name> TO DISK='<backup path>'" to the
> SQL window and execute it.
> Also, you can use the utility osql.exe/sqlcmd.exe from command line to
> backup your database. For example:
> [osql utility - included in MDAC installed with Windows OS ]
> osql -S <server name>\<instance name> -E
> 1> BACKUP DATABASE <database name> TO DISK='backup path'
> 2> Go
> 1> quit
> [sqlcmd utility - included in SQL Native Client]
> sqlcmd -S <server name>\<instance name> -E
> 1> BACKUP DATABASE <database name> TO DISK='backup path'
> 2> Go
> 1> quit
> Hope this helps. If you have any other questions or concerns, please feel
> free to let me know. It is my pleasure to be of assistance.
> Best regards,
> Charles Wang
> Microsoft Online Community Support
> ================================================== ===
> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from this issue.
> ================================================== ====
> This posting is provided "AS IS" with no warranties, and confers no rights.
> ================================================== ====
>
|||Hello,
Is your database that your website uses located on your local hard drives or
is it located on another server?
If it's on your local hard drive, then you need to find that database's mdf
file and attach it to your current running SQL Server instance to manage it
using SSMSE.
If it's located on a remote server then you need to know its IP and add it
as an Alias using SQL Server Configuration Manager. So, you'd be able to
connect to that instance (so your database) using your SSMSE and using that
Alias.
Ekrem ?nsoy
"musosdev" <musoswire@.community.nospam> wrote in message
news:6D0F8324-F122-4644-93A7-7FF819D57D02@.microsoft.com...[vbcol=seagreen]
> Hi guys
> Thank you both for your replies.
> Having installed SQL MS and used it on my main server, I thought I'd go
> for
> that as I know that quite well. So I actually downloaded and installed SQL
> Server Management Studio Express.
> This installed ok, saw the .\SQLEXPRESS instance, and allows me to connect
> to it.
> However, the database my website uses is not listed under DATABASES.
> Any ideas why that might be, and how to make it appear?!
> Thanks
>
> Dan
>
> "Charles Wang[MSFT]" wrote:
|||Hi Dan,
I am not an expert regarding ASP.NET, however from my research, your web
application is using SQL Server 2005 Express Edition User Instances:
SQL Server 2005 Express Edition User Instances
http://msdn2.microsoft.com/en-us/library/bb264564.aspx
I performed a simple test at my side. You can easily create a database in a
web application under the App_Data folder. You can easily manage it in
Visual Studio. When you double click the .mdf file, the database will be
displayed under the Data Connections in Server Explorer.
The database created in user instance will not be displayed in SSMS by
default, however you can refer to the section "Connecting to User Instances
from Other Clients" in the above article or the following article for
connecting to the user instance in SSMSE:
How to: Connect to a User Instance
http://msdn2.microsoft.com/en-us/library/aa337276.aspx
I looked through your original post carefully and I thought that your real
concern was that you would like to move your database to another webhost
together with your web application. However what is the matter if you
directly copy all the database files together with your website? or you can
use "Copy Website" or "Publish Website" to your remote server in Visual
Studio 2005? Make sure that you have detached the database in Visual Studio
2005 before you perform the progress.
If you have any other questions or concerns, please feel free to let me
know. Have a nice day!
Best regards,
Charles Wang
Microsoft Online Community Support
================================================== ===
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====
Exporting SQL db from Visual Studio?
Hi
I have a Visual Studio website with an mdf file in the App_Data folder. I'm
trying to move my site to my webhost, and I think the only way it will work
is for me to "backup" the database to .bak files, and then import it.
Is it possible to backup/export the database in VS, or do I need to install
SQL Management Studio and connect to the instance running inside VS?
Thanks,
DanYour databases are not running under VS. SQL Server Express Edition or
Developer Edition (if your VS is Pro Ed.) would be installed when you
install VS 2005. So your databases are already being stored in a SQL Server
instance.
You can easily manage your databases using SQL Server Management Studio.
--
Ekrem Ã?nsoy
"musosdev" <musoswire@.community.nospam> wrote in message
news:EFC0CEB9-E133-44C3-A927-99F2B1A95215@.microsoft.com...
> Hi
> I have a Visual Studio website with an mdf file in the App_Data folder.
> I'm
> trying to move my site to my webhost, and I think the only way it will
> work
> is for me to "backup" the database to .bak files, and then import it.
> Is it possible to backup/export the database in VS, or do I need to
> install
> SQL Management Studio and connect to the instance running inside VS?
> Thanks,
>
> Dan|||Hi Dan,
From your description, I understand that you would like to know if it is
possible to backup/export your database in Visual Studio.
If I have misunderstood, please let me know.
In Visual Studio 2005, it does not provide GUI feature for database backup
and restore, however you can create a T-SQL backup statement and execute it
in it. You may refer to the following steps:
1. Click View menu, select "Server Explorer", right click "Data
Connections", click "Add Connection...", and select your database server
and database;
2. Click Data menu, select "New Query", and directly click Close button in
the "Add Table" window;
3. Input "BACKUP DATABASE <database name> TO DISK='<backup path>'" to the
SQL window and execute it.
Also, you can use the utility osql.exe/sqlcmd.exe from command line to
backup your database. For example:
[osql utility - included in MDAC installed with Windows OS ]
osql -S <server name>\<instance name> -E
1> BACKUP DATABASE <database name> TO DISK='backup path'
2> Go
1> quit
[sqlcmd utility - included in SQL Native Client]
sqlcmd -S <server name>\<instance name> -E
1> BACKUP DATABASE <database name> TO DISK='backup path'
2> Go
1> quit
Hope this helps. If you have any other questions or concerns, please feel
free to let me know. It is my pleasure to be of assistance.
Best regards,
Charles Wang
Microsoft Online Community Support
=====================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||Hi guys
Thank you both for your replies.
Having installed SQL MS and used it on my main server, I thought I'd go for
that as I know that quite well. So I actually downloaded and installed SQL
Server Management Studio Express.
This installed ok, saw the .\SQLEXPRESS instance, and allows me to connect
to it.
However, the database my website uses is not listed under DATABASES. :(
Any ideas why that might be, and how to make it appear?!
Thanks
Dan
"Charles Wang[MSFT]" wrote:
> Hi Dan,
> From your description, I understand that you would like to know if it is
> possible to backup/export your database in Visual Studio.
> If I have misunderstood, please let me know.
> In Visual Studio 2005, it does not provide GUI feature for database backup
> and restore, however you can create a T-SQL backup statement and execute it
> in it. You may refer to the following steps:
> 1. Click View menu, select "Server Explorer", right click "Data
> Connections", click "Add Connection...", and select your database server
> and database;
> 2. Click Data menu, select "New Query", and directly click Close button in
> the "Add Table" window;
> 3. Input "BACKUP DATABASE <database name> TO DISK='<backup path>'" to the
> SQL window and execute it.
> Also, you can use the utility osql.exe/sqlcmd.exe from command line to
> backup your database. For example:
> [osql utility - included in MDAC installed with Windows OS ]
> osql -S <server name>\<instance name> -E
> 1> BACKUP DATABASE <database name> TO DISK='backup path'
> 2> Go
> 1> quit
> [sqlcmd utility - included in SQL Native Client]
> sqlcmd -S <server name>\<instance name> -E
> 1> BACKUP DATABASE <database name> TO DISK='backup path'
> 2> Go
> 1> quit
> Hope this helps. If you have any other questions or concerns, please feel
> free to let me know. It is my pleasure to be of assistance.
> Best regards,
> Charles Wang
> Microsoft Online Community Support
> =====================================================> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from this issue.
> ======================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
> ======================================================>|||Hello,
Is your database that your website uses located on your local hard drives or
is it located on another server?
If it's on your local hard drive, then you need to find that database's mdf
file and attach it to your current running SQL Server instance to manage it
using SSMSE.
If it's located on a remote server then you need to know its IP and add it
as an Alias using SQL Server Configuration Manager. So, you'd be able to
connect to that instance (so your database) using your SSMSE and using that
Alias.
--
Ekrem Ã?nsoy
"musosdev" <musoswire@.community.nospam> wrote in message
news:6D0F8324-F122-4644-93A7-7FF819D57D02@.microsoft.com...
> Hi guys
> Thank you both for your replies.
> Having installed SQL MS and used it on my main server, I thought I'd go
> for
> that as I know that quite well. So I actually downloaded and installed SQL
> Server Management Studio Express.
> This installed ok, saw the .\SQLEXPRESS instance, and allows me to connect
> to it.
> However, the database my website uses is not listed under DATABASES. :(
> Any ideas why that might be, and how to make it appear?!
> Thanks
>
> Dan
>
> "Charles Wang[MSFT]" wrote:
>> Hi Dan,
>> From your description, I understand that you would like to know if it is
>> possible to backup/export your database in Visual Studio.
>> If I have misunderstood, please let me know.
>> In Visual Studio 2005, it does not provide GUI feature for database
>> backup
>> and restore, however you can create a T-SQL backup statement and execute
>> it
>> in it. You may refer to the following steps:
>> 1. Click View menu, select "Server Explorer", right click "Data
>> Connections", click "Add Connection...", and select your database server
>> and database;
>> 2. Click Data menu, select "New Query", and directly click Close button
>> in
>> the "Add Table" window;
>> 3. Input "BACKUP DATABASE <database name> TO DISK='<backup path>'" to the
>> SQL window and execute it.
>> Also, you can use the utility osql.exe/sqlcmd.exe from command line to
>> backup your database. For example:
>> [osql utility - included in MDAC installed with Windows OS ]
>> osql -S <server name>\<instance name> -E
>> 1> BACKUP DATABASE <database name> TO DISK='backup path'
>> 2> Go
>> 1> quit
>> [sqlcmd utility - included in SQL Native Client]
>> sqlcmd -S <server name>\<instance name> -E
>> 1> BACKUP DATABASE <database name> TO DISK='backup path'
>> 2> Go
>> 1> quit
>> Hope this helps. If you have any other questions or concerns, please feel
>> free to let me know. It is my pleasure to be of assistance.
>> Best regards,
>> Charles Wang
>> Microsoft Online Community Support
>> =====================================================>> When responding to posts, please "Reply to Group" via
>> your newsreader so that others may learn and benefit
>> from this issue.
>> ======================================================>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> ======================================================>>|||Hi Dan,
I am not an expert regarding ASP.NET, however from my research, your web
application is using SQL Server 2005 Express Edition User Instances:
SQL Server 2005 Express Edition User Instances
http://msdn2.microsoft.com/en-us/library/bb264564.aspx
I performed a simple test at my side. You can easily create a database in a
web application under the App_Data folder. You can easily manage it in
Visual Studio. When you double click the .mdf file, the database will be
displayed under the Data Connections in Server Explorer.
The database created in user instance will not be displayed in SSMS by
default, however you can refer to the section "Connecting to User Instances
from Other Clients" in the above article or the following article for
connecting to the user instance in SSMSE:
How to: Connect to a User Instance
http://msdn2.microsoft.com/en-us/library/aa337276.aspx
I looked through your original post carefully and I thought that your real
concern was that you would like to move your database to another webhost
together with your web application. However what is the matter if you
directly copy all the database files together with your website? or you can
use "Copy Website" or "Publish Website" to your remote server in Visual
Studio 2005? Make sure that you have detached the database in Visual Studio
2005 before you perform the progress.
If you have any other questions or concerns, please feel free to let me
know. Have a nice day!
Best regards,
Charles Wang
Microsoft Online Community Support
=====================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================
I have a Visual Studio website with an mdf file in the App_Data folder. I'm
trying to move my site to my webhost, and I think the only way it will work
is for me to "backup" the database to .bak files, and then import it.
Is it possible to backup/export the database in VS, or do I need to install
SQL Management Studio and connect to the instance running inside VS?
Thanks,
DanYour databases are not running under VS. SQL Server Express Edition or
Developer Edition (if your VS is Pro Ed.) would be installed when you
install VS 2005. So your databases are already being stored in a SQL Server
instance.
You can easily manage your databases using SQL Server Management Studio.
--
Ekrem Ã?nsoy
"musosdev" <musoswire@.community.nospam> wrote in message
news:EFC0CEB9-E133-44C3-A927-99F2B1A95215@.microsoft.com...
> Hi
> I have a Visual Studio website with an mdf file in the App_Data folder.
> I'm
> trying to move my site to my webhost, and I think the only way it will
> work
> is for me to "backup" the database to .bak files, and then import it.
> Is it possible to backup/export the database in VS, or do I need to
> install
> SQL Management Studio and connect to the instance running inside VS?
> Thanks,
>
> Dan|||Hi Dan,
From your description, I understand that you would like to know if it is
possible to backup/export your database in Visual Studio.
If I have misunderstood, please let me know.
In Visual Studio 2005, it does not provide GUI feature for database backup
and restore, however you can create a T-SQL backup statement and execute it
in it. You may refer to the following steps:
1. Click View menu, select "Server Explorer", right click "Data
Connections", click "Add Connection...", and select your database server
and database;
2. Click Data menu, select "New Query", and directly click Close button in
the "Add Table" window;
3. Input "BACKUP DATABASE <database name> TO DISK='<backup path>'" to the
SQL window and execute it.
Also, you can use the utility osql.exe/sqlcmd.exe from command line to
backup your database. For example:
[osql utility - included in MDAC installed with Windows OS ]
osql -S <server name>\<instance name> -E
1> BACKUP DATABASE <database name> TO DISK='backup path'
2> Go
1> quit
[sqlcmd utility - included in SQL Native Client]
sqlcmd -S <server name>\<instance name> -E
1> BACKUP DATABASE <database name> TO DISK='backup path'
2> Go
1> quit
Hope this helps. If you have any other questions or concerns, please feel
free to let me know. It is my pleasure to be of assistance.
Best regards,
Charles Wang
Microsoft Online Community Support
=====================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||Hi guys
Thank you both for your replies.
Having installed SQL MS and used it on my main server, I thought I'd go for
that as I know that quite well. So I actually downloaded and installed SQL
Server Management Studio Express.
This installed ok, saw the .\SQLEXPRESS instance, and allows me to connect
to it.
However, the database my website uses is not listed under DATABASES. :(
Any ideas why that might be, and how to make it appear?!
Thanks
Dan
"Charles Wang[MSFT]" wrote:
> Hi Dan,
> From your description, I understand that you would like to know if it is
> possible to backup/export your database in Visual Studio.
> If I have misunderstood, please let me know.
> In Visual Studio 2005, it does not provide GUI feature for database backup
> and restore, however you can create a T-SQL backup statement and execute it
> in it. You may refer to the following steps:
> 1. Click View menu, select "Server Explorer", right click "Data
> Connections", click "Add Connection...", and select your database server
> and database;
> 2. Click Data menu, select "New Query", and directly click Close button in
> the "Add Table" window;
> 3. Input "BACKUP DATABASE <database name> TO DISK='<backup path>'" to the
> SQL window and execute it.
> Also, you can use the utility osql.exe/sqlcmd.exe from command line to
> backup your database. For example:
> [osql utility - included in MDAC installed with Windows OS ]
> osql -S <server name>\<instance name> -E
> 1> BACKUP DATABASE <database name> TO DISK='backup path'
> 2> Go
> 1> quit
> [sqlcmd utility - included in SQL Native Client]
> sqlcmd -S <server name>\<instance name> -E
> 1> BACKUP DATABASE <database name> TO DISK='backup path'
> 2> Go
> 1> quit
> Hope this helps. If you have any other questions or concerns, please feel
> free to let me know. It is my pleasure to be of assistance.
> Best regards,
> Charles Wang
> Microsoft Online Community Support
> =====================================================> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from this issue.
> ======================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
> ======================================================>|||Hello,
Is your database that your website uses located on your local hard drives or
is it located on another server?
If it's on your local hard drive, then you need to find that database's mdf
file and attach it to your current running SQL Server instance to manage it
using SSMSE.
If it's located on a remote server then you need to know its IP and add it
as an Alias using SQL Server Configuration Manager. So, you'd be able to
connect to that instance (so your database) using your SSMSE and using that
Alias.
--
Ekrem Ã?nsoy
"musosdev" <musoswire@.community.nospam> wrote in message
news:6D0F8324-F122-4644-93A7-7FF819D57D02@.microsoft.com...
> Hi guys
> Thank you both for your replies.
> Having installed SQL MS and used it on my main server, I thought I'd go
> for
> that as I know that quite well. So I actually downloaded and installed SQL
> Server Management Studio Express.
> This installed ok, saw the .\SQLEXPRESS instance, and allows me to connect
> to it.
> However, the database my website uses is not listed under DATABASES. :(
> Any ideas why that might be, and how to make it appear?!
> Thanks
>
> Dan
>
> "Charles Wang[MSFT]" wrote:
>> Hi Dan,
>> From your description, I understand that you would like to know if it is
>> possible to backup/export your database in Visual Studio.
>> If I have misunderstood, please let me know.
>> In Visual Studio 2005, it does not provide GUI feature for database
>> backup
>> and restore, however you can create a T-SQL backup statement and execute
>> it
>> in it. You may refer to the following steps:
>> 1. Click View menu, select "Server Explorer", right click "Data
>> Connections", click "Add Connection...", and select your database server
>> and database;
>> 2. Click Data menu, select "New Query", and directly click Close button
>> in
>> the "Add Table" window;
>> 3. Input "BACKUP DATABASE <database name> TO DISK='<backup path>'" to the
>> SQL window and execute it.
>> Also, you can use the utility osql.exe/sqlcmd.exe from command line to
>> backup your database. For example:
>> [osql utility - included in MDAC installed with Windows OS ]
>> osql -S <server name>\<instance name> -E
>> 1> BACKUP DATABASE <database name> TO DISK='backup path'
>> 2> Go
>> 1> quit
>> [sqlcmd utility - included in SQL Native Client]
>> sqlcmd -S <server name>\<instance name> -E
>> 1> BACKUP DATABASE <database name> TO DISK='backup path'
>> 2> Go
>> 1> quit
>> Hope this helps. If you have any other questions or concerns, please feel
>> free to let me know. It is my pleasure to be of assistance.
>> Best regards,
>> Charles Wang
>> Microsoft Online Community Support
>> =====================================================>> When responding to posts, please "Reply to Group" via
>> your newsreader so that others may learn and benefit
>> from this issue.
>> ======================================================>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> ======================================================>>|||Hi Dan,
I am not an expert regarding ASP.NET, however from my research, your web
application is using SQL Server 2005 Express Edition User Instances:
SQL Server 2005 Express Edition User Instances
http://msdn2.microsoft.com/en-us/library/bb264564.aspx
I performed a simple test at my side. You can easily create a database in a
web application under the App_Data folder. You can easily manage it in
Visual Studio. When you double click the .mdf file, the database will be
displayed under the Data Connections in Server Explorer.
The database created in user instance will not be displayed in SSMS by
default, however you can refer to the section "Connecting to User Instances
from Other Clients" in the above article or the following article for
connecting to the user instance in SSMSE:
How to: Connect to a User Instance
http://msdn2.microsoft.com/en-us/library/aa337276.aspx
I looked through your original post carefully and I thought that your real
concern was that you would like to move your database to another webhost
together with your web application. However what is the matter if you
directly copy all the database files together with your website? or you can
use "Copy Website" or "Publish Website" to your remote server in Visual
Studio 2005? Make sure that you have detached the database in Visual Studio
2005 before you perform the progress.
If you have any other questions or concerns, please feel free to let me
know. Have a nice day!
Best regards,
Charles Wang
Microsoft Online Community Support
=====================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================
Exporting SQL db from Visual Studio?
Hi
I have a Visual Studio website with an mdf file in the App_Data folder. I'm
trying to move my site to my webhost, and I think the only way it will work
is for me to "backup" the database to .bak files, and then import it.
Is it possible to backup/export the database in VS, or do I need to install
SQL Management Studio and connect to the instance running inside VS?
Thanks,
DanYour databases are not running under VS. SQL Server Express Edition or
Developer Edition (if your VS is Pro Ed.) would be installed when you
install VS 2005. So your databases are already being stored in a SQL Server
instance.
You can easily manage your databases using SQL Server Management Studio.
Ekrem ?nsoy
"musosdev" <musoswire@.community.nospam> wrote in message
news:EFC0CEB9-E133-44C3-A927-99F2B1A95215@.microsoft.com...
> Hi
> I have a Visual Studio website with an mdf file in the App_Data folder.
> I'm
> trying to move my site to my webhost, and I think the only way it will
> work
> is for me to "backup" the database to .bak files, and then import it.
> Is it possible to backup/export the database in VS, or do I need to
> install
> SQL Management Studio and connect to the instance running inside VS?
> Thanks,
>
> Dan|||Hi Dan,
From your description, I understand that you would like to know if it is
possible to backup/export your database in Visual Studio.
If I have misunderstood, please let me know.
In Visual Studio 2005, it does not provide GUI feature for database backup
and restore, however you can create a T-SQL backup statement and execute it
in it. You may refer to the following steps:
1. Click View menu, select "Server Explorer", right click "Data
Connections", click "Add Connection...", and select your database server
and database;
2. Click Data menu, select "New Query", and directly click Close button in
the "Add Table" window;
3. Input "BACKUP DATABASE <database name> TO DISK='<backup path>'" to the
SQL window and execute it.
Also, you can use the utility osql.exe/sqlcmd.exe from command line to
backup your database. For example:
[osql utility - included in MDAC installed with Windows OS ]
osql -S <server name>\<instance name> -E
1> BACKUP DATABASE <database name> TO DISK='backup path'
2> Go
1> quit
[sqlcmd utility - included in SQL Native Client]
sqlcmd -S <server name>\<instance name> -E
1> BACKUP DATABASE <database name> TO DISK='backup path'
2> Go
1> quit
Hope this helps. If you have any other questions or concerns, please feel
free to let me know. It is my pleasure to be of assistance.
Best regards,
Charles Wang
Microsoft Online Community Support
========================================
=============
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
========================================
==============
This posting is provided "AS IS" with no warranties, and confers no rights.
========================================
==============|||Hi guys
Thank you both for your replies.
Having installed SQL MS and used it on my main server, I thought I'd go for
that as I know that quite well. So I actually downloaded and installed SQL
Server Management Studio Express.
This installed ok, saw the .\SQLEXPRESS instance, and allows me to connect
to it.
However, the database my website uses is not listed under DATABASES.
Any ideas why that might be, and how to make it appear?!
Thanks
Dan
"Charles Wang[MSFT]" wrote:
> Hi Dan,
> From your description, I understand that you would like to know if it is
> possible to backup/export your database in Visual Studio.
> If I have misunderstood, please let me know.
> In Visual Studio 2005, it does not provide GUI feature for database backup
> and restore, however you can create a T-SQL backup statement and execute i
t
> in it. You may refer to the following steps:
> 1. Click View menu, select "Server Explorer", right click "Data
> Connections", click "Add Connection...", and select your database server
> and database;
> 2. Click Data menu, select "New Query", and directly click Close button in
> the "Add Table" window;
> 3. Input "BACKUP DATABASE <database name> TO DISK='<backup path>'" to the
> SQL window and execute it.
> Also, you can use the utility osql.exe/sqlcmd.exe from command line to
> backup your database. For example:
> [osql utility - included in MDAC installed with Windows OS ]
> osql -S <server name>\<instance name> -E
> 1> BACKUP DATABASE <database name> TO DISK='backup path'
> 2> Go
> 1> quit
> [sqlcmd utility - included in SQL Native Client]
> sqlcmd -S <server name>\<instance name> -E
> 1> BACKUP DATABASE <database name> TO DISK='backup path'
> 2> Go
> 1> quit
> Hope this helps. If you have any other questions or concerns, please feel
> free to let me know. It is my pleasure to be of assistance.
> Best regards,
> Charles Wang
> Microsoft Online Community Support
> ========================================
=============
> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from this issue.
> ========================================
==============
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> ========================================
==============
>|||Hello,
Is your database that your website uses located on your local hard drives or
is it located on another server?
If it's on your local hard drive, then you need to find that database's mdf
file and attach it to your current running SQL Server instance to manage it
using SSMSE.
If it's located on a remote server then you need to know its IP and add it
as an Alias using SQL Server Configuration Manager. So, you'd be able to
connect to that instance (so your database) using your SSMSE and using that
Alias.
Ekrem ?nsoy
"musosdev" <musoswire@.community.nospam> wrote in message
news:6D0F8324-F122-4644-93A7-7FF819D57D02@.microsoft.com...[vbcol=seagreen]
> Hi guys
> Thank you both for your replies.
> Having installed SQL MS and used it on my main server, I thought I'd go
> for
> that as I know that quite well. So I actually downloaded and installed SQL
> Server Management Studio Express.
> This installed ok, saw the .\SQLEXPRESS instance, and allows me to connect
> to it.
> However, the database my website uses is not listed under DATABASES.
> Any ideas why that might be, and how to make it appear?!
> Thanks
>
> Dan
>
> "Charles Wang[MSFT]" wrote:
>|||Hi Dan,
I am not an expert regarding ASP.NET, however from my research, your web
application is using SQL Server 2005 Express Edition User Instances:
SQL Server 2005 Express Edition User Instances
http://msdn2.microsoft.com/en-us/library/bb264564.aspx
I performed a simple test at my side. You can easily create a database in a
web application under the App_Data folder. You can easily manage it in
Visual Studio. When you double click the .mdf file, the database will be
displayed under the Data Connections in Server Explorer.
The database created in user instance will not be displayed in SSMS by
default, however you can refer to the section "Connecting to User Instances
from Other Clients" in the above article or the following article for
connecting to the user instance in SSMSE:
How to: Connect to a User Instance
http://msdn2.microsoft.com/en-us/library/aa337276.aspx
I looked through your original post carefully and I thought that your real
concern was that you would like to move your database to another webhost
together with your web application. However what is the matter if you
directly copy all the database files together with your website? or you can
use "Copy Website" or "Publish Website" to your remote server in Visual
Studio 2005? Make sure that you have detached the database in Visual Studio
2005 before you perform the progress.
If you have any other questions or concerns, please feel free to let me
know. Have a nice day!
Best regards,
Charles Wang
Microsoft Online Community Support
========================================
=============
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
========================================
==============
This posting is provided "AS IS" with no warranties, and confers no rights.
========================================
==============
I have a Visual Studio website with an mdf file in the App_Data folder. I'm
trying to move my site to my webhost, and I think the only way it will work
is for me to "backup" the database to .bak files, and then import it.
Is it possible to backup/export the database in VS, or do I need to install
SQL Management Studio and connect to the instance running inside VS?
Thanks,
DanYour databases are not running under VS. SQL Server Express Edition or
Developer Edition (if your VS is Pro Ed.) would be installed when you
install VS 2005. So your databases are already being stored in a SQL Server
instance.
You can easily manage your databases using SQL Server Management Studio.
Ekrem ?nsoy
"musosdev" <musoswire@.community.nospam> wrote in message
news:EFC0CEB9-E133-44C3-A927-99F2B1A95215@.microsoft.com...
> Hi
> I have a Visual Studio website with an mdf file in the App_Data folder.
> I'm
> trying to move my site to my webhost, and I think the only way it will
> work
> is for me to "backup" the database to .bak files, and then import it.
> Is it possible to backup/export the database in VS, or do I need to
> install
> SQL Management Studio and connect to the instance running inside VS?
> Thanks,
>
> Dan|||Hi Dan,
From your description, I understand that you would like to know if it is
possible to backup/export your database in Visual Studio.
If I have misunderstood, please let me know.
In Visual Studio 2005, it does not provide GUI feature for database backup
and restore, however you can create a T-SQL backup statement and execute it
in it. You may refer to the following steps:
1. Click View menu, select "Server Explorer", right click "Data
Connections", click "Add Connection...", and select your database server
and database;
2. Click Data menu, select "New Query", and directly click Close button in
the "Add Table" window;
3. Input "BACKUP DATABASE <database name> TO DISK='<backup path>'" to the
SQL window and execute it.
Also, you can use the utility osql.exe/sqlcmd.exe from command line to
backup your database. For example:
[osql utility - included in MDAC installed with Windows OS ]
osql -S <server name>\<instance name> -E
1> BACKUP DATABASE <database name> TO DISK='backup path'
2> Go
1> quit
[sqlcmd utility - included in SQL Native Client]
sqlcmd -S <server name>\<instance name> -E
1> BACKUP DATABASE <database name> TO DISK='backup path'
2> Go
1> quit
Hope this helps. If you have any other questions or concerns, please feel
free to let me know. It is my pleasure to be of assistance.
Best regards,
Charles Wang
Microsoft Online Community Support
========================================
=============
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
========================================
==============
This posting is provided "AS IS" with no warranties, and confers no rights.
========================================
==============|||Hi guys
Thank you both for your replies.
Having installed SQL MS and used it on my main server, I thought I'd go for
that as I know that quite well. So I actually downloaded and installed SQL
Server Management Studio Express.
This installed ok, saw the .\SQLEXPRESS instance, and allows me to connect
to it.
However, the database my website uses is not listed under DATABASES.
Any ideas why that might be, and how to make it appear?!
Thanks
Dan
"Charles Wang[MSFT]" wrote:
> Hi Dan,
> From your description, I understand that you would like to know if it is
> possible to backup/export your database in Visual Studio.
> If I have misunderstood, please let me know.
> In Visual Studio 2005, it does not provide GUI feature for database backup
> and restore, however you can create a T-SQL backup statement and execute i
t
> in it. You may refer to the following steps:
> 1. Click View menu, select "Server Explorer", right click "Data
> Connections", click "Add Connection...", and select your database server
> and database;
> 2. Click Data menu, select "New Query", and directly click Close button in
> the "Add Table" window;
> 3. Input "BACKUP DATABASE <database name> TO DISK='<backup path>'" to the
> SQL window and execute it.
> Also, you can use the utility osql.exe/sqlcmd.exe from command line to
> backup your database. For example:
> [osql utility - included in MDAC installed with Windows OS ]
> osql -S <server name>\<instance name> -E
> 1> BACKUP DATABASE <database name> TO DISK='backup path'
> 2> Go
> 1> quit
> [sqlcmd utility - included in SQL Native Client]
> sqlcmd -S <server name>\<instance name> -E
> 1> BACKUP DATABASE <database name> TO DISK='backup path'
> 2> Go
> 1> quit
> Hope this helps. If you have any other questions or concerns, please feel
> free to let me know. It is my pleasure to be of assistance.
> Best regards,
> Charles Wang
> Microsoft Online Community Support
> ========================================
=============
> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from this issue.
> ========================================
==============
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> ========================================
==============
>|||Hello,
Is your database that your website uses located on your local hard drives or
is it located on another server?
If it's on your local hard drive, then you need to find that database's mdf
file and attach it to your current running SQL Server instance to manage it
using SSMSE.
If it's located on a remote server then you need to know its IP and add it
as an Alias using SQL Server Configuration Manager. So, you'd be able to
connect to that instance (so your database) using your SSMSE and using that
Alias.
Ekrem ?nsoy
"musosdev" <musoswire@.community.nospam> wrote in message
news:6D0F8324-F122-4644-93A7-7FF819D57D02@.microsoft.com...[vbcol=seagreen]
> Hi guys
> Thank you both for your replies.
> Having installed SQL MS and used it on my main server, I thought I'd go
> for
> that as I know that quite well. So I actually downloaded and installed SQL
> Server Management Studio Express.
> This installed ok, saw the .\SQLEXPRESS instance, and allows me to connect
> to it.
> However, the database my website uses is not listed under DATABASES.
> Any ideas why that might be, and how to make it appear?!
> Thanks
>
> Dan
>
> "Charles Wang[MSFT]" wrote:
>|||Hi Dan,
I am not an expert regarding ASP.NET, however from my research, your web
application is using SQL Server 2005 Express Edition User Instances:
SQL Server 2005 Express Edition User Instances
http://msdn2.microsoft.com/en-us/library/bb264564.aspx
I performed a simple test at my side. You can easily create a database in a
web application under the App_Data folder. You can easily manage it in
Visual Studio. When you double click the .mdf file, the database will be
displayed under the Data Connections in Server Explorer.
The database created in user instance will not be displayed in SSMS by
default, however you can refer to the section "Connecting to User Instances
from Other Clients" in the above article or the following article for
connecting to the user instance in SSMSE:
How to: Connect to a User Instance
http://msdn2.microsoft.com/en-us/library/aa337276.aspx
I looked through your original post carefully and I thought that your real
concern was that you would like to move your database to another webhost
together with your web application. However what is the matter if you
directly copy all the database files together with your website? or you can
use "Copy Website" or "Publish Website" to your remote server in Visual
Studio 2005? Make sure that you have detached the database in Visual Studio
2005 before you perform the progress.
If you have any other questions or concerns, please feel free to let me
know. Have a nice day!
Best regards,
Charles Wang
Microsoft Online Community Support
========================================
=============
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
========================================
==============
This posting is provided "AS IS" with no warranties, and confers no rights.
========================================
==============
Subscribe to:
Posts (Atom)