Hello all,
I got a application which is developed using VB6.0 as front end and
MS-Access as backend. Now i would like to change the database from MS-Access
to MS-SQLserver.
How do I change the databse from MS-Access to MS-SQLServer?
Regards
JackAnswered in .newusers
Please keep your posts to one newsgreoup. What you want to do is well
documented in a few thousand different pages all over the internet
Kevin Hill
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.expertsrt.com - not your average tech Q&A site
"Jack" <Jack@.discussions.microsoft.com> wrote in message
news:427EBA98-380A-42EC-A3C5-47097790D9F9@.microsoft.com...
> Hello all,
> I got a application which is developed using VB6.0 as front end and
> MS-Access as backend. Now i would like to change the database from
> MS-Access
> to MS-SQLserver.
> How do I change the databse from MS-Access to MS-SQLServer?
> Regards
> Jack|||MS Access 2000 Migration Guide
http://www.microsoft.com/technet/pr...
/acssmgde.mspx
After porting over the tables and data, read up on the techniques for
optimizing a SQL Server application:
http://msdn.microsoft.com/library/d...
etHowTo03.asp
http://msdn.microsoft.com/library/d...
ethowto04.asp
http://msdn.microsoft.com/SQL/2000/...rf/default.aspx
"Jack" <Jack@.discussions.microsoft.com> wrote in message
news:427EBA98-380A-42EC-A3C5-47097790D9F9@.microsoft.com...
> Hello all,
> I got a application which is developed using VB6.0 as front end and
> MS-Access as backend. Now i would like to change the database from
> MS-Access
> to MS-SQLserver.
> How do I change the databse from MS-Access to MS-SQLServer?
> Regards
> Jack
Showing posts with label msaccess. Show all posts
Showing posts with label msaccess. Show all posts
Thursday, March 22, 2012
Changing the database from MSAccess to MSSQLServer.
Hello all,
I got a application which is developed using VB6.0 as front end and
MS-Access as backend. Now i would like to change the database from MS-Access
to MS-SQLserver.
How do I change the databse from MS-Access to MS-SQLServer?
Regards
Jack
see the response in .newusers
Please only post the same question to one group...
Kevin Hill
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.expertsrt.com - not your average tech Q&A site
"Jack" <Jack@.discussions.microsoft.com> wrote in message
news:4C0633A4-44A2-402B-8C6B-91A646D8B988@.microsoft.com...
> Hello all,
> I got a application which is developed using VB6.0 as front end and
> MS-Access as backend. Now i would like to change the database from
> MS-Access
> to MS-SQLserver.
> How do I change the databse from MS-Access to MS-SQLServer?
> Regards
> Jack
sql
I got a application which is developed using VB6.0 as front end and
MS-Access as backend. Now i would like to change the database from MS-Access
to MS-SQLserver.
How do I change the databse from MS-Access to MS-SQLServer?
Regards
Jack
see the response in .newusers
Please only post the same question to one group...
Kevin Hill
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.expertsrt.com - not your average tech Q&A site
"Jack" <Jack@.discussions.microsoft.com> wrote in message
news:4C0633A4-44A2-402B-8C6B-91A646D8B988@.microsoft.com...
> Hello all,
> I got a application which is developed using VB6.0 as front end and
> MS-Access as backend. Now i would like to change the database from
> MS-Access
> to MS-SQLserver.
> How do I change the databse from MS-Access to MS-SQLServer?
> Regards
> Jack
sql
Changing the database from MSAccess to MSSQLServer.
Hello all,
I got a application which is developed using VB6.0 as front end and
MS-Access as backend. Now i would like to change the database from MS-Access
to MS-SQLserver.
How do I change the databse from MS-Access to MS-SQLServer?
Regards
Jack
Hi Jack
You don't say which version of SQL Server you wish to upgrade to?
The guys in the Access newsgroup tend to have their own opinons regarding
the Access upgrade wizard so you may want to ask in there!
The upgrade wizard may provide enough to upgrade your database but then you
should look at tuning and re-writing the code so that it is more compatible
with SQL server, such as choosing more appropriate data types etc.
As an alternative you can do this manually and piecemeal using the Import
Wizard in SQL server (i.e DTS/SSIS).
Before you try anything make sure that you have a recoverable backup. It
will be worthwhile honing the upgrade on a separate system before attempting
anything on the live database.
John
"Jack" wrote:
> Hello all,
> I got a application which is developed using VB6.0 as front end and
> MS-Access as backend. Now i would like to change the database from MS-Access
> to MS-SQLserver.
> How do I change the databse from MS-Access to MS-SQLServer?
> Regards
> Jack
I got a application which is developed using VB6.0 as front end and
MS-Access as backend. Now i would like to change the database from MS-Access
to MS-SQLserver.
How do I change the databse from MS-Access to MS-SQLServer?
Regards
Jack
Hi Jack
You don't say which version of SQL Server you wish to upgrade to?
The guys in the Access newsgroup tend to have their own opinons regarding
the Access upgrade wizard so you may want to ask in there!
The upgrade wizard may provide enough to upgrade your database but then you
should look at tuning and re-writing the code so that it is more compatible
with SQL server, such as choosing more appropriate data types etc.
As an alternative you can do this manually and piecemeal using the Import
Wizard in SQL server (i.e DTS/SSIS).
Before you try anything make sure that you have a recoverable backup. It
will be worthwhile honing the upgrade on a separate system before attempting
anything on the live database.
John
"Jack" wrote:
> Hello all,
> I got a application which is developed using VB6.0 as front end and
> MS-Access as backend. Now i would like to change the database from MS-Access
> to MS-SQLserver.
> How do I change the databse from MS-Access to MS-SQLServer?
> Regards
> Jack
Changing the database from MSAccess to MSSQLServer.
Hello all,
I got a application which is developed using VB6.0 as front end and
MS-Access as backend. Now i would like to change the database from MS-Access
to MS-SQLserver.
How do I change the databse from MS-Access to MS-SQLServer?
Regards
JackHi Jack
You don't say which version of SQL Server you wish to upgrade to?
The guys in the Access newsgroup tend to have their own opinons regarding
the Access upgrade wizard so you may want to ask in there!
The upgrade wizard may provide enough to upgrade your database but then you
should look at tuning and re-writing the code so that it is more compatible
with SQL server, such as choosing more appropriate data types etc.
As an alternative you can do this manually and piecemeal using the Import
Wizard in SQL server (i.e DTS/SSIS).
Before you try anything make sure that you have a recoverable backup. It
will be worthwhile honing the upgrade on a separate system before attempting
anything on the live database.
John
"Jack" wrote:
> Hello all,
> I got a application which is developed using VB6.0 as front end and
> MS-Access as backend. Now i would like to change the database from MS-Acce
ss
> to MS-SQLserver.
> How do I change the databse from MS-Access to MS-SQLServer?
> Regards
> Jack
I got a application which is developed using VB6.0 as front end and
MS-Access as backend. Now i would like to change the database from MS-Access
to MS-SQLserver.
How do I change the databse from MS-Access to MS-SQLServer?
Regards
JackHi Jack
You don't say which version of SQL Server you wish to upgrade to?
The guys in the Access newsgroup tend to have their own opinons regarding
the Access upgrade wizard so you may want to ask in there!
The upgrade wizard may provide enough to upgrade your database but then you
should look at tuning and re-writing the code so that it is more compatible
with SQL server, such as choosing more appropriate data types etc.
As an alternative you can do this manually and piecemeal using the Import
Wizard in SQL server (i.e DTS/SSIS).
Before you try anything make sure that you have a recoverable backup. It
will be worthwhile honing the upgrade on a separate system before attempting
anything on the live database.
John
"Jack" wrote:
> Hello all,
> I got a application which is developed using VB6.0 as front end and
> MS-Access as backend. Now i would like to change the database from MS-Acce
ss
> to MS-SQLserver.
> How do I change the databse from MS-Access to MS-SQLServer?
> Regards
> Jack
Changing the database from MSAccess to MSSQLServer.
Hello all,
I got a application which is developed using VB6.0 as front end and
MS-Access as backend. Now i would like to change the database from MS-Access
to MS-SQLserver.
How do I change the databse from MS-Access to MS-SQLServer?
Regards
JackHi Jack
You don't say which version of SQL Server you wish to upgrade to?
The guys in the Access newsgroup tend to have their own opinons regarding
the Access upgrade wizard so you may want to ask in there!
The upgrade wizard may provide enough to upgrade your database but then you
should look at tuning and re-writing the code so that it is more compatible
with SQL server, such as choosing more appropriate data types etc.
As an alternative you can do this manually and piecemeal using the Import
Wizard in SQL server (i.e DTS/SSIS).
Before you try anything make sure that you have a recoverable backup. It
will be worthwhile honing the upgrade on a separate system before attempting
anything on the live database.
John
"Jack" wrote:
> Hello all,
> I got a application which is developed using VB6.0 as front end and
> MS-Access as backend. Now i would like to change the database from MS-Access
> to MS-SQLserver.
> How do I change the databse from MS-Access to MS-SQLServer?
> Regards
> Jack
I got a application which is developed using VB6.0 as front end and
MS-Access as backend. Now i would like to change the database from MS-Access
to MS-SQLserver.
How do I change the databse from MS-Access to MS-SQLServer?
Regards
JackHi Jack
You don't say which version of SQL Server you wish to upgrade to?
The guys in the Access newsgroup tend to have their own opinons regarding
the Access upgrade wizard so you may want to ask in there!
The upgrade wizard may provide enough to upgrade your database but then you
should look at tuning and re-writing the code so that it is more compatible
with SQL server, such as choosing more appropriate data types etc.
As an alternative you can do this manually and piecemeal using the Import
Wizard in SQL server (i.e DTS/SSIS).
Before you try anything make sure that you have a recoverable backup. It
will be worthwhile honing the upgrade on a separate system before attempting
anything on the live database.
John
"Jack" wrote:
> Hello all,
> I got a application which is developed using VB6.0 as front end and
> MS-Access as backend. Now i would like to change the database from MS-Access
> to MS-SQLserver.
> How do I change the databse from MS-Access to MS-SQLServer?
> Regards
> Jack
Saturday, February 25, 2012
Changing MS SQL Server Express table properties
Hi,
I have a MS SQL Server Express database wich I upsized once from MSAccess. I can connect to it and get/insert data but I can't update thefield properties.
I've used Access 2003, Visual Studio .Net and SQL Server Web DataAdministrator, but I can't change the properties of existing tables. Icán add new tables and add their properties afterwards. Since I have alot of tables it would be too much work too recreate them all. So howcan I edit my existing tables?
Create new identical tables for each and do INSERT INTO and drop all the old tables so you have new SQL Server Express tables that you can modify. Hope this helps.
I have a MS SQL Server Express database wich I upsized once from MSAccess. I can connect to it and get/insert data but I can't update thefield properties.
I've used Access 2003, Visual Studio .Net and SQL Server Web DataAdministrator, but I can't change the properties of existing tables. Icán add new tables and add their properties afterwards. Since I have alot of tables it would be too much work too recreate them all. So howcan I edit my existing tables?
Create new identical tables for each and do INSERT INTO and drop all the old tables so you have new SQL Server Express tables that you can modify. Hope this helps.
Sunday, February 12, 2012
Changing Database Structure After Application Deployment
Hi,
We're planning to rewrite a program of ours from ms-dos with a dbase
database to windows using ado and msaccess or sqlserver 2000. now we have
the problem of database maintenance. because the program is going to be
deployed to multiple customers, we don't want to manually change the
database structure. In dos we had a mechanism with a table which stored the
table definitions, and a table which stored the index definitions. now we
want something similiar to that for windows, and it would be even nicer if
the solution is crossdatabase. it's fine if the "new" database structure(the
structure which the customer doesn't have) is stored in an xml file or
similar.
thanks in advance,
Matthijs ter Woord
if you want to version your databases check out DB Ghost - www.dbghost.com
"M. ter Woord" wrote:
> Hi,
> We're planning to rewrite a program of ours from ms-dos with a dbase
> database to windows using ado and msaccess or sqlserver 2000. now we have
> the problem of database maintenance. because the program is going to be
> deployed to multiple customers, we don't want to manually change the
> database structure. In dos we had a mechanism with a table which stored the
> table definitions, and a table which stored the index definitions. now we
> want something similiar to that for windows, and it would be even nicer if
> the solution is crossdatabase. it's fine if the "new" database structure(the
> structure which the customer doesn't have) is stored in an xml file or
> similar.
>
> thanks in advance,
> Matthijs ter Woord
>
>
|||Can somebody think of a solution which i can build myself?
Matthijs
"mark baekdal" <markbaekdal@.discussions.microsoft.com> schreef in bericht
news:821F7892-552F-4784-9D0A-A3E36D615735@.microsoft.com...
> if you want to version your databases check out DB Ghost -
www.dbghost.com[vbcol=seagreen]
> "M. ter Woord" wrote:
have[vbcol=seagreen]
the[vbcol=seagreen]
we[vbcol=seagreen]
if[vbcol=seagreen]
structure(the[vbcol=seagreen]
We're planning to rewrite a program of ours from ms-dos with a dbase
database to windows using ado and msaccess or sqlserver 2000. now we have
the problem of database maintenance. because the program is going to be
deployed to multiple customers, we don't want to manually change the
database structure. In dos we had a mechanism with a table which stored the
table definitions, and a table which stored the index definitions. now we
want something similiar to that for windows, and it would be even nicer if
the solution is crossdatabase. it's fine if the "new" database structure(the
structure which the customer doesn't have) is stored in an xml file or
similar.
thanks in advance,
Matthijs ter Woord
if you want to version your databases check out DB Ghost - www.dbghost.com
"M. ter Woord" wrote:
> Hi,
> We're planning to rewrite a program of ours from ms-dos with a dbase
> database to windows using ado and msaccess or sqlserver 2000. now we have
> the problem of database maintenance. because the program is going to be
> deployed to multiple customers, we don't want to manually change the
> database structure. In dos we had a mechanism with a table which stored the
> table definitions, and a table which stored the index definitions. now we
> want something similiar to that for windows, and it would be even nicer if
> the solution is crossdatabase. it's fine if the "new" database structure(the
> structure which the customer doesn't have) is stored in an xml file or
> similar.
>
> thanks in advance,
> Matthijs ter Woord
>
>
|||Can somebody think of a solution which i can build myself?
Matthijs
"mark baekdal" <markbaekdal@.discussions.microsoft.com> schreef in bericht
news:821F7892-552F-4784-9D0A-A3E36D615735@.microsoft.com...
> if you want to version your databases check out DB Ghost -
www.dbghost.com[vbcol=seagreen]
> "M. ter Woord" wrote:
have[vbcol=seagreen]
the[vbcol=seagreen]
we[vbcol=seagreen]
if[vbcol=seagreen]
structure(the[vbcol=seagreen]
Subscribe to:
Posts (Atom)