Showing posts with label stuff. Show all posts
Showing posts with label stuff. Show all posts

Tuesday, March 20, 2012

Copying MSDE database to disk - how?

I have my little MSDE on my computer. I can add and delete stuff from it through Web Matrix. My question is, where exactly is the database stored in Windows?? Also, say I wanted to copy it to a disk so I could show it to someone else, what file(s) would I need to copy?

The reason why I ask is because I have been doing a website as a project and we have to hand in all files on a disk. Getting all the .aspx & .ascx and the .config file is easy, but the database & stored procedures is proving tricky to find.

ThanksTry using this tool - http://www.webattack.com/get/dbamgr2.html its a MSDE Manager. Install it then connect to your server. right click the database you want to backup then select 'Backup Database' and bobs your uncle:)|||Actually you shold use that tool, right click your DB then click 'Generate SQL Script'. This will be easier to install on a remote server

Friday, February 17, 2012

Copy Table + data from database A to database B

Hi:
I'm really new to this DBA stuff and I need an explanation for what just hap
pened.
I just used the copy wizard to copy Table A from database A to database B.
All the data and the table structure were successfully created in database B
with one exception: the first column had
the IDENTITY (1,1) attribute set in database A. But after the copy to datab
ase B the IDENTITY attribute was missing!!!
Fortunately, I'm one of those inveterate "testers" so I discovered the probl
em before it made it into Production.
Eventually, I had to generate a script for the table to create that table in
database B with the IDENTITY in place and
then import the data.
Anyone have any idea what the problem is and how to solve it' I don't like
the idea of having to generate a script for
each table that I need to move and then import the data!!!! The copy wizar
d is a gem if it works as advertised!
Using SQL Server 7.0.
cathyThe copy table option only copies the data. If you want to copy all the
attributes you should use the Copy objects and data between SQL Server
databases.
The copy table option was designe to allow data transfers between
heterogenous data sources.
Rand
This posting is provided "as is" with no warranties and confers no rights.

Copy Table + data from database A to database B

Hi:
I'm really new to this DBA stuff and I need an explanation for what just happened.
I just used the copy wizard to copy Table A from database A to database B.
All the data and the table structure were successfully created in database B with one exception: the first column had
the IDENTITY (1,1) attribute set in database A. But after the copy to database B the IDENTITY attribute was missing!!!
Fortunately, I'm one of those inveterate "testers" so I discovered the problem before it made it into Production.
Eventually, I had to generate a script for the table to create that table in database B with the IDENTITY in place and
then import the data.
Anyone have any idea what the problem is and how to solve it' I don't like the idea of having to generate a script for
each table that I need to move and then import the data!!!! The copy wizard is a gem if it works as advertised!
Using SQL Server 7.0.
cathyThe copy table option only copies the data. If you want to copy all the
attributes you should use the Copy objects and data between SQL Server
databases.
The copy table option was designe to allow data transfers between
heterogenous data sources.
Rand
This posting is provided "as is" with no warranties and confers no rights.