Copying data

Hello,
I need to copy from around 9 specific tables in one database (A) to another
database (B). Database B contains an exact image of those 9 tables.
Here is my requirement -
1) Altogether there could be around 4 million records across those tables.
2) The data would be moved from A to B every night.
3) Using SSIS is not an option as I would not be able to call this from Ax.
But I will
be able to call stored procs, statements etc.
Could anyone suggest me an optimum solution please?
Many thanks,
Harish Mohanbabu
Microsoft Dynamics Ax [MVP]
http://www.harishm.com/
Sorry - my mistake.
Tables in database B is not an exact mirror image. Those 9 tables contain 2
new columns which is not there in Database A.
Harish Mohanbabu
Microsoft Dynamics Ax [MVP]
http://www.harishm.com/
"Harish Mohanbabu" wrote:

> Hello,
> I need to copy from around 9 specific tables in one database (A) to another
> database (B). Database B contains an exact image of those 9 tables.
> Here is my requirement -
> 1) Altogether there could be around 4 million records across those tables.
> 2) The data would be moved from A to B every night.
> 3) Using SSIS is not an option as I would not be able to call this from Ax.
> But I will
> be able to call stored procs, statements etc.
> Could anyone suggest me an optimum solution please?
> Many thanks,
> Harish Mohanbabu
> --
> Microsoft Dynamics Ax [MVP]
> http://www.harishm.com/

Copying data

Hello,
I need to copy from around 9 specific tables in one database (A) to another
database (B). Database B contains an exact image of those 9 tables.
Here is my requirement -
1) Altogether there could be around 4 million records across those tables.
2) The data would be moved from A to B every night.
3) Using SSIS is not an option as I would not be able to call this from Ax.
But I will
be able to call stored procs, statements etc.
Could anyone suggest me an optimum solution please?
Many thanks,
Harish Mohanbabu
--
Microsoft Dynamics Ax [MVP]
http://www.harishm.com/Sorry - my mistake.
Tables in database B is not an exact mirror image. Those 9 tables contain 2
new columns which is not there in Database A.
Harish Mohanbabu
--
Microsoft Dynamics Ax [MVP]
http://www.harishm.com/
"Harish Mohanbabu" wrote:

> Hello,
> I need to copy from around 9 specific tables in one database (A) to anothe
r
> database (B). Database B contains an exact image of those 9 tables.
> Here is my requirement -
> 1) Altogether there could be around 4 million records across those tables.
> 2) The data would be moved from A to B every night.
> 3) Using SSIS is not an option as I would not be able to call this from Ax
.
> But I will
> be able to call stored procs, statements etc.
> Could anyone suggest me an optimum solution please?
> Many thanks,
> Harish Mohanbabu
> --
> Microsoft Dynamics Ax [MVP]
> http://www.harishm.com/

Copying data

Hello,
I need to copy from around 9 specific tables in one database (A) to another
database (B). Database B contains an exact image of those 9 tables.
Here is my requirement -
1) Altogether there could be around 4 million records across those tables.
2) The data would be moved from A to B every night.
3) Using SSIS is not an option as I would not be able to call this from Ax.
But I will
be able to call stored procs, statements etc.
Could anyone suggest me an optimum solution please?
Many thanks,
Harish Mohanbabu
--
Microsoft Dynamics Ax [MVP]
http://www.harishm.com/Sorry - my mistake.
Tables in database B is not an exact mirror image. Those 9 tables contain 2
new columns which is not there in Database A.
Harish Mohanbabu
--
Microsoft Dynamics Ax [MVP]
http://www.harishm.com/
"Harish Mohanbabu" wrote:
> Hello,
> I need to copy from around 9 specific tables in one database (A) to another
> database (B). Database B contains an exact image of those 9 tables.
> Here is my requirement -
> 1) Altogether there could be around 4 million records across those tables.
> 2) The data would be moved from A to B every night.
> 3) Using SSIS is not an option as I would not be able to call this from Ax.
> But I will
> be able to call stored procs, statements etc.
> Could anyone suggest me an optimum solution please?
> Many thanks,
> Harish Mohanbabu
> --
> Microsoft Dynamics Ax [MVP]
> http://www.harishm.com/

Copy to CD

Hi there,
Is there anyway to export an exact version of a database to CD so i can then go to another site and import the image of the database onto their server. Ive tried but cant find the best file format and also i keep getting problems such as auto increments d
ont get carried across in the table design. Hope someone can help me out.
JP
James,
if you mean from the point of view of replication, have a look at
"subscription databases, copying" in BOL. If this is a general query then
it's just backup and restore.
Regards,
Paul Ibison
|||is you are doing a subscription copy make sure your db is under 2Gb.
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:ez1re6lGEHA.1228@.TK2MSFTNGP11.phx.gbl...
> James,
> if you mean from the point of view of replication, have a look at
> "subscription databases, copying" in BOL. If this is a general query then
> it's just backup and restore.
> Regards,
> Paul Ibison
>