data replication

To all,
I am totally new to database programming and SQLServer. I need to find out
how to "copy" the data in database 1 to the database 2. How, in general one
does this type of "copy" or "migration". Is there a SQL standard way to do
this?
Thanks in advance.
RezaReza,
there are numerous options depending on your requirements eg is this for
high-availability, reporting, load balancing etc.
Anyway, please have a look in BOL at Log Shipping, Replication and Database
Mirroring.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)|||This ultimately is to generate reports from the data in the database. Just
curious, what is BOL at Log Shipping?
Reza
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:ukK6DswYGHA.3972@.TK2MSFTNGP04.phx.gbl...
> Reza,
> there are numerous options depending on your requirements eg is this for
> high-availability, reporting, load balancing etc.
> Anyway, please have a look in BOL at Log Shipping, Replication and
> Database Mirroring.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>|||BOL = Books On Line
Log Shipping is what you need to look up in the index.
"Reza Razavipour" <rrazavipour@.stbernard.com> wrote in message
news:eeP5PvwYGHA.3424@.TK2MSFTNGP02.phx.gbl...
> This ultimately is to generate reports from the data in the database. Just
> curious, what is BOL at Log Shipping?
> Reza
> "Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
> news:ukK6DswYGHA.3972@.TK2MSFTNGP04.phx.gbl...
>

Data Recovery Book

Hi!
I am glad to introduce World's First Book on Professional Data
Recovery Programming. Book also Includes a FREE CD, which contains
complete Source Codes of all the software/Programs described within
the book and may interesting tools
You can see the contents of the book and order Online on following
link:
http://www.DataDoctor.biz/author.htm
The Details of the Book are as follows:
Title of the book: "Data Recovery with & without Programming"
Author of the book: Tarun Tyagi
Publishers of the book: BPB Publications, New Delhi, India
Number of Pages: 540
Size: (9.5 x 7.5 x 1.0) Inches
ISBN: 81-7656-922-4
Price: $ 69.00 (Including Shipping Charge, Cost of
Book and Other expenses)
Enjoy Reading!!
Regards,
Tarun Tyagi
J-110, Patel Nagar - 1,
Ghaziabad (U.P.), India -201001
Cell: (+91)9868337762
http://www.DataDoctor.Biz
Your page doesn't render at all in Firefox. You might want to check that
out.
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
"Author Tarun Tyagi" <tyagi_st@.yahoo.com> wrote in message
news:a921f5f5.0412010120.1b976a90@.posting.google.c om...
> Hi!
> I am glad to introduce World's First Book on Professional Data
> Recovery Programming. Book also Includes a FREE CD, which contains
> complete Source Codes of all the software/Programs described within
> the book and may interesting tools
> You can see the contents of the book and order Online on following
> link:
> http://www.DataDoctor.biz/author.htm
> The Details of the Book are as follows:
> Title of the book: "Data Recovery with & without Programming"
> Author of the book: Tarun Tyagi
> Publishers of the book: BPB Publications, New Delhi, India
> Number of Pages: 540
> Size: (9.5 x 7.5 x 1.0) Inches
> ISBN: 81-7656-922-4
> Price: $ 69.00 (Including Shipping Charge, Cost of
> Book and Other expenses)
> Enjoy Reading!!
> Regards,
> Tarun Tyagi
> J-110, Patel Nagar - 1,
> Ghaziabad (U.P.), India -201001
> Cell: (+91)9868337762
> http://www.DataDoctor.Biz

Data Recovery Book

Hi!
I am glad to introduce World's First Book on Professional Data
Recovery Programming. Book also Includes a FREE CD, which contains
complete Source Codes of all the software/Programs described within
the book and may interesting tools
You can see the contents of the book and order Online on following
link:
http://www.DataDoctor.biz/author.htm
The Details of the Book are as follows:
Title of the book: "Data Recovery with & without Programming"
Author of the book: Tarun Tyagi
Publishers of the book: BPB Publications, New Delhi, India
Number of Pages: 540
Size: (9.5 x 7.5 x 1.0) Inches
ISBN: 81-7656-922-4
Price: $ 69.00 (Including Shipping Charge, Cost of
Book and Other expenses)
Enjoy Reading!!
Regards,
Tarun Tyagi
J-110, Patel Nagar - 1,
Ghaziabad (U.P.), India -201001
Cell: (+91)9868337762
http://www.DataDoctor.BizYour page doesn't render at all in Firefox. You might want to check that
out.
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"Author Tarun Tyagi" <tyagi_st@.yahoo.com> wrote in message
news:a921f5f5.0412010120.1b976a90@.posting.google.com...
> Hi!
> I am glad to introduce World's First Book on Professional Data
> Recovery Programming. Book also Includes a FREE CD, which contains
> complete Source Codes of all the software/Programs described within
> the book and may interesting tools
> You can see the contents of the book and order Online on following
> link:
> http://www.DataDoctor.biz/author.htm
> The Details of the Book are as follows:
> Title of the book: "Data Recovery with & without Programming"
> Author of the book: Tarun Tyagi
> Publishers of the book: BPB Publications, New Delhi, India
> Number of Pages: 540
> Size: (9.5 x 7.5 x 1.0) Inches
> ISBN: 81-7656-922-4
> Price: $ 69.00 (Including Shipping Charge, Cost of
> Book and Other expenses)
> Enjoy Reading!!
> Regards,
> Tarun Tyagi
> J-110, Patel Nagar - 1,
> Ghaziabad (U.P.), India -201001
> Cell: (+91)9868337762
> http://www.DataDoctor.Biz

