Keeping PK and identity when moving db from one server to another

We have a database at an external hosting provider.
I would like to move the database to another provider,
If I use the Import or Export tools in Enterprise Manager (db -> db), the
PK's and Indentities are not set on the new server....
...is there somehow I can move the database including the PK's and
Identities...?
Does it have to be through: Backup -> Manually file transfer -> Restore?
There are ca. 50 tables in that database, and restoring all the keys and
identities is full time job.
Thanx!
Regards,
Taras DKTaras
What's a problem with BACKUP and then RESTORE commands?
"Taras Tim Bredel" <ttb@.jtj.dk> wrote in message
news:uIpt7YJ8DHA.2472@.TK2MSFTNGP10.phx.gbl...
> We have a database at an external hosting provider.
> I would like to move the database to another provider,
> If I use the Import or Export tools in Enterprise Manager (db -> db), the
> PK's and Indentities are not set on the new server....
> ...is there somehow I can move the database including the PK's and
> Identities...?
> Does it have to be through: Backup -> Manually file transfer -> Restore?
>
> There are ca. 50 tables in that database, and restoring all the keys and
> identities is full time job.
> Thanx!
> Regards,
> Taras DK
>|||Hi Uri
Well nothing actually.
Though I do not have access to the local file system on either of the
servers.
Therefor it would decrease the down time, if I could perform this task
without involving several dba's at each hosting facility.
So I should take that as a no!
Thanx!
Taras
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23P7EKcJ8DHA.696@.tk2msftngp13.phx.gbl...
> Taras
> What's a problem with BACKUP and then RESTORE commands?
> "Taras Tim Bredel" <ttb@.jtj.dk> wrote in message
> news:uIpt7YJ8DHA.2472@.TK2MSFTNGP10.phx.gbl...
> > We have a database at an external hosting provider.
> > I would like to move the database to another provider,
> >
> > If I use the Import or Export tools in Enterprise Manager (db -> db),
the
> > PK's and Indentities are not set on the new server....
> >
> > ...is there somehow I can move the database including the PK's and
> > Identities...?
> > Does it have to be through: Backup -> Manually file transfer -> Restore?
> >
> >
> > There are ca. 50 tables in that database, and restoring all the keys and
> > identities is full time job.
> >
> > Thanx!
> >
> > Regards,
> >
> > Taras DK
> >
> >
>|||Taras
Take a look at DTS object that called Copy SQL Server Objects Task.
You will be able transfer PK, indexes....
"Taras Tim Bredel" <ttb@.jtj.dk> wrote in message
news:uDfvRjJ8DHA.2796@.TK2MSFTNGP09.phx.gbl...
> Hi Uri
> Well nothing actually.
> Though I do not have access to the local file system on either of the
> servers.
> Therefor it would decrease the down time, if I could perform this task
> without involving several dba's at each hosting facility.
> So I should take that as a no!
> Thanx!
> Taras
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%23P7EKcJ8DHA.696@.tk2msftngp13.phx.gbl...
> > Taras
> > What's a problem with BACKUP and then RESTORE commands?
> > "Taras Tim Bredel" <ttb@.jtj.dk> wrote in message
> > news:uIpt7YJ8DHA.2472@.TK2MSFTNGP10.phx.gbl...
> > > We have a database at an external hosting provider.
> > > I would like to move the database to another provider,
> > >
> > > If I use the Import or Export tools in Enterprise Manager (db -> db),
> the
> > > PK's and Indentities are not set on the new server....
> > >
> > > ...is there somehow I can move the database including the PK's and
> > > Identities...?
> > > Does it have to be through: Backup -> Manually file transfer ->
Restore?
> > >
> > >
> > > There are ca. 50 tables in that database, and restoring all the keys
and
> > > identities is full time job.
> > >
> > > Thanx!
> > >
> > > Regards,
> > >
> > > Taras DK
> > >
> > >
> >
> >
>|||Hi Uri
Perfect... I't works (almost) like a charm.
Except it only copies the tables and objects owned by dbo, and not the ones
owned by the db_owner ?
Could you please elaborate ?
Thanx!
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%236KX8lJ8DHA.3052@.TK2MSFTNGP09.phx.gbl...
> Taras
> Take a look at DTS object that called Copy SQL Server Objects Task.
> You will be able transfer PK, indexes....
>
> "Taras Tim Bredel" <ttb@.jtj.dk> wrote in message
> news:uDfvRjJ8DHA.2796@.TK2MSFTNGP09.phx.gbl...
> > Hi Uri
> >
> > Well nothing actually.
> > Though I do not have access to the local file system on either of the
> > servers.
> > Therefor it would decrease the down time, if I could perform this task
> > without involving several dba's at each hosting facility.
> >
> > So I should take that as a no!
> >
> > Thanx!
> >
> > Taras
> >
> > "Uri Dimant" <urid@.iscar.co.il> wrote in message
> > news:%23P7EKcJ8DHA.696@.tk2msftngp13.phx.gbl...
> > > Taras
> > > What's a problem with BACKUP and then RESTORE commands?
> > > "Taras Tim Bredel" <ttb@.jtj.dk> wrote in message
> > > news:uIpt7YJ8DHA.2472@.TK2MSFTNGP10.phx.gbl...
> > > > We have a database at an external hosting provider.
> > > > I would like to move the database to another provider,
> > > >
> > > > If I use the Import or Export tools in Enterprise Manager (db ->
db),
> > the
> > > > PK's and Indentities are not set on the new server....
> > > >
> > > > ...is there somehow I can move the database including the PK's and
> > > > Identities...?
> > > > Does it have to be through: Backup -> Manually file transfer ->
> Restore?
> > > >
> > > >
> > > > There are ca. 50 tables in that database, and restoring all the keys
> and
> > > > identities is full time job.
> > > >
> > > > Thanx!
> > > >
> > > > Regards,
> > > >
> > > > Taras DK
> > > >
> > > >
> > >
> > >
> >
> >
>