m*******r
发帖数: 4 | 1 I am on my first job. I am working on my 1st project on my own and the first
stage of the project is due July 15.So it's pretty urgent.
Our company's current db is on Access and the schema sucks. I need to convert
the whole db from Access to SQL Server according to the new schema. I don't
have much experience with DB at all. Just used Oracle and JDBC in one class.
So what should I do? Write a VB/VB.NET program (that's what my company uses to
write all the of their softwares) to output the old da |
a*******e
发帖数: 100 | 2 Haven't used Access for quite a while, but if i remember correctly, there were
upsizing tools that comes with Access or SQL Server or both for this purpose.
Check your versions of these two tools.
convert
to
【在 m*******r 的大作中提到】
: I am on my first job. I am working on my 1st project on my own and the first
: stage of the project is due July 15.So it's pretty urgent.
: Our company's current db is on Access and the schema sucks. I need to convert
: the whole db from Access to SQL Server according to the new schema. I don't
: have much experience with DB at all. Just used Oracle and JDBC in one class.
: So what should I do? Write a VB/VB.NET program (that's what my company uses to
: write all the of their softwares) to output the old da
|
aw
发帖数: 127 | 3 it's easy.
open sql server enterprise manager, create a new empty database, then try "all
tasks" -> import data, then specify you're importing from an access database
and follow the instructions.
were
purpose.
first
don't
class.
uses
【在 a*******e 的大作中提到】
: Haven't used Access for quite a while, but if i remember correctly, there were
: upsizing tools that comes with Access or SQL Server or both for this purpose.
: Check your versions of these two tools.
:
: convert
: to
|
l*m
发帖数: 4 | 4 怎末不试试DTS ?
找本书看看就成了
were
purpose.
first
don't
class.
uses
【在 a*******e 的大作中提到】
: Haven't used Access for quite a while, but if i remember correctly, there were
: upsizing tools that comes with Access or SQL Server or both for this purpose.
: Check your versions of these two tools.
:
: convert
: to
|