Data Recovery Book

Hi!
I am glad to introduce World's First Book on Professional Data
Recovery Programming. Book also Includes a FREE CD, which contains
complete Source Codes of all the software/Programs described within
the book and may interesting tools
You can see the contents of the book and order Online on following
link:
http://www.DataDoctor.biz/author.htm
The Details of the Book are as follows:
Title of the book: "Data Recovery with & without Programming"
Author of the book: Tarun Tyagi
Publishers of the book: BPB Publications, New Delhi, India
Number of Pages: 540
Size: (9.5 x 7.5 x 1.0) Inches
ISBN: 81-7656-922-4
Price: $ 69.00 (Including Shipping Charge, Cost of
Book and Other expenses)
Enjoy Reading!!
Regards,
Tarun Tyagi
J-110, Patel Nagar - 1,
Ghaziabad (U.P.), India -201001
Cell: (+91)9868337762
http://www.DataDoctor.BizYour page doesn't render at all in Firefox. You might want to check that
out.
--
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"Author Tarun Tyagi" <tyagi_st@.yahoo.com> wrote in message
news:a921f5f5.0412010120.1b976a90@.posting.google.com...
> Hi!
> I am glad to introduce World's First Book on Professional Data
> Recovery Programming. Book also Includes a FREE CD, which contains
> complete Source Codes of all the software/Programs described within
> the book and may interesting tools
> You can see the contents of the book and order Online on following
> link:
> http://www.DataDoctor.biz/author.htm
> The Details of the Book are as follows:
> Title of the book: "Data Recovery with & without Programming"
> Author of the book: Tarun Tyagi
> Publishers of the book: BPB Publications, New Delhi, India
> Number of Pages: 540
> Size: (9.5 x 7.5 x 1.0) Inches
> ISBN: 81-7656-922-4
> Price: $ 69.00 (Including Shipping Charge, Cost of
> Book and Other expenses)
> Enjoy Reading!!
> Regards,
> Tarun Tyagi
> J-110, Patel Nagar - 1,
> Ghaziabad (U.P.), India -201001
> Cell: (+91)9868337762
> http://www.DataDoctor.Biz

Data Model Question

I posted to programming but thought maybe this is a btter group:
There may be some tools out there already developed that can handle this but
I haven't had success in finding them.
Essentially what I am trying to do is create a data model that can
accomodate the creation of a variety of forms to be filled out.
The end user should be able to create a question and select what type of
answer it will bne, multi select, checkbox, radio box, free text. Provide
the possible answers if needed. And then allow the form to be filled out
and the responses saved.
That part shouldn't be too tough. Forms may need to be able to be related
to other forms or multiple forms could make up 1 form to fill out. Like
form A and D.
If there is something like this already I don't want to reinvent the wheel.
Also if someone has experience with this type of model has it been good or
bad.
Thanks.You had one response. Was that not helpful? There are also some posts from
Janmar on a similar topic. Did you read those posts?|||A response in this group or the programming one? I didn't see any.
"Scott Morris" <bogus@.bogus.com> wrote in message
news:ucBrV62lFHA.3300@.TK2MSFTNGP15.phx.gbl...
> You had one response. Was that not helpful? There are also some posts
> from
> Janmar on a similar topic. Did you read those posts?
>

Data Model Question

I posted to programming but thought maybe this is a btter group:
There may be some tools out there already developed that can handle this but
I haven't had success in finding them.
Essentially what I am trying to do is create a data model that can
accomodate the creation of a variety of forms to be filled out.
The end user should be able to create a question and select what type of
answer it will bne, multi select, checkbox, radio box, free text. Provide
the possible answers if needed. And then allow the form to be filled out
and the responses saved.
That part shouldn't be too tough. Forms may need to be able to be related
to other forms or multiple forms could make up 1 form to fill out. Like
form A and D.
If there is something like this already I don't want to reinvent the wheel.
Also if someone has experience with this type of model has it been good or
bad.
Thanks.
You had one response. Was that not helpful? There are also some posts from
Janmar on a similar topic. Did you read those posts?
|||A response in this group or the programming one? I didn't see any.
"Scott Morris" <bogus@.bogus.com> wrote in message
news:ucBrV62lFHA.3300@.TK2MSFTNGP15.phx.gbl...
> You had one response. Was that not helpful? There are also some posts
> from
> Janmar on a similar topic. Did you read those posts?
>

Data Model Question

I posted to programming but thought maybe this is a btter group:
There may be some tools out there already developed that can handle this but
I haven't had success in finding them.
Essentially what I am trying to do is create a data model that can
accomodate the creation of a variety of forms to be filled out.
The end user should be able to create a question and select what type of
answer it will bne, multi select, checkbox, radio box, free text. Provide
the possible answers if needed. And then allow the form to be filled out
and the responses saved.
That part shouldn't be too tough. Forms may need to be able to be related
to other forms or multiple forms could make up 1 form to fill out. Like
form A and D.
If there is something like this already I don't want to reinvent the wheel.
Also if someone has experience with this type of model has it been good or
bad.
Thanks.You had one response. Was that not helpful? There are also some posts from
Janmar on a similar topic. Did you read those posts?|||A response in this group or the programming one? I didn't see any.
"Scott Morris" <bogus@.bogus.com> wrote in message
news:ucBrV62lFHA.3300@.TK2MSFTNGP15.phx.gbl...
> You had one response. Was that not helpful? There are also some posts
> from
> Janmar on a similar topic. Did you read those posts?
>