Copy userdata

Hi,
how can I copy the userdata from one sqlserver to another sqlserver ?
Best regards
Axel LanserExactly what do you mean by "userdata"? Does the database exists? Does the tables exists? Do you
want to remove the rows in the destination tables if they exists? For all tables in a database? I
suggest you check out the DTS tool. This is probably the right tool for the job.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"ALN" <ALN@.discussions.microsoft.com> wrote in message
news:3039DE30-66B9-4058-8C94-76E0547B997A@.microsoft.com...
> Hi,
> how can I copy the userdata from one sqlserver to another sqlserver ?
> Best regards
> Axel Lanser|||You can use DTS if it's just the straight data that you care about and the
destination
server already has the schema defined. However, you may have to drop
any foreign keys on the destination server and then re-apply them after
the data has been loaded.
"ALN" <ALN@.discussions.microsoft.com> wrote in message
news:3039DE30-66B9-4058-8C94-76E0547B997A@.microsoft.com...
> Hi,
> how can I copy the userdata from one sqlserver to another sqlserver ?
> Best regards
> Axel Lanser|||Hi,
with dts I can copy only tables and views from a database. In the sql server
I define much sql server specific und windows specific users with their right.
That users and their rights I had defined in one SQL-server. My problem is
now how can I copy them to a 2nd SQL-server.
Best refards
Axel Lanser
"Armando Prato" wrote:
> You can use DTS if it's just the straight data that you care about and the
> destination
> server already has the schema defined. However, you may have to drop
> any foreign keys on the destination server and then re-apply them after
> the data has been loaded.
> "ALN" <ALN@.discussions.microsoft.com> wrote in message
> news:3039DE30-66B9-4058-8C94-76E0547B997A@.microsoft.com...
> > Hi,
> > how can I copy the userdata from one sqlserver to another sqlserver ?
> >
> > Best regards
> >
> > Axel Lanser
>
>|||You don't have to build tables. You can choose to append to existing
tables.
"ALN" <ALN@.discussions.microsoft.com> wrote in message
news:02C317FA-CD0E-451C-87D7-89CDCD9CEB3F@.microsoft.com...
> Hi,
> with dts I can copy only tables and views from a database. In the sql
server
> I define much sql server specific und windows specific users with their
right.
> That users and their rights I had defined in one SQL-server. My problem is
> now how can I copy them to a 2nd SQL-server.
> Best refards
> Axel Lanser
> "Armando Prato" wrote:
> >
> > You can use DTS if it's just the straight data that you care about and
the
> > destination
> > server already has the schema defined. However, you may have to drop
> > any foreign keys on the destination server and then re-apply them after
> > the data has been loaded.
> >
> > "ALN" <ALN@.discussions.microsoft.com> wrote in message
> > news:3039DE30-66B9-4058-8C94-76E0547B997A@.microsoft.com...
> > > Hi,
> > > how can I copy the userdata from one sqlserver to another sqlserver ?
> > >
> > > Best regards
> > >
> > > Axel Lanser
> >
> >
> >|||Hi,
thank you very much. Today I found the right way to copy the userdata with
dts.
Best regards
Axel Lanser
"Armando Prato" wrote:
> You don't have to build tables. You can choose to append to existing
> tables.
> "ALN" <ALN@.discussions.microsoft.com> wrote in message
> news:02C317FA-CD0E-451C-87D7-89CDCD9CEB3F@.microsoft.com...
> > Hi,
> > with dts I can copy only tables and views from a database. In the sql
> server
> > I define much sql server specific und windows specific users with their
> right.
> > That users and their rights I had defined in one SQL-server. My problem is
> > now how can I copy them to a 2nd SQL-server.
> >
> > Best refards
> >
> > Axel Lanser
> >
> > "Armando Prato" wrote:
> >
> > >
> > > You can use DTS if it's just the straight data that you care about and
> the
> > > destination
> > > server already has the schema defined. However, you may have to drop
> > > any foreign keys on the destination server and then re-apply them after
> > > the data has been loaded.
> > >
> > > "ALN" <ALN@.discussions.microsoft.com> wrote in message
> > > news:3039DE30-66B9-4058-8C94-76E0547B997A@.microsoft.com...
> > > > Hi,
> > > > how can I copy the userdata from one sqlserver to another sqlserver ?
> > > >
> > > > Best regards
> > > >
> > > > Axel Lanser
> > >
> > >
> > >
>
>