Importing DB from Another Install

I have a MS SQL database generated from another user and
sent to me via email. I am trying to import it into my
install of SQL Server 2000. The two approaches I have
tried have not worked, but maybe I am missing a trick.
1) Set up tables with the query analyzer and use the
import wizard under All Tasks >> Import. Even after
registering the datasource for import in ODBC Datasources
control panel, the db for import does not appear in the
list of datasources for import with this wizard.
2) Create a new blank database and copy the datafile for
import to the directory indicated as the location of the
blank database datafile. When I do this the database is
greyed out in Enterprise Manager and marked 'suspect'. No
tables are viewable under the database after copying.
I've also tried this approach after setting up the table
structure with the Query Analyzer.Jennifer,
Short answer: search the SQL Server 2000 Books Online for the section
"Attaching and Detaching a Database"
Longer answer ... and assuming that you have Enterprise Manager and that
your user has sent you **both** the data (.mdf) and log (.ldf) files:
In EM: right-click the "Databases" folder: All Tasks | Attach Database
Chief Tenaya
"Jennifer Sanders" <anonymous@.discussions.microsoft.com> wrote in message
news:e7d601c41022$fe75ec10$a601280a@.phx.gbl...
> I have a MS SQL database generated from another user and
> sent to me via email. I am trying to import it into my
> install of SQL Server 2000. The two approaches I have
> tried have not worked, but maybe I am missing a trick.
> 1) Set up tables with the query analyzer and use the
> import wizard under All Tasks >> Import. Even after
> registering the datasource for import in ODBC Datasources
> control panel, the db for import does not appear in the
> list of datasources for import with this wizard.
> 2) Create a new blank database and copy the datafile for
> import to the directory indicated as the location of the
> blank database datafile. When I do this the database is
> greyed out in Enterprise Manager and marked 'suspect'. No
> tables are viewable under the database after copying.
> I've also tried this approach after setting up the table
> structure with the Query Analyzer.|||I found out it's a backup file.
>--Original Message--
>Jennifer,
>Short answer: search the SQL Server 2000 Books Online for
the section
>"Attaching and Detaching a Database"
>Longer answer ... and assuming that you have Enterprise
Manager and that
>your user has sent you **both** the data (.mdf) and log
(.ldf) files:
>In EM: right-click the "Databases" folder: All Tasks |
Attach Database
>Chief Tenaya
>
>"Jennifer Sanders" <anonymous@.discussions.microsoft.com>
wrote in message
>news:e7d601c41022$fe75ec10$a601280a@.phx.gbl...
Datasources
No
>
>.
>

Importing DATA wich are in SQL files

