deploy SQL2000 database to other server

hi,
I am sorting data from all different sources, xml, access, text..etc
to my own sql2000 server. (computer name is "testingmachine")
atfter I clean up the database, I will give the final database to the
client and install in their server (computer name is "SQLS")
1) what's the best way to move database structure and data over to
their server? there are few different methods, which one is the best
solution in my situation. thank you!
PS. I use *.adp ("access running time" as frontend client interface)
thank you!This KB article should give you a few methods. You can decide which way is
best for your situation:
http://support.microsoft.com/default.aspx?scid=kb;en-us;314546&Product=sql
--
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Bob Yang" <bobyang3@.hotmail.com> wrote in message
news:35582154.0406301458.2553431b@.posting.google.com...
> hi,
> I am sorting data from all different sources, xml, access, text..etc
> to my own sql2000 server. (computer name is "testingmachine")
> atfter I clean up the database, I will give the final database to the
> client and install in their server (computer name is "SQLS")
> 1) what's the best way to move database structure and data over to
> their server? there are few different methods, which one is the best
> solution in my situation. thank you!
>
> PS. I use *.adp ("access running time" as frontend client interface)
> thank you!