Hi,
I need to copy a SQL 7 database to an Access database - Including indexes,
Identity and so on.
Is it possible?
Thanks!
M O J O
I need to copy a SQL 7 database to an Access database - Including indexes,
Identity and so on.
Is it possible?
Thanks!
M O J O
Check out the SQL Server DTS (data transformation services) utility.
Steve
Quote:> I need to copy a SQL 7 database to an Access database - Including indexes,
> Identity and so on.
> Is it possible?
--
Andrew J. Kelly, SQL Server MVP
TargitInteractive
Please join me at PASS North America in Denver - the first and only user
conference dedicated to SQL Server.
http://www.sqlpass.org/events/denverjan/index.cfm
Quote:> Hi,
> I need to copy a SQL 7 database to an Access database - Including indexes,
> Identity and so on.
> Is it possible?
> Thanks!
> M O J O
I've tried the DTS wizard, but this only copies data and doesn't create
indexes.
M O J O
> --
> Andrew J. Kelly, SQL Server MVP
> TargitInteractive
> Please join me at PASS North America in Denver - the first and only user
> conference dedicated to SQL Server.
> http://www.sqlpass.org/events/denverjan/index.cfm
> > Hi,
> > I need to copy a SQL 7 database to an Access database - Including
indexes,
> > Identity and so on.
> > Is it possible?
> > Thanks!
> > M O J O
--
Andrew J. Kelly, SQL Server MVP
> I've tried the DTS wizard, but this only copies data and doesn't create
> indexes.
> M O J O
> > Not sure how much gets transferred but you can try the DTS wizard.
> > --
> > Andrew J. Kelly, SQL Server MVP
> > TargitInteractive
> > Please join me at PASS North America in Denver - the first and only user
> > conference dedicated to SQL Server.
> > http://www.sqlpass.org/events/denverjan/index.cfm
> > > Hi,
> > > I need to copy a SQL 7 database to an Access database - Including
> indexes,
> > > Identity and so on.
> > > Is it possible?
> > > Thanks!
> > > M O J O
FYI
DTS can only copy table schemas and data when the destination is not SQL
Server. All other database objects ... indexes, stored procedures, triggers,
etc. ... can not be copied when the destination is other than SQL Server.
-------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.
> --
> Andrew J. Kelly, SQL Server MVP
> > Hi Andrew,
> > I've tried the DTS wizard, but this only copies data and doesn't create
> > indexes.
> > M O J O
> > > Not sure how much gets transferred but you can try the DTS wizard.
> > > --
> > > Andrew J. Kelly, SQL Server MVP
> > > TargitInteractive
> > > Please join me at PASS North America in Denver - the first and only
user
> > > conference dedicated to SQL Server.
> > > http://www.sqlpass.org/events/denverjan/index.cfm
> > > > Hi,
> > > > I need to copy a SQL 7 database to an Access database - Including
> > indexes,
> > > > Identity and so on.
> > > > Is it possible?
> > > > Thanks!
> > > > M O J O
Thanks, I realize that for most things but thought with the history between
Jet and SQL Server they may have had the ability to do a "Best Case"
scenario on the indexes.
--
Andrew J. Kelly, SQL Server MVP
> FYI
> DTS can only copy table schemas and data when the destination is not SQL
> Server. All other database objects ... indexes, stored procedures,
triggers,
> etc. ... can not be copied when the destination is other than SQL Server.
> -------------------------------------------
> BP Margolin
> Please reply only to the newsgroups.
> When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
> can be cut and pasted into Query Analyzer is appreciated.
> > Sorry, don't know enough about access to be of more help. I am
surprised
> to
> > find DTS couldn't do that with access.
> > --
> > Andrew J. Kelly, SQL Server MVP
> > > Hi Andrew,
> > > I've tried the DTS wizard, but this only copies data and doesn't
create
> > > indexes.
> > > M O J O
> > > > Not sure how much gets transferred but you can try the DTS wizard.
> > > > --
> > > > Andrew J. Kelly, SQL Server MVP
> > > > TargitInteractive
> > > > Please join me at PASS North America in Denver - the first and only
> user
> > > > conference dedicated to SQL Server.
> > > > http://www.sqlpass.org/events/denverjan/index.cfm
> > > > > Hi,
> > > > > I need to copy a SQL 7 database to an Access database - Including
> > > indexes,
> > > > > Identity and so on.
> > > > > Is it possible?
> > > > > Thanks!
> > > > > M O J O
M O J O
> Thanks, I realize that for most things but thought with the history
between
> Jet and SQL Server they may have had the ability to do a "Best Case"
> scenario on the indexes.
> --
> Andrew J. Kelly, SQL Server MVP
> > Andrew,
> > FYI
> > DTS can only copy table schemas and data when the destination is not SQL
> > Server. All other database objects ... indexes, stored procedures,
> triggers,
> > etc. ... can not be copied when the destination is other than SQL
Server.
> > -------------------------------------------
> > BP Margolin
> > Please reply only to the newsgroups.
> > When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.)
which
> > can be cut and pasted into Query Analyzer is appreciated.
> > > Sorry, don't know enough about access to be of more help. I am
> surprised
> > to
> > > find DTS couldn't do that with access.
> > > --
> > > Andrew J. Kelly, SQL Server MVP
> > > > Hi Andrew,
> > > > I've tried the DTS wizard, but this only copies data and doesn't
> create
> > > > indexes.
> > > > M O J O
> > > > > Not sure how much gets transferred but you can try the DTS wizard.
> > > > > --
> > > > > Andrew J. Kelly, SQL Server MVP
> > > > > TargitInteractive
> > > > > Please join me at PASS North America in Denver - the first and
only
> > user
> > > > > conference dedicated to SQL Server.
> > > > > http://www.sqlpass.org/events/denverjan/index.cfm
> > > > > > Hi,
> > > > > > I need to copy a SQL 7 database to an Access database -
Including
> > > > indexes,
> > > > > > Identity and so on.
> > > > > > Is it possible?
> > > > > > Thanks!
> > > > > > M O J O
1. Importing MSAccess database to MSSQL Server
Please pardon me if the question sounded stupid.
I've downloaded and installed the UPSIZING utility from MS website
(WZCS97.EXE), but I have a BIG problem : I don't know how to do use it
to import tables from Access to SQL Server? Anyone can shed some lights
on the steps to do it?
Pls help... thanks.
Eddie
3. copy tabel from X400 to msaccess database
5. compare mssql 6.5 database and mssql 7.0 database
7. HELP : ODBC32 for MSACCESS and MSSQL.
8. mvbase printer driver problems
10. Question about msAccess+msSQL Server
11. Failed SQL7 to SQL2000 database copy using copy database wizard
12. copying tables and its data from MSAccess to SQL dbase in Visualstudio.net
13. is it possible to copy msSql/data/aDev.dat to another machine at clients site