importing MDF database

As a newbie, I'm having problems importing a copy of my SQLServer2k development database from my laptop (via a CD), to my production SQL Server2k database.

I've tried the DTS Import/Export wizard & also the Copy wizard, but can't seem to see the dialog that prompts & identifies the source path & filename.

I've tried setting up an ODBC DSN for the database, but get the same problem.

Coming from an Access background, I've been used to the copying of *.mdb files, and half expected that level of simplicity with SQLS2K - but clearly, I'm wrong and am missing something, which the on-line help isn't able to clarify for me...

Can anyone please give me any pointers for me to get a copy of my development database along with its stored procedures, from my laptop (not networked), to my desktop server. Both use SQLS2k.

Thanks in advance, AlexSo let me get this strait. You want to restore a copy of your database thats are on a CD?|||The easiest for you would be to either copy the MDF file along with LDF file onto a local drive of the server from the CD and use Enterprise Manager (EM) to Attach Database, or create a backup on your laptop and then restore from that backup file.|||Originally posted by rdjabarov
The easiest for you would be to either copy the MDF file along with LDF file onto a local drive of the server from the CD and use Enterprise Manager (EM) to Attach Database, or create a backup on your laptop and then restore from that backup file. ...and remember to mark the files Read/Write again! I've never been bitten by that, but I read about this guy that was once!

-PatP|||This link http://vyaskn.tripod.com/moving_sql_server.htm refers moving database from one system to another, just follow instead moving consider copying the files.

Also refer to the corresponding KBAs which refers to resolve any login issue arises.|||Thanks all very much for your prompt replies. Just as I was applying the suggested "Attach" method, the motherboard in my Dell server went kaput! So I won't be able to try it until the weekend - when I hope to report back success.

Interestingly the link provided in one of the responses, was very useful and included code to automate the attachment within a stored procedure (if necessary). I aim to try the menu-dropdown "manual" attachment first, & see how I get on with that.

All the best - & thanks again
Alex|||Thanks to all who replied & helped (especially Pat, Rdjabarov, & Satya).

I've just had the server's power supply replaced & tried your suggestions - the attach worked fine (from the Enterprise>Actions>AllTasks>Attach)

Best regards, & thanks again
Alexsql

Importing data files into new instance of SQL Server

Hi Everyone,
I've got an .MDF file (database) and an .LDF file (transaction log) that
were created using SQL Server 7.0. We've built a new windows server with
SQL Server 2000 installed and would like to import the files onto that
server. The problem is that we just have the files, the SQL Server 7.0
instance is gone. What is the simplest way to create a new database on the
SQL Server 2000 box with those files?
Thanks in Advance,
Jon
if the files were previously detached from the db using sp_detach_db
you can just attach them using sp_attach_db. SQL Server should
do the upgrading for you. Of course, you'll need to drop and re-add
any users and roles.
"Jon Westmore" <westmoj@.reidhosp.com> wrote in message
news:%23c8rSoq7EHA.936@.TK2MSFTNGP12.phx.gbl...
> Hi Everyone,
> I've got an .MDF file (database) and an .LDF file (transaction log) that
> were created using SQL Server 7.0. We've built a new windows server with
> SQL Server 2000 installed and would like to import the files onto that
> server. The problem is that we just have the files, the SQL Server 7.0
> instance is gone. What is the simplest way to create a new database on
the
> SQL Server 2000 box with those files?
> Thanks in Advance,
> Jon
>

Importing data files into new instance of SQL Server

Hi Everyone,
I've got an .MDF file (database) and an .LDF file (transaction log) that
were created using SQL Server 7.0. We've built a new windows server with
SQL Server 2000 installed and would like to import the files onto that
server. The problem is that we just have the files, the SQL Server 7.0
instance is gone. What is the simplest way to create a new database on the
SQL Server 2000 box with those files?
Thanks in Advance,
Jonif the files were previously detached from the db using sp_detach_db
you can just attach them using sp_attach_db. SQL Server should
do the upgrading for you. Of course, you'll need to drop and re-add
any users and roles.
"Jon Westmore" <westmoj@.reidhosp.com> wrote in message
news:%23c8rSoq7EHA.936@.TK2MSFTNGP12.phx.gbl...
> Hi Everyone,
> I've got an .MDF file (database) and an .LDF file (transaction log) that
> were created using SQL Server 7.0. We've built a new windows server with
> SQL Server 2000 installed and would like to import the files onto that
> server. The problem is that we just have the files, the SQL Server 7.0
> instance is gone. What is the simplest way to create a new database on
the
> SQL Server 2000 box with those files?
> Thanks in Advance,
> Jon
>

