copy data from mSDE to SQL Server

• isa-369599

  SSCommitted

  Points: 1602

  More actions

  January 25, 2007 at 11:43 pm

  #90886

  hello everyone,

  i want to transfer/copy  data from MSDE to SQL Server 2000 and from SQL Server to MSDE, through Stored Procedures , not using a "Replication", kindly tell me how i make a SP for this as both datatbases are connetec through LAN, i mean MSDE on diff machine and SQL Server on other machine i make a new registration and connect with MSDE now how can i write a SP that copy data from table of 1 Database to other table of that Database.

  kindly reply me asap, its very urgent.

  Thanx in Advance.

• Adrian Nichols-360275

  SSCertifiable

  Points: 7694

  More actions

  January 26, 2007 at 6:13 am

  #685791

  I believe that you can detach the MSDE database file and attach it to the SQL Server 2000 installation...

   

  Check out:  http://support.microsoft.com/kb/325023

  Find "detach the MSDE 2000" and have a quick read of that.

  Ade

  ---

  
  Ade

  A Freudian Slip is when you say one thing and mean your mother.
  For detail-enriched answers, ask detail-enriched questions...[/url]