want to export hole mssqlserver 2000 object in msaccess 2000  
Author Message
wpng





PostPosted: Sat Jul 10 07:56:53 CDT 2004 Top

SQL Server >> want to export hole mssqlserver 2000 object in msaccess 2000

hi All

I want to export my mssqlserver 2000 database with all relation ship and all
default value and all data save in sqlserver Database (I want to export hole
data base object ) in MS Access database is it possible
if it is possible from mssqlserver please tell me if it is possible from any
other third party tool then please tell me

thanks in advanced

from
khurram

SQL Server102  
 
 
Thirumal





PostPosted: Sat Jul 10 07:56:53 CDT 2004 Top

SQL Server >> want to export hole mssqlserver 2000 object in msaccess 2000 Hi,

Your query is very confusing. Do you mean you want to
export from SQL Server to MS Access. If it is so, I am not
sure it is possible, as I never heard of downgrading. If
it is from Access to SQL Server,you can acheive it by SQL
DTS. There are good step by step articles. Google is ur
best friend.

Regards

Thirumal
www.thirumal.com
>-----Original Message-----
>hi All
>
>I want to export my mssqlserver 2000 database with all
relation ship and all
>default value and all data save in sqlserver Database (I
want to export hole
>data base object ) in MS Access database is it possible
>if it is possible from mssqlserver please tell me if it
is possible from any
>other third party tool then please tell me
>
>thanks in advanced
>
>from
>khurram
>
>
>
>.
>
 
 
Hari





PostPosted: Sun Jul 11 07:13:13 CDT 2004 Top

SQL Server >> want to export hole mssqlserver 2000 object in msaccess 2000 Hi,

You can either use Upsizing wizard or SQL DTS to upgrade objects/data from
Access to SQL server.
The details about the tools and steps are detailed in the below
knowledgebase article.

http://support.microsoft.com/default.aspx?scid=kb;en-us;237980

Thanks
Hri
MCDBA




> hi All
>
> I want to export my mssqlserver 2000 database with all relation ship and
all
> default value and all data save in sqlserver Database (I want to export
hole
> data base object ) in MS Access database is it possible
> if it is possible from mssqlserver please tell me if it is possible from
any
> other third party tool then please tell me
>
> thanks in advanced
>
> from
> khurram
>
>
>


 
 
Mark





PostPosted: Mon Jul 12 06:27:52 CDT 2004 Top

SQL Server >> want to export hole mssqlserver 2000 object in msaccess 2000 khurram,

I would recommend you use MSDE and not MS Access if you wish to
distribute your database. MSDE is far superior to Access. Check out the
features of MSDE here:

http://www.microsoft.com/sql/msde/default.asp

--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html




> hi All
>
> I want to export my mssqlserver 2000 database with all relation ship and all
> default value and all data save in sqlserver Database (I want to export hole
> data base object ) in MS Access database is it possible
> if it is possible from mssqlserver please tell me if it is possible from any
> other third party tool then please tell me
>
> thanks in advanced
>
> from
> khurram
>
>
>
 
 
Wayne





PostPosted: Mon Jul 12 06:59:54 CDT 2004 Top

SQL Server >> want to export hole mssqlserver 2000 object in msaccess 2000 As Mark suggested, if you wish to distibute use MSDE, if you wish to simply
put the database on your laptop to work at home ( for instance) use the
developer or personal edition as well.

--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, C****te, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)

I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org



> hi All
>
> I want to export my mssqlserver 2000 database with all relation ship and
all
> default value and all data save in sqlserver Database (I want to export
hole
> data base object ) in MS Access database is it possible
> if it is possible from mssqlserver please tell me if it is possible from
any
> other third party tool then please tell me
>
> thanks in advanced
>
> from
> khurram
>
>
>