Solved

ASpnetdb.mdf to sql server 2000

Posted on 2008-10-24
6
434 Views
Last Modified: 2013-11-08
I have created a local aspnetdb.mdf with the asp.net configuration utility in visual studio 2008.

How do I get that database information over to my remote sql server 2000 database?

thanks.
0
Comment
Question by:Starr Duskk
  • 4
  • 2
6 Comments
 
LVL 19

Assisted Solution

by:elimesika
elimesika earned 500 total points
ID: 22808751
0
 
LVL 2

Author Comment

by:Starr Duskk
ID: 22808941
I am not attaching to a desktop engine. I am trying copy the entire mdf to my sql server 2000.
 
0
 
LVL 19

Expert Comment

by:elimesika
ID: 22808972
I know, and still this article shows you how to copy the mdf & log file and attach them to your sql 2000 database.
0
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
LVL 2

Author Comment

by:Starr Duskk
ID: 22809024
okay, I'll check it out this week. thanks.
 
0
 
LVL 2

Author Comment

by:Starr Duskk
ID: 22862548
Okay, I had a chance to go through it. None of that makes sense to me.
Isn't there a way to use the sql server Import and Export utility to import the mdf files?
 
0
 
LVL 2

Accepted Solution

by:
Starr Duskk earned 0 total points
ID: 22876035
0

Featured Post

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question