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...
the
>|||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...
> the
Restore?
and
>|||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...
db),
> Restore?
> and
>