synchronizing fc5 databases

View: New views
3 Messages — Rating Filter:   Alert me  

synchronizing fc5 databases

by Rune Pedersen :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message


Hi

Can someone give some hints about synchronizing fc5 databases from
local mssql to web server mssql.
Thanks
Rune

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "farcry-dev" group.
To post to this group, send email to farcry-dev@...
To unsubscribe from this group, send email to farcry-dev-unsubscribe@...
For more options, visit this group at http://groups.google.com/group/farcry-dev?hl=en
-~----------~----~----~----~------~----~------~--~---


Re: synchronizing fc5 databases

by modius :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message


On Jun 17, 2:56 am, Rune <rup...@...> wrote:
> Can someone give some hints about synchronizing fc5 databases from
> local mssql to web server mssql.

Moving:
Back-up and restore in SQL is going to be easiest.  Or detach and
reattach if you can stop the db.

Synching:
This is way more trouble than its worth -- but MSSQL has options.

-- geoff
http://www.daemon.com.au/
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "farcry-dev" group.
To post to this group, send email to farcry-dev@...
To unsubscribe from this group, send email to farcry-dev-unsubscribe@...
For more options, visit this group at http://groups.google.com/group/farcry-dev?hl=en
-~----------~----~----~----~------~----~------~--~---


Re: synchronizing fc5 databases

by whitec :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message


Another thing you can do is if you have SQL Server 2000 you may use
Enterprise Manager to DTS (Data Transfer Service) from one server to
another.  You choose the database then Export Data then you would choose to
copy all objects and it creates and copies data.  I think the process was
renamed to something different with SQL Server 2005 but still found under
Exporting data.

Chris

-----Original Message-----
From: farcry-dev@... [mailto:farcry-dev@...] On
Behalf Of modius
Sent: Monday, June 16, 2008 7:34 PM
To: farcry-dev
Subject: [farcry-dev] Re: synchronizing fc5 databases


On Jun 17, 2:56 am, Rune <rup...@...> wrote:
> Can someone give some hints about synchronizing fc5 databases from
> local mssql to web server mssql.

Moving:
Back-up and restore in SQL is going to be easiest.  Or detach and
reattach if you can stop the db.

Synching:
This is way more trouble than its worth -- but MSSQL has options.

-- geoff
http://www.daemon.com.au/


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "farcry-dev" group.
To post to this group, send email to farcry-dev@...
To unsubscribe from this group, send email to farcry-dev-unsubscribe@...
For more options, visit this group at http://groups.google.com/group/farcry-dev?hl=en
-~----------~----~----~----~------~----~------~--~---