June 24, 2008 at 8:24 am
hi,
To migrate data from Access to Sql Server we have option
SSMA
-----
With this the entire data along schema will be created to some database.mdb in the sql which will act like an staging database later we can write scripts or stored procedures for migrating the data from denormalised database to an Normalised Database ie.., 1 table to 4 tables
my doubt is initially i have migrated the AccessDatabase ie.., Access1.mdb to Sql.mdb by writing scripts or stored procedures
let us say i have migrated 100 rows of data
Now again i have given the another access database file ie.., Access2.mdb which has the same schema with Access1.mdb
ie.., Incremental migration . to follow this is there any standards do i have to follow in migrating the data
do i have to take a full back back up after migrating the Access1.mdb and later i have to migrate Access2.mdb with the steps that are mentioned as above
could u please suggest me best way to migrate incremental databases
Regards,
Pandu
June 24, 2008 at 10:07 am
Is it possible for you take backup of Access DB and restore it into SQL 2005 server? This is the way that you can restore it into SQL2005.
Let us know, if have any issue while migrating from Access to SQL2k5.
MCP, MCTS (GDBA/EDA)
June 24, 2008 at 11:15 pm
Hi Manoj,
I have migrated the data from Access to Sql Server 2005. The Issue is i was given with 2 Access databse files ie.., db1.mdb(Present in client base location1) , db2.mdb(Present in Client base location2) both has got the same schemas .
Intially i migrated the db1 with the stored procedures written to sql server to a database sqldb1.mdb, i need to use the same stored procedures to migrate the db2.mdb to sqldb1.mdb at this point do i need to take full back up of the data from sql server after migrating the database file db1.mdb.
After migrating the 2 db files i can maintian the centralised database, that is what i need to do after migrating . my problem is do i need to take fullbackup after migrating the db1 file
July 3, 2008 at 12:35 pm
Hello,
could you give an example of stored procedure to migrate access data to sql server 2005?
Thanks
Cris
July 3, 2008 at 1:37 pm
Why you want Stored Proc, You can do it from DTS or SSIS package. No need to write a SP or any other things.
MCP, MCTS (GDBA/EDA)
July 3, 2008 at 1:41 pm
satish.edms (6/24/2008)
Hi Manoj,I have migrated the data from Access to Sql Server 2005. The Issue is i was given with 2 Access databse files ie.., db1.mdb(Present in client base location1) , db2.mdb(Present in Client base location2) both has got the same schemas .
Intially i migrated the db1 with the stored procedures written to sql server to a database sqldb1.mdb, i need to use the same stored procedures to migrate the db2.mdb to sqldb1.mdb at this point do i need to take full back up of the data from sql server after migrating the database file db1.mdb.
After migrating the 2 db files i can maintian the centralised database, that is what i need to do after migrating . my problem is do i need to take fullbackup after migrating the db1 file
Once you Migrate the Database from Access to SQL server It means you have now SQL Database. For make sure you can just check the Health of the DB and also check the .mdf and .log file on the given path.(To check for the Databse is in SQL or not).
MCP, MCTS (GDBA/EDA)
July 3, 2008 at 9:55 pm
Manoj (6/24/2008)
Is it possible for you take backup of Access DB and restore it into SQL 2005 server?
This is not possible, please check your advice before posting.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply