I have a program installation setup that comes with a default MS Access Database. How do I attach this default database into MSDE on my server?
Message posted via http://www.sqlmonster.com
You cannot attach Access databse file (*.mdb/*.mde) to SQL Server/MSDE, they
are completely different thing , except for being called "database" and
being from MS. But you can use any available tools you know to transfer the
Access database (structure and/or data) to a database on MSDE. If you have
Access2K or later, open the Access *.mdb file, click menu "Tools->Database
Utilities->Upsizing Wizard...". It will lead you to "Upsize" your Access
database to SQL Server/MSDE database. After running the wizard, you may
still need to do some manual changes on the newly created database on MSDE
to make sure PK/Index, data types are OK, and since Access queries may not
may not be transferred into the database on MSDE, you definitely have
re-write some or all of queries you used in the Access file with views or
stored procedures in MSDE.
"Cedric Boo via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:aa84e44efc594341b542ca374dd4a3df@.SQLMonster.c om...
> I have a program installation setup that comes with a default MS Access
Database. How do I attach this default database into MSDE on my server?
> --
> Message posted via http://www.sqlmonster.com
|||Hello,
the upsizing tool crashed for me with a overflow error. I use MSDE2000a, that doesn't include the dtsrunui tool ,( so any help how i get a access db to msde2000a ? I check dtsrun , but im very confused how to use it. How i get the data from the access db,
which is a file not a server like dtsrun expected.
Message posted via http://www.sqlmonster.com
|||hi Alexander,
Alexander Baumgart via SQLMonster.com wrote:
> Hello,
> the upsizing tool crashed for me with a overflow error. I use
> MSDE2000a, that doesn't include the dtsrunui tool ,( so any help how
> i get a access db to msde2000a ? I check dtsrun , but im very
> confused how to use it. How i get the data from the access db, which
> is a file not a server like dtsrun expected.
regarding Access Upswize Wizard problems, please have a look at
http://support.microsoft.com/default...;EN-US;Q237980
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
Showing posts with label setup. Show all posts
Showing posts with label setup. Show all posts
Friday, March 30, 2012
Monday, March 19, 2012
How to add the Column in Table which is in replication
Dear Friends
I have setup a merge replicaion between my two servers
and now i want to add some column in one table kindly
suggest how i can do the same without stoping the
replicaiton.
your earlier reply will guide me to solve the problem.
Best regards
Sharad
Sharad,
have a look in BOL for the command sp_repladdcolumn.
HTH,
Paul Ibison
|||Dear Fiend
Getting the following error.
Server: Msg 8114, Level 16, State 4, Procedure
sp_repladdcolumn, Line 0
Error converting data type nvarchar to bit.
for the code
sp_repladdcolumn @.source_object = 'OTHALLOCATION'
, @.column = 'CCICAPPNUM'
, @.typetext = 'NVARCHAR(50)'
, @.publication_to_add = 'GEMREPLGNETINFOTECH'
, @.schema_change_script = ''
, @.force_invalidate_snapshot =
force_invalidate_snapshot
, @.force_reinit_subscription =
force_reinit_subscription
Please suggest.
Best regards
Shailesh
>--Original Message--
>Sharad,
>have a look in BOL for the command sp_repladdcolumn.
>HTH,
>Paul Ibison
>
>.
>
|||Shailesh,
please can you try this script instead:
sp_repladdcolumn @.source_object = 'OTHALLOCATION'
, @.column = 'CCICAPPNUM'
, @.typetext = 'NVARCHAR(50) NULL'
, @.publication_to_add = 'GEMREPLGNETINFOTECH'
HTH,
Paul Ibison
I have setup a merge replicaion between my two servers
and now i want to add some column in one table kindly
suggest how i can do the same without stoping the
replicaiton.
your earlier reply will guide me to solve the problem.
Best regards
Sharad
Sharad,
have a look in BOL for the command sp_repladdcolumn.
HTH,
Paul Ibison
|||Dear Fiend
Getting the following error.
Server: Msg 8114, Level 16, State 4, Procedure
sp_repladdcolumn, Line 0
Error converting data type nvarchar to bit.
for the code
sp_repladdcolumn @.source_object = 'OTHALLOCATION'
, @.column = 'CCICAPPNUM'
, @.typetext = 'NVARCHAR(50)'
, @.publication_to_add = 'GEMREPLGNETINFOTECH'
, @.schema_change_script = ''
, @.force_invalidate_snapshot =
force_invalidate_snapshot
, @.force_reinit_subscription =
force_reinit_subscription
Please suggest.
Best regards
Shailesh
>--Original Message--
>Sharad,
>have a look in BOL for the command sp_repladdcolumn.
>HTH,
>Paul Ibison
>
>.
>
|||Shailesh,
please can you try this script instead:
sp_repladdcolumn @.source_object = 'OTHALLOCATION'
, @.column = 'CCICAPPNUM'
, @.typetext = 'NVARCHAR(50) NULL'
, @.publication_to_add = 'GEMREPLGNETINFOTECH'
HTH,
Paul Ibison
Labels:
column,
database,
dear,
friendsi,
kindlysuggest,
merge,
microsoft,
mysql,
oracle,
replicaion,
replication,
server,
serversand,
setup,
sql,
table
Monday, March 12, 2012
How to add more tables to publishing database in transactional replication
I have setup the transactional replication with one table which is
working fine. I need more tables to publishing database in order to
test it. How to do this?
Thanks in advance
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
sp_addarticle. You can also right click on the publication, select
publication properties, click on the articles tab, and then select show
unpublished objects, and then start to add more articles.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Lance kepart" <lance4848@.yahoo.com> wrote in message
news:exxUNUsGFHA.3916@.TK2MSFTNGP12.phx.gbl...
> I have setup the transactional replication with one table which is
> working fine. I need more tables to publishing database in order to
> test it. How to do this?
> Thanks in advance
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
working fine. I need more tables to publishing database in order to
test it. How to do this?
Thanks in advance
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
sp_addarticle. You can also right click on the publication, select
publication properties, click on the articles tab, and then select show
unpublished objects, and then start to add more articles.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Lance kepart" <lance4848@.yahoo.com> wrote in message
news:exxUNUsGFHA.3916@.TK2MSFTNGP12.phx.gbl...
> I have setup the transactional replication with one table which is
> working fine. I need more tables to publishing database in order to
> test it. How to do this?
> Thanks in advance
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
Labels:
database,
isworking,
microsoft,
mysql,
oracle,
order,
publishing,
replication,
server,
setup,
sql,
table,
tables,
totest,
transactional
Subscribe to:
Posts (Atom)