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. |