I have a ms access database on say c:\database.mdb
I have a sql server 2000 running too.
I want to use some command line tool , like isql or osql to convert this database into a sql sever database.
How can I achieve this ?
Thanks in advance.
Alok.You can use SQL server's DTS tool to import MS access database to SQL server.
If not you can use MS Access Upsizing wizard to upgrade to SQL server.|||As I mentioned , I need to do it through command line.
If you give me a sample code , that would be great.|||After creating the DTS package run DTSRUN utility from command prompt to execute the package. Refer to SQL server books online for DTS topics and DTSRUN topic for more information.
Showing posts with label tool. Show all posts
Showing posts with label tool. Show all posts
Friday, March 23, 2012
Monday, March 19, 2012
Importing DB2 ixf files into SQLServer 2000
Does anybody know of an application / tool that will allow me to import some DB2 ixf format files into a SQL Server 2000 database ?
Many thanksOriginally posted by shopper
Does anybody know of an application / tool that will allow me to import some DB2 ixf format files into a SQL Server 2000 database ?
Many thanks
Hello you can use FoxPro import and from there send it to SQL2000
my two cents
marcos oliva
Many thanksOriginally posted by shopper
Does anybody know of an application / tool that will allow me to import some DB2 ixf format files into a SQL Server 2000 database ?
Many thanks
Hello you can use FoxPro import and from there send it to SQL2000
my two cents
marcos oliva
Subscribe to:
Posts (Atom)