Hi
I have to install a lot of data wiich are initialized by an SQL file.
My problem is that the file is too big. My SQL requests exceeds 64Ko and
I cant start theses request in the SQL Editor of MS SQLSERVER 2K :-(
I would like import this file like in MySQL or Oracle, with a command
prompt or any tool.
How can I import this SQL File in SQLSERVER 2000 ?
Thanks in advance for your help.
Alexandre TouretAlexandre,
Did you try using OSQL utility?
AMB
"Alexandre Touret" wrote:

> Hi
> I have to install a lot of data wiich are initialized by an SQL file.
> My problem is that the file is too big. My SQL requests exceeds 64Ko and
> I cant start theses request in the SQL Editor of MS SQLSERVER 2K :-(
> I would like import this file like in MySQL or Oracle, with a command
> prompt or any tool.
> How can I import this SQL File in SQLSERVER 2000 ?
> Thanks in advance for your help.
> Alexandre Touret
>|||Hi
It there are SQL statements in a .SQL file, run them from the command line
by using the command line utility isql.exe
BOL has the syntax information for ISQL.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Alexandre Touret" <atouretNOSPAM@.free.fr> wrote in message
news:423aa143$0$29121$626a14ce@.news.free.fr...
> Hi
> I have to install a lot of data wiich are initialized by an SQL file.
> My problem is that the file is too big. My SQL requests exceeds 64Ko and
> I cant start theses request in the SQL Editor of MS SQLSERVER 2K :-(
> I would like import this file like in MySQL or Oracle, with a command
> prompt or any tool.
> How can I import this SQL File in SQLSERVER 2000 ?
> Thanks in advance for your help.
> Alexandre Touret

Importing Access Tables?

Hi,
I have a database in Access 2003. I plan to migrate to SQL Server. Right
now, I have install SQL Server 2005 Express Edition. I have create a new
Database under SQL Server 2005 but stuck in the place because I don't know
how to import existing Access tables to the newly create Database.
Does anyone know how to do this?
SF
Hello,
You could use SQL Server Integration services (SSIS) to copy the tables from
Access to SQL Server
Thanks
Hari
"SF" <ss@.yahoo.com> wrote in message
news:eFHNntKTHHA.4028@.TK2MSFTNGP04.phx.gbl...
> Hi,
> I have a database in Access 2003. I plan to migrate to SQL Server. Right
> now, I have install SQL Server 2005 Express Edition. I have create a new
> Database under SQL Server 2005 but stuck in the place because I don't know
> how to import existing Access tables to the newly create Database.
> Does anyone know how to do this?
> SF
>
|||Another option is to use the SQL Server Migration Assistant for Access (for
migrating databases from
Microsoft Access versions 97 through 2003 to Microsoft SQL Server 2005):
http://www.microsoft.com/sql/solutions/migration/access/default.mspx
HTH,
Plamen Ratchev
http://www.SQLStudio.com

Importing Access Tables?

Hi,
I have a database in Access 2003. I plan to migrate to SQL Server. Right
now, I have install SQL Server 2005 Express Edition. I have create a new
Database under SQL Server 2005 but stuck in the place because I don't know
how to import existing Access tables to the newly create Database.
Does anyone know how to do this?
SFHello,
You could use SQL Server Integration services (SSIS) to copy the tables from
Access to SQL Server
Thanks
Hari
"SF" <ss@.yahoo.com> wrote in message
news:eFHNntKTHHA.4028@.TK2MSFTNGP04.phx.gbl...
> Hi,
> I have a database in Access 2003. I plan to migrate to SQL Server. Right
> now, I have install SQL Server 2005 Express Edition. I have create a new
> Database under SQL Server 2005 but stuck in the place because I don't know
> how to import existing Access tables to the newly create Database.
> Does anyone know how to do this?
> SF
>|||Another option is to use the SQL Server Migration Assistant for Access (for
migrating databases from
Microsoft Access versions 97 through 2003 to Microsoft SQL Server 2005):
http://www.microsoft.com/sql/solutions/migration/access/default.mspx
HTH,
Plamen Ratchev
http://www.SQLStudio.com

Importing Access Tables?

Hi,
I have a database in Access 2003. I plan to migrate to SQL Server. Right
now, I have install SQL Server 2005 Express Edition. I have create a new
Database under SQL Server 2005 but stuck in the place because I don't know
how to import existing Access tables to the newly create Database.
Does anyone know how to do this?
SFHello,
You could use SQL Server Integration services (SSIS) to copy the tables from
Access to SQL Server
Thanks
Hari
"SF" <ss@.yahoo.com> wrote in message
news:eFHNntKTHHA.4028@.TK2MSFTNGP04.phx.gbl...
> Hi,
> I have a database in Access 2003. I plan to migrate to SQL Server. Right
> now, I have install SQL Server 2005 Express Edition. I have create a new
> Database under SQL Server 2005 but stuck in the place because I don't know
> how to import existing Access tables to the newly create Database.
> Does anyone know how to do this?
> SF
>|||Another option is to use the SQL Server Migration Assistant for Access (for
migrating databases from
Microsoft Access versions 97 through 2003 to Microsoft SQL Server 2005):
http://www.microsoft.com/sql/soluti...ss/default.mspx
HTH,
Plamen Ratchev
http://www.SQLStudio.com