Problem transferring data and objects

#1

I will preface this by saying I am a beginner. I want to export the contents
of a local database to a remote server. On the remote server I create an
empty database of the same name and then try and import the data and objects.
I keep getting an error "Der benutzername 'preisr_admin' ist nicht
vorhanden' which means something like 'The username 'preis_admin' does not
exist'. Any ideas as to what the problem might be and how I can solve it?

I have also tried making a dump (backup?) of the database into a .dmp file
and importing the file. It works but does not import any of my objects such
as tables and stored procedures (only the default system objects). I have
tried all the dump options but nothing seems to allow me to include objects
in my dump. Any ideas?

Are there any other reliable ways of importing a database from one server to
another?

Thanks in advance.

#2

OK I solved the DTS problem while re-reading my post. Is there any way of
importing users as well? I am still interesting in finding answers to my
other questions. thanks

"rufus" wrote:

Quote:

I will preface this by saying I am a beginner. I want to export the contents
of a local database to a remote server. On the remote server I create an
empty database of the same name and then try and import the data and objects.
I keep getting an error "Der benutzername 'preisr_admin' ist nicht
vorhanden' which means something like 'The username 'preis_admin' does not
exist'. Any ideas as to what the problem might be and how I can solve it?

I have also tried making a dump (backup?) of the database into a .dmp file
and importing the file. It works but does not import any of my objects such
as tables and stored procedures (only the default system objects). I have
tried all the dump options but nothing seems to allow me to include objects
in my dump. Any ideas?

Are there any other reliable ways of importing a database from one server to
another?

Thanks in advance.

#3

Warum benutzen Sie nicht BACKUP/RESTORE? Es ist mehr einfach und fehlerfrei.

Why are you not using BACKUP and RESTORE. It is asimple and error free.

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com

"rufus" <rufus (AT) discussions (DOT) microsoft.com> wrote

Quote:

I will preface this by saying I am a beginner. I want to export the contents
of a local database to a remote server. On the remote server I create an
empty database of the same name and then try and import the data and objects.
I keep getting an error "Der benutzername 'preisr_admin' ist nicht
vorhanden' which means something like 'The username 'preis_admin' does not
exist'. Any ideas as to what the problem might be and how I can solve it?

I have also tried making a dump (backup?) of the database into a .dmp file
and importing the file. It works but does not import any of my objects such
as tables and stored procedures (only the default system objects). I have
tried all the dump options but nothing seems to allow me to include objects
in my dump. Any ideas?

Are there any other reliable ways of importing a database from one server to
another?

Thanks in advance.

#4

Wie heiÃŸt 'BACKUP AND RESTORE' auf deutsch?

Es is sehr schwer in einer andere Sprache zu arbeiten

"Allan Mitchell" wrote:

Quote:

Warum benutzen Sie nicht BACKUP/RESTORE? Es ist mehr einfach und fehlerfrei.

Why are you not using BACKUP and RESTORE. It is asimple and error free.

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com

"rufus" <rufus (AT) discussions (DOT) microsoft.com> wrote

I will preface this by saying I am a beginner. I want to export the contents
of a local database to a remote server. On the remote server I create an
empty database of the same name and then try and import the data and objects.
I keep getting an error "Der benutzername 'preisr_admin' ist nicht
vorhanden' which means something like 'The username 'preis_admin' does not
exist'. Any ideas as to what the problem might be and how I can solve it?

I have also tried making a dump (backup?) of the database into a .dmp file
and importing the file. It works but does not import any of my objects such
as tables and stored procedures (only the default system objects). I have
tried all the dump options but nothing seems to allow me to include objects
in my dump. Any ideas?

Are there any other reliable ways of importing a database from one server to
another?

Thanks in advance.

#5

Ich weiss.

BACKUP heisst - Sicherungskopie/speichern

z.b.

BACKUP DATABASE <Datenbank Name> TO DISK = '<speicherstelle>'

RESTORE heisst - umspeichern

z.b.

RESTORE DATABASE <Datenbank Name> FROM DISK = '<speicherstelle>'

Sie sollen in BOL gucken

mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\tsqlref.chm::/ts_ba-bz_35ww.htm

und

mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\tsqlref.chm::/ts_ra-rz_25rm.htm

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com

"rufus" <rufus (AT) discussions (DOT) microsoft.com> wrote

Quote:

Wie heißt 'BACKUP AND RESTORE' auf deutsch?

Es is sehr schwer in einer andere Sprache zu arbeiten

"Allan Mitchell" wrote:

Warum benutzen Sie nicht BACKUP/RESTORE? Es ist mehr einfach und fehlerfrei.

Why are you not using BACKUP and RESTORE. It is asimple and error free.

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com

"rufus" <rufus (AT) discussions (DOT) microsoft.com> wrote

I will preface this by saying I am a beginner. I want to export the contents
of a local database to a remote server. On the remote server I create an
empty database of the same name and then try and import the data and objects.
I keep getting an error "Der benutzername 'preisr_admin' ist nicht
vorhanden' which means something like 'The username 'preis_admin' does not
exist'. Any ideas as to what the problem might be and how I can solve it?

I have also tried making a dump (backup?) of the database into a .dmp file
and importing the file. It works but does not import any of my objects such
as tables and stored procedures (only the default system objects). I have
tried all the dump options but nothing seems to allow me to include objects
in my dump. Any ideas?

Are there any other reliable ways of importing a database from one server to
another?

Thanks in advance.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Problem transferring data and objects

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Problem transferring data and objects - 04-22-2005 , 01:53 PM

RE: Problem transferring data and objects - 04-22-2005 , 02:03 PM

Re: Problem transferring data and objects - 04-22-2005 , 02:19 PM

Re: Problem transferring data and objects - 04-22-2005 , 05:41 PM

Re: Problem transferring data and objects - 04-23-2005 , 12:10 AM