dbTalk Databases Forums  

tranfer data from sqlserver2000 to sql express2005 mdf file

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss tranfer data from sqlserver2000 to sql express2005 mdf file in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
ads
 
Posts: n/a

Default tranfer data from sqlserver2000 to sql express2005 mdf file - 08-28-2006 , 05:04 AM






i need to develop a web application where its database included in the
project meaning it can be an attach file like access db. i'm thinking access
db or sql express 2005 mdf file to use. BTW our data is currently in a sql
server 2000 db.

Using access db, i will need to transfer data from sqlserver2000 to access
db. using DTS its easy to tranfer tables and views but stored procs is not
included.i will need to translate every stored procs to stored query in
access therefore a tedious work.

Using sql express 2005 file, i will need to do the same DTS to transfer data
files. The problem is i dont have sql server 2005 management studio to do
this. im currently using visual studio 2005 to manage sql express 2005 which
has limited functionality (no DTS).where do i get a sql express 2005 with
management studio?

Any suggestions?

Thanks.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.