Importing data files into new instance of SQL Server

Hi Everyone,
I've got an .MDF file (database) and an .LDF file (transaction log) that
were created using SQL Server 7.0. We've built a new windows server with
SQL Server 2000 installed and would like to import the files onto that
server. The problem is that we just have the files, the SQL Server 7.0
instance is gone. What is the simplest way to create a new database on the
SQL Server 2000 box with those files?
Thanks in Advance,
Jonif the files were previously detached from the db using sp_detach_db
you can just attach them using sp_attach_db. SQL Server should
do the upgrading for you. Of course, you'll need to drop and re-add
any users and roles.
"Jon Westmore" <westmoj@.reidhosp.com> wrote in message
news:%23c8rSoq7EHA.936@.TK2MSFTNGP12.phx.gbl...
> Hi Everyone,
> I've got an .MDF file (database) and an .LDF file (transaction log) that
> were created using SQL Server 7.0. We've built a new windows server with
> SQL Server 2000 installed and would like to import the files onto that
> server. The problem is that we just have the files, the SQL Server 7.0
> instance is gone. What is the simplest way to create a new database on
the
> SQL Server 2000 box with those files?
> Thanks in Advance,
> Jon
>

Importing csv File into SqlExpress .MDF file.

Hi,
I'm trying to use BCP to import a .csv file into a .mdf file.
At the commandline, I'm using the following command:
bcp commercedb.mdf.crmc_products in test.csv -T
I'm getting errors (below) telling me that I'm not successfully
connecting to the database.
Any help would be appreciated. If you can help me, please understand
I'm new to this so limited g speak would be most appreciated.
ERRORS:
SQLState = 08001, NativeError = 53
Error = [Microsoft][SQL Native Client]Named Pipes Provider: Could not
open a con
nection to SQL Server [53].
SQLState = HYT00, NativeError = 0
Error = [Microsoft][SQL Native Client]Login timeout expired
SQLState = 08001, NativeError = 53
Error = [Microsoft][SQL Native Client]An error has occurred while
establishing a
connection to the server. When connecting to SQL Server 2005, this
failure may
be caused by the fact that under the default settings SQL Server does
not allow
remote connections.Data access libraries do not directly access (MDF) SQL Server database files
the same way they can an (MDB) MS Access file. All data access must go
through the SQL Server service itself.
The .mdf database file must first be attached to SQL Server.
http://msdn2.microsoft.com/en-us/library/ms165673.aspx
Once done, you bulk copy specifying the server and database name:
http://msdn2.microsoft.com/en-us/library/ms162802.aspx
<tom.herz@.gmail.com> wrote in message
news:1138982708.766097.92140@.f14g2000cwb.googlegroups.com...
> Hi,
> I'm trying to use BCP to import a .csv file into a .mdf file.
> At the commandline, I'm using the following command:
> bcp commercedb.mdf.crmc_products in test.csv -T
> I'm getting errors (below) telling me that I'm not successfully
> connecting to the database.
> Any help would be appreciated. If you can help me, please understand
> I'm new to this so limited g speak would be most appreciated.
> ERRORS:
> SQLState = 08001, NativeError = 53
> Error = [Microsoft][SQL Native Client]Named Pipes Provider: Could not
> open a con
> nection to SQL Server [53].
> SQLState = HYT00, NativeError = 0
> Error = [Microsoft][SQL Native Client]Login timeout expired
> SQLState = 08001, NativeError = 53
> Error = [Microsoft][SQL Native Client]An error has occurred while
> establishing a
> connection to the server. When connecting to SQL Server 2005, this
> failure may
> be caused by the fact that under the default settings SQL Server does
> not allow
> remote connections.
>|||Hi,
Thanks. This is what I needed. I hadn't attached the database.
I haven't been successful yet, but that is a lack of experience with
all the switches and BCP overall.
Once I got the database attached, things started to gel.
I really appreciate your time, JT.
Have a good day.